APPS.MSC_PLAN_RELEASE dependencies on MSC_SYSTEM_ITEMS

Line 623: FROM msc_system_items

619: ln_pp_lead_time NUMBER;
620: lv_date DATE;
621: CURSOR CPPL IS
622: SELECT nvl(postprocessing_lead_time, 0)
623: FROM msc_system_items
624: WHERE plan_id = p_plan_id
625: AND sr_instance_id = p_inst_id
626: AND ORGANIZATION_ID = p_org_id
627: AND INVENTORY_ITEM_ID = p_item_id;

Line 777: msc_system_items msi

773:
774: CURSOR C2 IS
775: SELECT employee_id
776: FROM msc_planners mp,
777: msc_system_items msi
778: WHERE mp.planner_code = msi.planner_code
779: AND mp.organization_id = msi.organization_id
780: AND mp.sr_instance_id = msi.sr_instance_id
781: AND mp.current_employee_flag = 1

Line 1071: from msc_system_items

1067:
1068:
1069: cursor crit_component IS
1070: select critical_component_flag
1071: from msc_system_items
1072: where plan_id = arg_plan_id
1073: and inventory_item_id = arg_item_id
1074: and organization_id = arg_org_id
1075: and sr_instance_id = arg_sr_instance_id;

Line 1164: from msc_system_items

1160: l_plan_type number:=1; --- temp set as ASCP plan
1161: v_project_id number;
1162: CURSOR sr_item_cur IS
1163: select sr_inventory_item_id
1164: from msc_system_items
1165: where plan_id = p_plan_id
1166: and organization_id = p_org_id
1167: and sr_instance_id = p_instance_id
1168: and inventory_item_id = p_item_id;