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 2588: FROM BOM_BILL_OF_MATERIALS BBM1

2584:
2585: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2586: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2587: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2588: FROM BOM_BILL_OF_MATERIALS BBM1
2589: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)
2590: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2591: AND bill_sequence_id is not null
2592: AND

Line 2598: FROM BOM_BILL_OF_MATERIALS BBM2

2594: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2595: OR ( p_batch_id = BRDI.batch_id )
2596: )
2597: AND exists (SELECT 'x'
2598: FROM BOM_BILL_OF_MATERIALS BBM2
2599: WHERE BBM2.bill_sequence_id = BRDI.bill_sequence_id);
2600:
2601:
2602: /* Update Organization Code using Organization_id

Line 2854: FROM BOM_BILL_OF_MATERIALS BBM1

2850:
2851: UPDATE bom_sub_comps_interface BSCI
2852: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2853: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2854: FROM BOM_BILL_OF_MATERIALS BBM1
2855: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)
2856: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2857: AND bill_sequence_id is not null
2858: AND

Line 2864: FROM BOM_BILL_OF_MATERIALS BBM2

2860: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2861: OR ( p_batch_id = BSCI.batch_id )
2862: )
2863: AND exists (SELECT 'x'
2864: FROM BOM_BILL_OF_MATERIALS BBM2
2865: WHERE BBM2.bill_sequence_id = BSCI.bill_sequence_id);
2866:
2867:
2868: /* Update Organization Code using Organization_id

Line 2981: FROM bom_bill_of_materials bom

2977:
2978: /* Set the Bill Seqeunce Ids */
2979: UPDATE bom_sub_comps_interface BSCI
2980: SET bill_sequence_id = (SELECT bill_sequence_id
2981: FROM bom_bill_of_materials bom
2982: WHERE bom.assembly_item_id = BSCI.assembly_item_id
2983: AND bom.organization_id = BSCI.organization_id
2984: AND NVL(bom.alternate_bom_designator,FND_API.G_MISS_CHAR) = NVL(BSCI.alternate_bom_designator,FND_API.G_MISS_CHAR))
2985: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import