APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ST_SUPPLIES

Line 1752: ||' MSC_ST_SUPPLIES ms,'

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'
1756: ||' AND ms.DELETED_FLAG = '|| MSC_UTIL.SYS_NO

Line 2317: FROM MSC_ST_SUPPLIES ms,

2313: ms.DESCRIPTION,
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

Line 2330: FROM MSC_ST_SUPPLIES

2326: SELECT DISPOSITION_ID,
2327: ORDER_TYPE,
2328: ORGANIZATION_ID,
2329: SR_INSTANCE_ID
2330: FROM MSC_ST_SUPPLIES
2331: WHERE deleted_flag = MSC_UTIL.SYS_YES
2332: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2333: AND order_type=90;
2334:

Line 2394: ||' MSC_ST_SUPPLIES ms '

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
2398: ||' AND ms.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 2699: ||' FROM MSC_ST_SUPPLIES ms,'

2695: ||' :v_current_date,'
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'