DBA Data[Home] [Help]

APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 1570: , MSC_ITEM_ID_LID MIL1

1566: sub_comp.OP_SEQ_NUM,
1567: sub_comp.RATIO,
1568: sub_comp.PLAN_ID
1569: FROM MSC_ST_WO_SUB_COMP sub_comp
1570: , MSC_ITEM_ID_LID MIL1
1571: , MSC_ITEM_ID_LID MIL2
1572: WHERE sub_comp.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
1573: AND MIL1.sr_instance_id = sub_comp.sr_instance_id
1574: AND MIL1.SR_INVENTORY_ITEM_ID = sub_comp.PRIMARY_COMPONENT_ID

Line 1571: , MSC_ITEM_ID_LID MIL2

1567: sub_comp.RATIO,
1568: sub_comp.PLAN_ID
1569: FROM MSC_ST_WO_SUB_COMP sub_comp
1570: , MSC_ITEM_ID_LID MIL1
1571: , MSC_ITEM_ID_LID MIL2
1572: WHERE sub_comp.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
1573: AND MIL1.sr_instance_id = sub_comp.sr_instance_id
1574: AND MIL1.SR_INVENTORY_ITEM_ID = sub_comp.PRIMARY_COMPONENT_ID
1575: AND MIL2.sr_instance_id = sub_comp.sr_instance_id

Line 1657: ||' msc_item_id_lid MIL1,'

1653: ||':v_current_date,'
1654: ||':v_current_user'
1655: ||' FROM MSC_ST_WO_SUB_COMP msw, '
1656: ||lv_supplies_tbl ||' ms, '
1657: ||' msc_item_id_lid MIL1,'
1658: ||' msc_item_id_lid MIL2 '
1659: ||'WHERE msw.SR_INSTANCE_ID= '
1660: ||MSC_CL_COLLECTION.v_instance_id
1661: ||' AND ms.plan_id = -1'

Line 1658: ||' msc_item_id_lid MIL2 '

1654: ||':v_current_user'
1655: ||' FROM MSC_ST_WO_SUB_COMP msw, '
1656: ||lv_supplies_tbl ||' ms, '
1657: ||' msc_item_id_lid MIL1,'
1658: ||' msc_item_id_lid MIL2 '
1659: ||'WHERE msw.SR_INSTANCE_ID= '
1660: ||MSC_CL_COLLECTION.v_instance_id
1661: ||' AND ms.plan_id = -1'
1662: ||' AND ms.SR_INSTANCE_ID = msw.SR_INSTANCE_ID'

Line 1751: ||' FROM MSC_ITEM_ID_LID t1,'

1747: ||' :v_current_date,'
1748: ||' :v_current_user,'
1749: ||' :v_current_date,'
1750: ||' :v_current_user '
1751: ||' FROM MSC_ITEM_ID_LID t1,'
1752: ||' MSC_ST_SUPPLIES ms,'
1753: ||' MSC_DESIGNATORS md'
1754: ||' WHERE t1.SR_INVENTORY_ITEM_ID= -1003'
1755: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'

Line 1874: ||' FROM MSC_ITEM_ID_LID t1,'

1870: ||' :v_current_date,'
1871: ||' :v_current_user,'
1872: ||' :v_current_date,'
1873: ||' :v_current_user '
1874: ||' FROM MSC_ITEM_ID_LID t1,'
1875: ||' MSC_DESIGNATORS md1 ,'
1876: ||' MSC_ST_DEMANDS md,'
1877: || lv_supplies_tbl||' ms'
1878: ||' WHERE ms.MAINTENANCE_OBJECT_SOURCE = 2'

Line 2209: ||' MSC_ITEM_ID_LID mil '

2205: ||':v_current_user,'
2206: ||':v_current_date,'
2207: ||':v_current_user'
2208: ||' FROM MSC_ST_RESERVATIONS ms,'
2209: ||' MSC_ITEM_ID_LID mil '
2210: ||' WHERE ms.SR_INSTANCE_ID= '
2211: ||MSC_CL_COLLECTION.v_instance_id
2212: ||' AND mil.sr_instance_id = ms.sr_instance_id'
2213: ||' AND mil.SR_INVENTORY_ITEM_ID = ms.INVENTORY_ITEM_ID';

Line 2318: MSC_ITEM_ID_LID t1

2314: ms.MAINTENANCE_OBJECT_TYPE,
2315: ms.REFRESH_ID,
2316: ms.SR_INSTANCE_ID
2317: FROM MSC_ST_SUPPLIES ms,
2318: MSC_ITEM_ID_LID t1
2319: WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID
2320: AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID
2321: AND ms.deleted_flag = MSC_UTIL.SYS_NO
2322: AND ms.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 2393: ||' FROM MSC_ITEM_ID_LID t1, '

2389: ||' :v_current_date, '
2390: ||' :v_current_user, '
2391: ||' :v_current_date, '
2392: ||' :v_current_user '
2393: ||' FROM MSC_ITEM_ID_LID t1, '
2394: ||' MSC_ST_SUPPLIES ms '
2395: ||'WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID '
2396: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID '
2397: ||' AND ms.deleted_flag = '||MSC_UTIL.SYS_NO

Line 2700: ||' MSC_ITEM_ID_LID t1,'

2696: ||' :v_current_user,'
2697: ||' :v_current_date,'
2698: ||' :v_current_user '
2699: ||' FROM MSC_ST_SUPPLIES ms,'
2700: ||' MSC_ITEM_ID_LID t1,'
2701: ||' MSC_TP_ID_LID tp,'
2702: ||' MSC_TP_SITE_ID_LID tps'
2703: ||' WHERE t1.SR_INVENTORY_ITEM_ID= ms.INVENTORY_ITEM_ID'
2704: ||' AND t1.SR_INSTANCE_ID= ms.SR_INSTANCE_ID'