DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on BOM_BILL_OF_MATERIALS

Line 1396: FROM BOM_BILL_OF_MATERIALS BOM,

1392: stmt_num := 1;
1393: UPDATE BOM_INVENTORY_COMPONENTS
1394: SET OPERATION_SEQ_NUM = 1
1395: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1396: FROM BOM_BILL_OF_MATERIALS BOM,
1397: BOM_OPERATIONAL_ROUTINGS BOR
1398: WHERE BOR.ROUTING_SEQUENCE_ID = routing_seq_id
1399: AND BOR.ORGANIZATION_ID = BOM.ORGANIZATION_ID
1400: AND BOR.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 1408: FROM BOM_BILL_OF_MATERIALS BOM,

1404: stmt_num := 2;
1405: UPDATE BOM_INVENTORY_COMPONENTS BIC
1406: SET OPERATION_SEQ_NUM = 1
1407: WHERE BILL_SEQUENCE_ID = (SELECT BILL_SEQUENCE_ID
1408: FROM BOM_BILL_OF_MATERIALS BOM,
1409: BOM_OPERATIONAL_ROUTINGS BOR
1410: WHERE BOR.ROUTING_SEQUENCE_ID = routing_seq_id
1411: AND BOR.ORGANIZATION_ID = BOM.ORGANIZATION_ID
1412: AND BOR.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID