APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_INVENTORY_COMPONENTS

Line 1707: FROM BOM_INVENTORY_COMPONENTS BIC2

1703: ( (p_batch_id IS NULL) AND (BCOI.batch_id IS NULL) )
1704: OR ( p_batch_id = BCOI.batch_id )
1705: )
1706: AND exists (SELECT 'x'
1707: FROM BOM_INVENTORY_COMPONENTS BIC2
1708: WHERE BIC2.COMPONENT_SEQUENCE_ID = BCOI.COMPONENT_SEQUENCE_ID );
1709:
1710:
1711: stmt_num := 2;

Line 2207: FROM BOM_INVENTORY_COMPONENTS BIC2

2203: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2204: OR ( p_batch_id = BICI.batch_id )
2205: )
2206: AND EXISTS (SELECT 'x'
2207: FROM BOM_INVENTORY_COMPONENTS BIC2
2208: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2209:
2210: /* If SYNC rows don't have ComponentSequenceId value then update the transaction type to CREATE */
2211: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI SET transaction_type = G_Create

Line 2361: FROM BOM_INVENTORY_COMPONENTS BIC1

2357: SET(component_item_id, effectivity_date,
2358: operation_seq_num, from_end_item_unit_number)
2359: = (SELECT component_item_id,
2360: effectivity_date, operation_seq_num, from_end_item_unit_number
2361: FROM BOM_INVENTORY_COMPONENTS BIC1
2362: WHERE BIC1.component_sequence_id = BICI.component_sequence_id )
2363: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2364: AND UPPER(transaction_type) IN (G_Delete, G_Update)
2365: AND component_sequence_id IS NOT NULL

Line 2372: FROM BOM_INVENTORY_COMPONENTS BIC2

2368: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2369: OR ( p_batch_id = BICI.batch_id )
2370: )
2371: AND EXISTS (SELECT 'x'
2372: FROM BOM_INVENTORY_COMPONENTS BIC2
2373: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
2374:
2375:
2376: /* Update the component_sequence_id */

Line 2380: FROM BOM_INVENTORY_COMPONENTS BIC

2376: /* Update the component_sequence_id */
2377: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2378: SET COMPONENT_SEQUENCE_ID
2379: = (SELECT COMPONENT_SEQUENCE_ID
2380: FROM BOM_INVENTORY_COMPONENTS BIC
2381: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id
2382: AND BIC.component_item_id = BICI.component_item_id
2383: AND BIC.operation_seq_num = BICI.operation_seq_num
2384: AND BIC.effectivity_date = BICI.effectivity_date)

Line 2396: FROM BOM_INVENTORY_COMPONENTS BIC

2392: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2393: OR ( p_batch_id = BICI.batch_id )
2394: )
2395: AND EXISTS (SELECT 'x'
2396: FROM BOM_INVENTORY_COMPONENTS BIC
2397: WHERE BIC.bill_sequence_id = BICI.bill_Sequence_id
2398: AND BIC.component_item_id = BICI.component_item_id
2399: AND BIC.operation_seq_num = BICI.operation_seq_num
2400: AND BIC.effectivity_date = BICI.effectivity_date);

Line 2569: FROM BOM_INVENTORY_COMPONENTS BIC1

2565: SET(bill_sequence_id, component_item_id, effectivity_date,
2566: operation_seq_num, from_end_item_unit_number)
2567: = (SELECT bill_sequence_id, component_item_id,
2568: effectivity_date, operation_seq_num, from_end_item_unit_number
2569: FROM BOM_INVENTORY_COMPONENTS BIC1
2570: WHERE BIC1.component_sequence_id = BRDI.component_sequence_id )
2571: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2572: AND COMPONENT_SEQUENCE_ID is not null
2573: AND

Line 2579: FROM BOM_INVENTORY_COMPONENTS BIC2

2575: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
2576: OR ( p_batch_id = BRDI.batch_id )
2577: )
2578: AND exists (SELECT 'x'
2579: FROM BOM_INVENTORY_COMPONENTS BIC2
2580: WHERE BIC2.COMPONENT_SEQUENCE_ID = BRDI.COMPONENT_SEQUENCE_ID );
2581:
2582:
2583: /* Resolve the Bill sequence ids for updates and deletes */

Line 2834: FROM BOM_INVENTORY_COMPONENTS BIC1

2830: SET(bill_sequence_id, component_item_id, effectivity_date,
2831: operation_seq_num, from_end_item_unit_number)
2832: = (select bill_sequence_id, component_item_id,
2833: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER
2834: FROM BOM_INVENTORY_COMPONENTS BIC1
2835: WHERE BIC1.COMPONENT_SEQUENCE_ID = BSCI.component_sequence_id )
2836: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2837: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
2838: AND COMPONENT_SEQUENCE_ID is not null

Line 2845: FROM BOM_INVENTORY_COMPONENTS BIC2

2841: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
2842: OR ( p_batch_id = BSCI.batch_id )
2843: )
2844: AND exists (SELECT 'x'
2845: FROM BOM_INVENTORY_COMPONENTS BIC2
2846: WHERE BIC2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID );
2847:
2848:
2849: /* Resolve the Bill sequence ids for updates and deletes */

Line 3000: FROM BOM_INVENTORY_COMPONENTS BIC

2996: /* Update the component_sequence_id */
2997: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
2998: SET COMPONENT_SEQUENCE_ID
2999: = (SELECT COMPONENT_SEQUENCE_ID
3000: FROM BOM_INVENTORY_COMPONENTS BIC
3001: WHERE BIC.bill_sequence_id = BSCI.bill_Sequence_id
3002: AND BIC.component_item_id = BSCI.component_item_id
3003: AND BIC.operation_seq_num = BSCI.operation_seq_num
3004: AND BIC.effectivity_date = BSCI.effectivity_date)