APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_INVENTORY_COMPONENTS

Line 1745: FROM BOM_INVENTORY_COMPONENTS BIC2

1741: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1742: OR ( p_batch_id = BCOI.batch_id )
1743: )
1744: AND exists (SELECT 'x'
1745: FROM BOM_INVENTORY_COMPONENTS BIC2
1746: WHERE BIC2.COMPONENT_SEQUENCE_ID = BCOI.COMPONENT_SEQUENCE_ID );
1747:
1748:
1749: stmt_num := 2;

Line 2251: FROM BOM_INVENTORY_COMPONENTS BIC2

2247: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2248: OR ( p_batch_id = BICI.batch_id )
2249: )
2250: AND EXISTS (SELECT 'x'
2251: FROM BOM_INVENTORY_COMPONENTS BIC2
2252: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2253:
2254: /* If SYNC rows don't have ComponentSequenceId value then update the transaction type to CREATE */
2255: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create

Line 2405: FROM BOM_INVENTORY_COMPONENTS BIC1

2401: SET(component_item_id, effectivity_date,
2402: operation_seq_num, from_end_item_unit_number)
2403: = (SELECT component_item_id,
2404: effectivity_date, operation_seq_num, from_end_item_unit_number
2405: FROM BOM_INVENTORY_COMPONENTS BIC1
2406: WHERE BIC1.component_sequence_id = BICI.component_sequence_id )
2407: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2408: AND UPPER(transaction_type) IN (G_Delete, G_Update)
2409: AND component_sequence_id IS NOT NULL

Line 2416: FROM BOM_INVENTORY_COMPONENTS BIC2

2412: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2413: OR ( p_batch_id = BICI.batch_id )
2414: )
2415: AND EXISTS (SELECT 'x'
2416: FROM BOM_INVENTORY_COMPONENTS BIC2
2417: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2418:
2419:
2420: /* Update the component_sequence_id */

Line 2424: FROM BOM_INVENTORY_COMPONENTS BIC

2420: /* Update the component_sequence_id */
2421: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2422: SET COMPONENT_SEQUENCE_ID
2423: = (SELECT COMPONENT_SEQUENCE_ID
2424: FROM BOM_INVENTORY_COMPONENTS BIC
2425: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id
2426: AND BIC.component_item_id = BICI.component_item_id
2427: AND BIC.operation_seq_num = BICI.operation_seq_num
2428: AND BIC.effectivity_date = BICI.effectivity_date)

Line 2440: FROM BOM_INVENTORY_COMPONENTS BIC

2436: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2437: OR ( p_batch_id = BICI.batch_id )
2438: )
2439: AND EXISTS (SELECT 'x'
2440: FROM BOM_INVENTORY_COMPONENTS BIC
2441: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id
2442: AND BIC.component_item_id = BICI.component_item_id
2443: AND BIC.operation_seq_num = BICI.operation_seq_num
2444: AND BIC.effectivity_date = BICI.effectivity_date);

Line 2613: FROM BOM_INVENTORY_COMPONENTS BIC1

2609: SET(bill_sequence_id, component_item_id, effectivity_date,
2610: operation_seq_num, from_end_item_unit_number)
2611: = (SELECT bill_sequence_id, component_item_id,
2612: effectivity_date, operation_seq_num, from_end_item_unit_number
2613: FROM BOM_INVENTORY_COMPONENTS BIC1
2614: WHERE BIC1.component_sequence_id = BRDI.component_sequence_id )
2615: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2616: AND COMPONENT_SEQUENCE_ID is not null
2617: AND

Line 2623: FROM BOM_INVENTORY_COMPONENTS BIC2

2619: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2620: OR ( p_batch_id = BRDI.batch_id )
2621: )
2622: AND exists (SELECT 'x'
2623: FROM BOM_INVENTORY_COMPONENTS BIC2
2624: WHERE BIC2.COMPONENT_SEQUENCE_ID = BRDI.COMPONENT_SEQUENCE_ID );
2625:
2626:
2627: /* Resolve the Bill sequence ids for updates and deletes */

Line 2878: FROM BOM_INVENTORY_COMPONENTS BIC1

2874: SET(bill_sequence_id, component_item_id, effectivity_date,
2875: operation_seq_num, from_end_item_unit_number)
2876: = (select bill_sequence_id, component_item_id,
2877: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER
2878: FROM BOM_INVENTORY_COMPONENTS BIC1
2879: WHERE BIC1.COMPONENT_SEQUENCE_ID = BSCI.component_sequence_id )
2880: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2881: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
2882: AND COMPONENT_SEQUENCE_ID is not null

Line 2889: FROM BOM_INVENTORY_COMPONENTS BIC2

2885: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2886: OR ( p_batch_id = BSCI.batch_id )
2887: )
2888: AND exists (SELECT 'x'
2889: FROM BOM_INVENTORY_COMPONENTS BIC2
2890: WHERE BIC2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID );
2891:
2892:
2893: /* Resolve the Bill sequence ids for updates and deletes */

Line 3044: FROM BOM_INVENTORY_COMPONENTS BIC

3040: /* Update the component_sequence_id */
3041: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3042: SET COMPONENT_SEQUENCE_ID
3043: = (SELECT COMPONENT_SEQUENCE_ID
3044: FROM BOM_INVENTORY_COMPONENTS BIC
3045: WHERE BIC.bill_sequence_id = BSCI.bill_Sequence_id
3046: AND BIC.component_item_id = BSCI.component_item_id
3047: AND BIC.operation_seq_num = BSCI.operation_seq_num
3048: AND BIC.effectivity_date = BSCI.effectivity_date)