APPS.MSC_POST_PRO dependencies on MSC_NET_RESOURCE_AVAIL

Line 8262: FROM MSC_NET_RESOURCE_AVAIL MNRA,

8258: p_sys_date last_update_date,
8259: l_user_id last_updated_by,
8260: p_sys_date creation_date,
8261: l_user_id created_by
8262: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8263: MSC_DEPARTMENT_RESOURCES DR,
8264: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8265: WHERE MNRA.PLAN_ID = p_plan_id
8266: AND NVL(MNRA.PARENT_ID, -2) <> -1

Line 8405: FROM MSC_NET_RESOURCE_AVAIL MNRA,

8401: p_sys_date last_update_date,
8402: l_user_id last_updated_by,
8403: p_sys_date creation_date,
8404: l_user_id created_by
8405: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8406: MSC_DEPARTMENT_RESOURCES DR,
8407: MSC_UOM_CONVERSIONS MUC -- noted in summary enhancement : inconsistent with MSCRATPB
8408: WHERE MNRA.PLAN_ID = p_plan_id
8409: AND NVL(MNRA.PARENT_ID, -2) <> -1

Line 8532: FROM MSC_NET_RESOURCE_AVAIL

8528: p_sys_date last_update_date,
8529: l_user_id last_updated_by,
8530: p_sys_date creation_date,
8531: l_user_id created_by
8532: FROM MSC_NET_RESOURCE_AVAIL
8533: WHERE PLAN_ID = p_plan_id
8534: AND NVL(PARENT_ID, -2) <> -1
8535: -- uncommented following line so that less number of rows are selected
8536: AND SHIFT_DATE >= p_plan_start_date -- summary enhancement - made consistent

Line 8638: FROM MSC_NET_RESOURCE_AVAIL

8634: p_sys_date last_update_date,
8635: l_user_id last_updated_by,
8636: p_sys_date creation_date,
8637: l_user_id created_by
8638: FROM MSC_NET_RESOURCE_AVAIL
8639: WHERE PLAN_ID = p_plan_id
8640: AND NVL(PARENT_ID, -2) <> -1
8641: AND SHIFT_DATE >= p_plan_start_date -- summary enhancement: made consistent
8642: )

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

8670: l_ins_sr_instance_id_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8671: l_ins_sd_date_tab MRP_ATP_PUB.date_arr := MRP_ATP_PUB.date_arr();
8672: l_ins_sd_quantity_tab MRP_ATP_PUB.number_arr := MRP_ATP_PUB.number_arr();
8673:
8674: CURSOR c_net_res (p_plan_id IN NUMBER, -- Cursor does not require msc_net_resource_avail because
8675: p_last_refresh_number IN NUMBER, -- data in that does not change between plan runs
8676: p_new_refresh_number IN NUMBER)
8677: IS
8678: SELECT NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID) department_id,