APPS.MSC_ATP_PVT dependencies on MSC_SYSTEM_ITEMS

Line 7331: FROM msc_system_items I,

7327:
7328: BEGIN
7329: SELECT NVL(r.demand_class_atp_flag, 0)
7330: INTO l_demand_class_flag
7331: FROM msc_system_items I,
7332: msc_trading_partners P,
7333: msc_atp_rules R
7334: WHERE I.sr_instance_id = p_atp_record.instance_id
7335: AND I.organization_id = p_atp_record.organization_id

Line 10333: from msc_system_items itm,

10329: 1, trunc(NVL(itm.planning_time_fence_date, l_ptf_date)), -- Bug 3535999 - l_sysdate)),
10330: l_ptf_date), -- Bug 3535999 - l_sysdate),
10331: pl.planning_time_fence_flag -- Bug 3525582
10332: into l_ptf_date, l_ptf_enabled -- Bug 3525582
10333: from msc_system_items itm,
10334: msc_plans pl
10335: where itm.plan_id = p_plan_id
10336: and itm.sr_instance_id = p_atp_record.instance_id
10337: and itm.organization_id = p_atp_record.organization_id

Line 10832: FROM MSC_SYSTEM_ITEMS I

10828: --- select make buy code to decide if we want to make it or buy it
10829: --EFTC Changes
10830: BEGIN
10831: SELECT planning_make_buy_code INTO l_make_buy_cd
10832: FROM MSC_SYSTEM_ITEMS I
10833: --bug3842035 Using member item id instead of family
10834: --WHERE I.sr_inventory_item_id = p_atp_record.inventory_item_id and
10835: WHERE I.sr_inventory_item_id = p_atp_record.request_item_id and
10836: I.sr_instance_id = p_atp_record.instance_id and

Line 11332: FROM msc_system_items

11328: --- 2178544 replace this query as we already have processing lead time
11329: /*begin
11330: SELECT nvl(postprocessing_lead_time, 0)
11331: INTO l_atp_rec.delivery_lead_time
11332: FROM msc_system_items
11333: WHERE plan_id = p_plan_id
11334: AND organization_id = l_atp_rec.organization_id
11335: AND sr_instance_id = l_atp_rec.instance_id
11336: AND inventory_item_id = l_inv_item_id; -- 1665483

Line 17721: from msc_system_items i

17717: END IF;
17718:
17719: select count(*)
17720: into l_same_org_count
17721: from msc_system_items i
17722: where i.plan_id = x_plan_info_rec.plan_id
17723: and i.organization_id = l_atp_input_table.internal_org_id(m)
17724: and i.sr_instance_id = p_instance_id
17725: and i.sr_inventory_item_id = l_atp_input_table.inventory_item_id(m);

Line 17737: from msc_system_items

17733: IF PG_DEBUG in ('Y', 'C') THEN
17734: msc_sch_wb.atp_debug('Both the Orgs are in NOT the same plan');
17735: END IF;
17736: select count(*) into l_feeder_count
17737: from msc_system_items
17738: where plan_id in ( select plans.plan_id input_plan_id
17739: from msc_plan_schedules sched,
17740: msc_designators md,
17741: msc_plans plans

Line 18875: Selecting inventory_item_id from msc_system_items*/

18871: l_exception_rec.exception_type := 68; -- Overcommitment of Sales Order
18872: l_exception_rec.quantity := -1 * x_atp_table.quantity_ordered(k);
18873:
18874: /* rajjain 02/06/2003 Bug 2781863
18875: Selecting inventory_item_id from msc_system_items*/
18876: BEGIN
18877: -- Bug 3444096, use x_atp_table.match_item_id for match cases in CTO
18878: Select inventory_item_id
18879: into l_inventory_item_id

Line 18880: from msc_system_items

18876: BEGIN
18877: -- Bug 3444096, use x_atp_table.match_item_id for match cases in CTO
18878: Select inventory_item_id
18879: into l_inventory_item_id
18880: from msc_system_items
18881: where plan_id = l_plan_id
18882: and sr_instance_id = l_instance_id
18883: and organization_id = x_atp_table.source_organization_id(k)
18884: and sr_inventory_item_id = NVL(x_atp_table.match_item_id(k), x_atp_table.inventory_item_id(k));