DBA Data[Home] [Help]

APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_RESERVATIONS

Line 2752: MSC_ST_RESERVATIONS mshr

2748: mshr.SUPPLY_SOURCE_HEADER_ID,
2749: mshr.SUPPLY_SOURCE_TYPE_ID,
2750: mshr.REPAIR_PO_HEADER_ID --SRP Changes For Bug 5996327
2751: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */
2752: MSC_ST_RESERVATIONS mshr
2753: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2754: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO
2755: AND t1.SR_INVENTORY_ITEM_ID= mshr.INVENTORY_ITEM_ID
2756: AND t1.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 2768: FROM MSC_ST_RESERVATIONS mshr

2764: ORGANIZATION_ID,
2765: INVENTORY_ITEM_ID,
2766: DISPOSITION_ID,
2767: DISPOSITION_TYPE
2768: FROM MSC_ST_RESERVATIONS mshr
2769: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2770: AND DELETED_FLAG= MSC_UTIL.SYS_YES ; /* Changed For Bug 6144734 */
2771:
2772: c_count NUMBER:= 0;