APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_BILL_OF_MATERIALS

Line 321: FROM bom_bill_of_materials bom, mtl_system_items_vl mvll

317:
318: stmt_num := 9.7;
319: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
320: SET bill_sequence_id = (SELECT bill_sequence_id
321: FROM bom_bill_of_materials bom, mtl_system_items_vl mvll
322: WHERE mvll.concatenated_segments = BBMI.item_number
323: AND mvll.organization_id = BBMI.organization_id
324: AND bom.assembly_item_id = mvll.inventory_item_id
325: AND bom.organization_id = mvll.organization_id

Line 2632: FROM BOM_BILL_OF_MATERIALS BBM1

2628:
2629: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2630: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2631: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2632: FROM BOM_BILL_OF_MATERIALS BBM1
2633: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)
2634: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2635: AND bill_sequence_id is not null
2636: AND

Line 2642: FROM BOM_BILL_OF_MATERIALS BBM2

2638: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2639: OR ( p_batch_id = BRDI.batch_id )
2640: )
2641: AND exists (SELECT 'x'
2642: FROM BOM_BILL_OF_MATERIALS BBM2
2643: WHERE BBM2.bill_sequence_id = BRDI.bill_sequence_id);
2644:
2645:
2646: /* Update Organization Code using Organization_id

Line 2898: FROM BOM_BILL_OF_MATERIALS BBM1

2894:
2895: UPDATE bom_sub_comps_interface BSCI
2896: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2897: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2898: FROM BOM_BILL_OF_MATERIALS BBM1
2899: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)
2900: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2901: AND bill_sequence_id is not null
2902: AND

Line 2908: FROM BOM_BILL_OF_MATERIALS BBM2

2904: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2905: OR ( p_batch_id = BSCI.batch_id )
2906: )
2907: AND exists (SELECT 'x'
2908: FROM BOM_BILL_OF_MATERIALS BBM2
2909: WHERE BBM2.bill_sequence_id = BSCI.bill_sequence_id);
2910:
2911:
2912: /* Update Organization Code using Organization_id

Line 3025: FROM bom_bill_of_materials bom

3021:
3022: /* Set the Bill Seqeunce Ids */
3023: UPDATE bom_sub_comps_interface BSCI
3024: SET bill_sequence_id = (SELECT bill_sequence_id
3025: FROM bom_bill_of_materials bom
3026: WHERE bom.assembly_item_id = BSCI.assembly_item_id
3027: AND bom.organization_id = BSCI.organization_id
3028: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BSCI.alternate_bom_designator,FND_API.G_MISS_CHAR))
3029: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import