DBA Data[Home] [Help]

APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_BOM_COMPONENTS

Line 1964: MSC_ST_BOM_COMPONENTS msbc

1960: msbc.OLD_COMPONENT_SEQUENCE_ID
1961: FROM MSC_ITEM_ID_LID t1,
1962: MSC_ITEM_ID_LID t2,
1963: MSC_ITEM_ID_LID t3,
1964: MSC_ST_BOM_COMPONENTS msbc
1965: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1966: AND t1.sr_instance_id= msbc.sr_instance_id
1967: AND t2.SR_INVENTORY_ITEM_ID= msbc.using_assembly_id
1968: AND t2.sr_instance_id= msbc.sr_instance_id

Line 1979: FROM MSC_ST_BOM_COMPONENTS msbc

1975: SELECT
1976: msbc.COMPONENT_SEQUENCE_ID,
1977: msbc.BILL_SEQUENCE_ID,
1978: msbc.SR_INSTANCE_ID
1979: FROM MSC_ST_BOM_COMPONENTS msbc
1980: WHERE msbc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1981: AND msbc.DELETED_FLAG= MSC_UTIL.SYS_YES;
1982:
1983:

Line 2225: ||' MSC_ST_BOM_COMPONENTS msbc'

2221: ||' :v_current_user '
2222: ||' FROM MSC_ITEM_ID_LID t1,'
2223: ||' MSC_ITEM_ID_LID t2,'
2224: ||' MSC_ITEM_ID_LID t3,'
2225: ||' MSC_ST_BOM_COMPONENTS msbc'
2226: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2227: ||' AND t1.sr_instance_id = msbc.sr_instance_id'
2228: ||' AND t2.SR_INVENTORY_ITEM_ID = msbc.using_assembly_id'
2229: ||' AND t2.sr_instance_id = msbc.sr_instance_id'