APPS.MSC_ATP_REQ dependencies on MRP_ATP_DETAILS_TEMP

Line 3896: msc_system_items pt, mrp_atp_details_temp peg

3892: ,comp.component_yield_factor component_yield_factor
3893:
3894: FROM msc_system_items msi, msc_component_substitutes sub,
3895: msc_bom_components comp, msc_boms bom, msc_system_items ch,
3896: msc_system_items pt, mrp_atp_details_temp peg
3897: WHERE peg.session_id = MSC_ATP_PVT.G_SESSION_ID
3898: AND peg.pegging_id = p_parent_pegging_id
3899: AND pt.sr_instance_id = p_instance_id
3900: AND pt.organization_id = peg.organization_id

Line 4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

4002: g_atp_record MRP_ATP_PVT.AtpRec;
4003: l_atp_insert_rec MRP_ATP_PVT.AtpRec;
4004: g_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4005: g_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4006: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
4007: l_pegging_id number;
4008: l_atp_pegging_id number;
4009: l_atp_flag varchar2(1) := 'Y';
4010: l_atp_comp_flag varchar2(1) := 'N';

Line 5640: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

5636: /* Bug 3348095 */
5637: l_atp_comp_flag VARCHAR2(1);
5638: l_supply_id number;
5639: l_transaction_id number;
5640: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
5641: l_resource_hours number;
5642: l_pegging_id number;
5643: l_null_num number := null;
5644: l_null_char varchar2(3) := null;

Line 8285: FROM MRP_ATP_DETAILS_TEMP

8281: IF x_avail_assembly_qty <> 0 or MSC_ATP_PVT.G_DIAGNOSTIC_ATP = 1 THEN
8282: -- get supply_id from the pegging_id
8283: SELECT IDENTIFIER3
8284: INTO l_supply_id
8285: FROM MRP_ATP_DETAILS_TEMP
8286: WHERE PEGGING_ID = p_parent_pegging_id
8287: AND RECORD_TYPE = 3
8288: AND SESSION_ID = MSC_ATP_PVT.G_SESSION_ID;
8289: --diag_atp:

Line 8662: FROM MRP_ATP_DETAILS_TEMP

8658: IF x_atp_date IS NOT NULL THEN
8659: -- get supply_id from the pegging_id
8660: SELECT IDENTIFIER3
8661: INTO l_supply_id
8662: FROM MRP_ATP_DETAILS_TEMP
8663: WHERE PEGGING_ID = p_parent_pegging_id
8664: AND RECORD_TYPE = 3
8665: AND SESSION_ID = MSC_ATP_PVT.G_SESSION_ID;
8666:

Line 9207: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

9203: --e_cto_rearch
9204:
9205: -- time_phased_atp
9206: l_atf_date date;
9207: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
9208: l_org_code varchar2(7);
9209: l_pegging_id number;
9210: l_return_status varchar2(1);
9211: l_network_scheduling_method NUMBER; --bug3601223

Line 10526: from mrp_atp_details_temp

10522: --l_atp_rec.src_atp_flag := l_comp_requirements.src_atp_flag(j);
10523:
10524: select identifier3
10525: into l_atp_rec.demand_source_line
10526: from mrp_atp_details_temp
10527: where pegging_id = p_parent_pegging_id
10528: and record_type = 3
10529: and session_id = MSC_ATP_PVT.G_SESSION_ID;
10530:

Line 12554: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

12550: l_item_weight_qty NUMBER;
12551: l_item_volume_qty NUMBER;
12552: l_atp_date_weight NUMBER;
12553: l_atp_date_volume NUMBER;
12554: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
12555: l_pegging_id NUMBER;
12556: l_vol_demand_pegging_id NUMBER;
12557: l_wt_demand_pegging_id NUMBER;
12558: --INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;

Line 12642: FROM mrp_atp_details_temp

12638: AND sup.source_sr_instance_id = p_source_org_instance_id
12639: AND sup.ship_method = p_ship_method
12640: AND sup.inventory_item_id = p_inventory_item_id
12641: AND sup.transaction_id <> (SELECT identifier3
12642: FROM mrp_atp_details_temp
12643: WHERE record_type = 3
12644: AND pegging_id = p_parent_pegging_id
12645: AND session_id = MSC_ATP_PVT.G_SESSION_ID
12646: ))