DBA Data[Home] [Help]

APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_RESERVATIONS

Line 3085: MSC_ST_RESERVATIONS mshr

3081: mshr.SUPPLY_SOURCE_TYPE_ID,
3082: mshr.REPAIR_PO_HEADER_ID, --SRP Changes For Bug 5996327
3083: mshr.DEMAND_SOURCE_LINE_ID
3084: FROM MSC_ITEM_ID_LID t1, /* bug fix 1084440 */
3085: MSC_ST_RESERVATIONS mshr
3086: WHERE mshr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3087: AND mshr.DELETED_FLAG= MSC_UTIL.SYS_NO
3088: AND t1.SR_INVENTORY_ITEM_ID= mshr.INVENTORY_ITEM_ID
3089: AND t1.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line 3101: FROM MSC_ST_RESERVATIONS mshr

3097: ORGANIZATION_ID,
3098: INVENTORY_ITEM_ID,
3099: DISPOSITION_ID,
3100: DISPOSITION_TYPE
3101: FROM MSC_ST_RESERVATIONS mshr
3102: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3103: AND DELETED_FLAG= MSC_UTIL.SYS_YES ; /* Changed For Bug 6144734 */
3104:
3105: c_count NUMBER:= 0;