APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_COMPONENTS_B

Line 547: FROM bom_components_b BIC1

543: SET(bill_sequence_id, component_item_id, effectivity_date,
544: operation_seq_num, from_end_item_unit_number)
545: = (SELECT bill_sequence_id, component_item_id,
546: effectivity_date, operation_seq_num, from_end_item_unit_number
547: FROM bom_components_b BIC1
548: WHERE BIC1.component_sequence_id = BICI.component_sequence_id )
549: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
550: AND upper(transaction_type) in (G_Delete, G_Update)
551: AND component_sequence_id is not null

Line 558: FROM bom_components_b BIC2

554: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
555: OR ( p_batch_id = BICI.batch_id )
556: )
557: AND exists (SELECT 'x'
558: FROM bom_components_b BIC2
559: WHERE BIC2.component_sequence_id = BICI.component_sequence_id );
560:
561:
562: stmt_num := 2;

Line 803: FROM bom_components_b BIC

799: /* Update the component_sequence_id */
800: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
801: SET COMPONENT_SEQUENCE_ID
802: = (SELECT COMPONENT_SEQUENCE_ID
803: FROM bom_components_b BIC
804: Where BIC.bill_sequence_id = BICI.bill_Sequence_id
805: And BIC.component_item_id = BICI.component_item_id
806: AND BIC.operation_seq_num = BICI.operation_seq_num
807: AND BIC.effectivity_date = BICI.effectivity_date)

Line 1109: FROM bom_components_b BIC1

1105: SET(bill_sequence_id, component_item_id, effectivity_date,
1106: operation_seq_num, from_end_item_unit_number)
1107: = (SELECT bill_sequence_id, component_item_id,
1108: effectivity_date, operation_seq_num, from_end_item_unit_number
1109: FROM bom_components_b BIC1
1110: WHERE BIC1.component_sequence_id = BRDI.component_sequence_id )
1111: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1112: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1113: AND COMPONENT_SEQUENCE_ID is not null

Line 1120: FROM bom_components_b BIC2

1116: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1117: OR ( p_batch_id = BRDI.batch_id )
1118: )
1119: AND exists (SELECT 'x'
1120: FROM bom_components_b BIC2
1121: WHERE BIC2.COMPONENT_SEQUENCE_ID = BRDI.COMPONENT_SEQUENCE_ID );
1122:
1123:
1124: stmt_num := 2;

Line 1379: FROM bom_components_b BIC1

1375: SET(bill_sequence_id, component_item_id, effectivity_date,
1376: operation_seq_num, from_end_item_unit_number)
1377: = (select bill_sequence_id, component_item_id,
1378: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER
1379: FROM bom_components_b BIC1
1380: WHERE BIC1.COMPONENT_SEQUENCE_ID = BSCI.component_sequence_id )
1381: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1382: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1383: AND COMPONENT_SEQUENCE_ID is not null

Line 1390: FROM bom_components_b BIC2

1386: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1387: OR ( p_batch_id = BSCI.batch_id )
1388: )
1389: AND exists (SELECT 'x'
1390: FROM bom_components_b BIC2
1391: WHERE BIC2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID );
1392:
1393:
1394: stmt_num := 2;

Line 1696: FROM bom_components_b BIC1

1692: SET(bill_sequence_id, component_item_id, effectivity_date,
1693: operation_seq_num, from_end_item_unit_number)
1694: = (SELECT bill_sequence_id, component_item_id,
1695: effectivity_date, operation_seq_num, from_end_item_unit_number
1696: FROM bom_components_b BIC1
1697: WHERE BIC1.component_sequence_id = BCOI.component_sequence_id )
1698: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1699: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1700: AND COMPONENT_SEQUENCE_ID is not null

Line 2734: FROM bom_components_b BIC

2730: /* Update the component_sequence_id */
2731: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2732: SET COMPONENT_SEQUENCE_ID
2733: = (SELECT COMPONENT_SEQUENCE_ID
2734: FROM bom_components_b BIC
2735: WHERE BIC.bill_sequence_id = BRDI.bill_Sequence_id
2736: AND BIC.component_item_id = BRDI.component_item_id
2737: AND BIC.operation_seq_num = BRDI.operation_seq_num
2738: AND BIC.effectivity_date = BRDI.effectivity_date)