DBA Data[Home] [Help]

APPS.MSC_RP_RELEASE_PUB dependencies on MSC_SYSTEM_ITEMS

Line 513: FROM msc_system_items

509: ln_pp_lead_time NUMBER;
510: lv_date DATE;
511: CURSOR CPPL IS
512: SELECT nvl(postprocessing_lead_time, 0)
513: FROM msc_system_items
514: WHERE plan_id = p_plan_id
515: AND sr_instance_id = p_inst_id
516: AND ORGANIZATION_ID = p_org_id
517: AND INVENTORY_ITEM_ID = p_item_id;

Line 667: msc_system_items msi

663:
664: CURSOR C2 IS
665: SELECT employee_id
666: FROM msc_planners mp,
667: msc_system_items msi
668: WHERE mp.planner_code = msi.planner_code
669: AND mp.organization_id = msi.organization_id
670: AND mp.sr_instance_id = msi.sr_instance_id
671: AND mp.current_employee_flag = 1

Line 950: from msc_system_items

946:
947:
948: cursor crit_component IS
949: select critical_component_flag
950: from msc_system_items
951: where plan_id = arg_plan_id
952: and inventory_item_id = arg_item_id
953: and organization_id = arg_org_id
954: and sr_instance_id = arg_sr_instance_id;

Line 1043: from msc_system_items

1039: l_plan_type number:=1; --- temp set as ASCP plan
1040: v_project_id number;
1041: CURSOR sr_item_cur IS
1042: select sr_inventory_item_id
1043: from msc_system_items
1044: where plan_id = p_plan_id
1045: and organization_id = p_org_id
1046: and sr_instance_id = p_instance_id
1047: and inventory_item_id = p_item_id;