APPS.MSC_POST_PRO dependencies on MSC_NET_RESOURCE_AVAIL

Line 8233: FROM MSC_NET_RESOURCE_AVAIL MNRA,

8229: p_sys_date last_update_date,
8230: l_user_id last_updated_by,
8231: p_sys_date creation_date,
8232: l_user_id created_by
8233: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8234: MSC_DEPARTMENT_RESOURCES DR,
8235: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8236: WHERE MNRA.PLAN_ID = p_plan_id
8237: AND NVL(MNRA.PARENT_ID, -2) <> -1

Line 8376: FROM MSC_NET_RESOURCE_AVAIL MNRA,

8372: p_sys_date last_update_date,
8373: l_user_id last_updated_by,
8374: p_sys_date creation_date,
8375: l_user_id created_by
8376: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8377: MSC_DEPARTMENT_RESOURCES DR,
8378: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8379: WHERE MNRA.PLAN_ID = p_plan_id
8380: AND NVL(MNRA.PARENT_ID, -2) <> -1

Line 8503: FROM MSC_NET_RESOURCE_AVAIL

8499: p_sys_date last_update_date,
8500: l_user_id last_updated_by,
8501: p_sys_date creation_date,
8502: l_user_id created_by
8503: FROM MSC_NET_RESOURCE_AVAIL
8504: WHERE PLAN_ID = p_plan_id
8505: AND NVL(PARENT_ID, -2) <> -1
8506: -- uncommented following line so that less number of rows are selected
8507: AND SHIFT_DATE >= p_plan_start_date -- summary enhancement - made consistent

Line 8609: FROM MSC_NET_RESOURCE_AVAIL

8605: p_sys_date last_update_date,
8606: l_user_id last_updated_by,
8607: p_sys_date creation_date,
8608: l_user_id created_by
8609: FROM MSC_NET_RESOURCE_AVAIL
8610: WHERE PLAN_ID = p_plan_id
8611: AND NVL(PARENT_ID, -2) <> -1
8612: AND SHIFT_DATE >= p_plan_start_date -- summary enhancement: made consistent
8613: )

Line 8645: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because

8641: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8642: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8643: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8644:
8645: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8646: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
8647: p_new_refresh_number IN NUMBER)
8648: IS
8649: SELECT NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,