APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_BOMS

Line 1275: FROM MSC_ST_BOMS msb,

1271: TO_NUMBER(NULL),
1272: msb.BILL_SEQUENCE_ID,
1273: t1.INVENTORY_ITEM_ID item_id,
1274: msb.organization_id
1275: FROM MSC_ST_BOMS msb,
1276: msc_item_id_lid t1
1277: WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1278: AND msb.assembly_item_id = t1.SR_INVENTORY_ITEM_ID(+)
1279: AND msb.sr_instance_id = t1.sr_instance_id(+) ;

Line 1585: MSC_ST_BOMS msb

1581: msb.BILL_SEQUENCE_ID,
1582: msb.SR_INSTANCE_ID,
1583: msb.operation_seq_num /* ds change for opm: yielding op seq num */
1584: FROM MSC_ITEM_ID_LID t1,
1585: MSC_ST_BOMS msb
1586: WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id
1587: AND t1.sr_instance_id= msb.sr_instance_id
1588: AND msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1589: AND msb.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 1595: FROM MSC_ST_BOMS msb

1591: CURSOR c2_d IS
1592: SELECT
1593: msb.BILL_SEQUENCE_ID,
1594: msb.SR_INSTANCE_ID
1595: FROM MSC_ST_BOMS msb
1596: WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1597: AND msb.DELETED_FLAG= MSC_UTIL.SYS_YES;
1598:
1599:

Line 1722: ||' MSC_ST_BOMS msb '

1718: ||' :v_current_user,'
1719: ||' :v_current_date,'
1720: ||' :v_current_user '
1721: ||' FROM MSC_ITEM_ID_LID t1,'
1722: ||' MSC_ST_BOMS msb '
1723: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id'
1724: ||' AND t1.sr_instance_id= msb.sr_instance_id'
1725: ||' AND msb.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1726: ||' AND msb.DELETED_FLAG= '||MSC_UTIL.SYS_NO;