ORACLE ERP & APPS TECH

Query to get Tree structure of the indented BOM along with Vendor for the Purchased items and Item type SELECT DISTINCT LPAD (' ', LEVEL * 2) || LEVEL ORDER_LEVEL               , LPAD (' ', LEVEL * 1) || msib.segment1 ASSEMBLY_ITEM               , LPAD (' ', LEVEL * 4) || msib2.segment1 AS COMPONENT_ITEM               , msib2.description COMPONENT_ITEM_DESCRIPTION               , bic.bill_sequence_id c, bom.bill_sequence_id b                           , msib.description ASSEMBLY_DESCRIPTION               , msib.inventory_item_status_code ASSEMBLY_ITEM_STATUS                 , decode (msib2.PLANNING_MAKE_BUY_CODE, 1, 'MAKE'                       ...

WIP Jobs and Schedules Open Interface  The WIP Mass Load program does all of the following:   Validates the data in the Interface   table   Derives values for additional columns   Creates new discrete jobs, updates existing jobs, schedules and/or creates pending repetitive schedules   Optionally launches the Job and Schedule Interface Report (WIPMLINT)   Deletes successfully processed records from the interface table  Failed records can be resubmitted using the Pending Jobs and Schedules window.  All processing is initiated via the Import Jobs and Schedules window and managed by the concurrent manager. Open Interface : Jobs and Schedule Interface Base Tables: WIP_DISCRETE_JOBS WIP_ENTITIES WIP_OPERATIONS Interface Tables: WIP_JOB_SCHEDULE_INTERFACE -  Table holds   Open Job and Schedule Interface details. Load jobs header information into the WIP_JOB_SCHEDULE_INTERFACE table. WIP_JOB_DTLS_INTERF...