DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on BOM_BILL_OF_MATERIALS

Line 1391: FROM BOM_BILL_OF_MATERIALS BOM,

1387: stmt_num := 1;
1388: UPDATE BOM_INVENTORY_COMPONENTS
1389: SET OPERATION_SEQ_NUM = 1
1390: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1391: FROM BOM_BILL_OF_MATERIALS BOM,
1392: BOM_OPERATIONAL_ROUTINGS BOR
1393: WHERE BOR.ROUTING_SEQUENCE_ID = routing_seq_id
1394: AND BOR.ORGANIZATION_ID = BOM.ORGANIZATION_ID
1395: AND BOR.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 1403: FROM BOM_BILL_OF_MATERIALS BOM,

1399: stmt_num := 2;
1400: UPDATE BOM_INVENTORY_COMPONENTS BIC
1401: SET OPERATION_SEQ_NUM = 1
1402: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1403: FROM BOM_BILL_OF_MATERIALS BOM,
1404: BOM_OPERATIONAL_ROUTINGS BOR
1405: WHERE BOR.ROUTING_SEQUENCE_ID = routing_seq_id
1406: AND BOR.ORGANIZATION_ID = BOM.ORGANIZATION_ID
1407: AND BOR.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID