APPS.MSC_ATP_PVT dependencies on MSC_SYSTEM_ITEMS

Line 6697: FROM msc_system_items I,

6693:
6694: BEGIN
6695: SELECT NVL(r.demand_class_atp_flag, 0)
6696: INTO l_demand_class_flag
6697: FROM msc_system_items I,
6698: msc_trading_partners P,
6699: msc_atp_rules R
6700: WHERE I.sr_instance_id = p_atp_record.instance_id
6701: AND I.organization_id = p_atp_record.organization_id

Line 9626: from msc_system_items itm,

9622: 1, trunc(NVL(itm.planning_time_fence_date, l_ptf_date)), -- Bug 3535999 - l_sysdate)),
9623: l_ptf_date), -- Bug 3535999 - l_sysdate),
9624: pl.planning_time_fence_flag -- Bug 3525582
9625: into l_ptf_date, l_ptf_enabled -- Bug 3525582
9626: from msc_system_items itm,
9627: msc_plans pl
9628: where itm.plan_id = p_plan_id
9629: and itm.sr_instance_id = p_atp_record.instance_id
9630: and itm.organization_id = p_atp_record.organization_id

Line 10123: FROM MSC_SYSTEM_ITEMS I

10119: --- select make buy code to decide if we want to make it or buy it
10120: --EFTC Changes
10121: BEGIN
10122: SELECT planning_make_buy_code INTO l_make_buy_cd
10123: FROM MSC_SYSTEM_ITEMS I
10124: --bug3842035 Using member item id instead of family
10125: --WHERE I.sr_inventory_item_id = p_atp_record.inventory_item_id and
10126: WHERE I.sr_inventory_item_id = p_atp_record.request_item_id and
10127: I.sr_instance_id = p_atp_record.instance_id and

Line 10610: FROM msc_system_items

10606: --- 2178544 replace this query as we already have processing lead time
10607: /*begin
10608: SELECT nvl(postprocessing_lead_time, 0)
10609: INTO l_atp_rec.delivery_lead_time
10610: FROM msc_system_items
10611: WHERE plan_id = p_plan_id
10612: AND organization_id = l_atp_rec.organization_id
10613: AND sr_instance_id = l_atp_rec.instance_id
10614: AND inventory_item_id = l_inv_item_id; -- 1665483

Line 16858: from msc_system_items i

16854: END IF;
16855:
16856: select count(*)
16857: into l_same_org_count
16858: from msc_system_items i
16859: where i.plan_id = x_plan_info_rec.plan_id
16860: and i.organization_id = l_atp_input_table.internal_org_id(m)
16861: and i.sr_instance_id = p_instance_id
16862: and i.sr_inventory_item_id = l_atp_input_table.inventory_item_id(m);

Line 16874: from msc_system_items

16870: IF PG_DEBUG in ('Y', 'C') THEN
16871: msc_sch_wb.atp_debug('Both the Orgs are in NOT the same plan');
16872: END IF;
16873: select count(*) into l_feeder_count
16874: from msc_system_items
16875: where plan_id in ( select plans.plan_id input_plan_id
16876: from msc_plan_schedules sched,
16877: msc_designators md,
16878: msc_plans plans

Line 18001: Selecting inventory_item_id from msc_system_items*/

17997: l_exception_rec.exception_type := 68; -- Overcommitment of Sales Order
17998: l_exception_rec.quantity := -1 * x_atp_table.quantity_ordered(k);
17999:
18000: /* rajjain 02/06/2003 Bug 2781863
18001: Selecting inventory_item_id from msc_system_items*/
18002: BEGIN
18003: -- Bug 3444096, use x_atp_table.match_item_id for match cases in CTO
18004: Select inventory_item_id
18005: into l_inventory_item_id

Line 18006: from msc_system_items

18002: BEGIN
18003: -- Bug 3444096, use x_atp_table.match_item_id for match cases in CTO
18004: Select inventory_item_id
18005: into l_inventory_item_id
18006: from msc_system_items
18007: where plan_id = l_plan_id
18008: and sr_instance_id = l_instance_id
18009: and organization_id = x_atp_table.source_organization_id(k)
18010: and sr_inventory_item_id = NVL(x_atp_table.match_item_id(k), x_atp_table.inventory_item_id(k));