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 change_notice is null --added for bug 9673701
551: AND upper(transaction_type) in (G_Delete, G_Update)

Line 559: FROM bom_components_b BIC2

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

Line 815: FROM bom_components_b BIC

811: /* Update the component_sequence_id */
812: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
813: SET COMPONENT_SEQUENCE_ID
814: = (SELECT COMPONENT_SEQUENCE_ID
815: FROM bom_components_b BIC
816: Where BIC.bill_sequence_id = BICI.bill_Sequence_id
817: And BIC.component_item_id = BICI.component_item_id
818: AND BIC.operation_seq_num = BICI.operation_seq_num
819: AND BIC.effectivity_date = BICI.effectivity_date)

Line 1127: FROM bom_components_b BIC1

1123: SET(bill_sequence_id, component_item_id, effectivity_date,
1124: operation_seq_num, from_end_item_unit_number)
1125: = (SELECT bill_sequence_id, component_item_id,
1126: effectivity_date, operation_seq_num, from_end_item_unit_number
1127: FROM bom_components_b BIC1
1128: WHERE BIC1.component_sequence_id = BRDI.component_sequence_id )
1129: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1130: AND change_notice is null --added for bug 9673701
1131: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 1139: FROM bom_components_b BIC2

1135: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1136: OR ( p_batch_id = BRDI.batch_id )
1137: )
1138: AND exists (SELECT 'x'
1139: FROM bom_components_b BIC2
1140: WHERE BIC2.COMPONENT_SEQUENCE_ID = BRDI.COMPONENT_SEQUENCE_ID );
1141:
1142:
1143: stmt_num := 2;

Line 1406: FROM bom_components_b BIC1

1402: SET(bill_sequence_id, component_item_id, effectivity_date,
1403: operation_seq_num, from_end_item_unit_number)
1404: = (select bill_sequence_id, component_item_id,
1405: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER
1406: FROM bom_components_b BIC1
1407: WHERE BIC1.COMPONENT_SEQUENCE_ID = BSCI.component_sequence_id )
1408: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1409: AND change_notice is null --added for bug 9673701
1410: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)

Line 1418: FROM bom_components_b BIC2

1414: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1415: OR ( p_batch_id = BSCI.batch_id )
1416: )
1417: AND exists (SELECT 'x'
1418: FROM bom_components_b BIC2
1419: WHERE BIC2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID );
1420:
1421:
1422: stmt_num := 2;

Line 1734: FROM bom_components_b BIC1

1730: SET(bill_sequence_id, component_item_id, effectivity_date,
1731: operation_seq_num, from_end_item_unit_number)
1732: = (SELECT bill_sequence_id, component_item_id,
1733: effectivity_date, operation_seq_num, from_end_item_unit_number
1734: FROM bom_components_b BIC1
1735: WHERE BIC1.component_sequence_id = BCOI.component_sequence_id )
1736: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
1737: AND upper(transaction_type) in (G_Delete, G_Update, G_Create)
1738: AND COMPONENT_SEQUENCE_ID is not null

Line 2778: FROM bom_components_b BIC

2774: /* Update the component_sequence_id */
2775: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2776: SET COMPONENT_SEQUENCE_ID
2777: = (SELECT COMPONENT_SEQUENCE_ID
2778: FROM bom_components_b BIC
2779: WHERE BIC.bill_sequence_id = BRDI.bill_Sequence_id
2780: AND BIC.component_item_id = BRDI.component_item_id
2781: AND BIC.operation_seq_num = BRDI.operation_seq_num
2782: AND BIC.effectivity_date = BRDI.effectivity_date)