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 8289: FROM MRP_ATP_DETAILS_TEMP

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

Line 8666: FROM MRP_ATP_DETAILS_TEMP

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

Line 9211: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

9207: --e_cto_rearch
9208:
9209: -- time_phased_atp
9210: l_atf_date date;
9211: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
9212: l_org_code varchar2(7);
9213: l_pegging_id number;
9214: l_return_status varchar2(1);
9215: l_network_scheduling_method NUMBER; --bug3601223

Line 10541: from mrp_atp_details_temp

10537: --l_atp_rec.src_atp_flag := l_comp_requirements.src_atp_flag(j);
10538:
10539: select identifier3
10540: into l_atp_rec.demand_source_line
10541: from mrp_atp_details_temp
10542: where pegging_id = p_parent_pegging_id
10543: and record_type = 3
10544: and session_id = MSC_ATP_PVT.G_SESSION_ID;
10545:

Line 12587: l_pegging_rec mrp_atp_details_temp%ROWTYPE;

12583: l_item_weight_qty NUMBER;
12584: l_item_volume_qty NUMBER;
12585: l_atp_date_weight NUMBER;
12586: l_atp_date_volume NUMBER;
12587: l_pegging_rec mrp_atp_details_temp%ROWTYPE;
12588: l_pegging_id NUMBER;
12589: l_vol_demand_pegging_id NUMBER;
12590: l_wt_demand_pegging_id NUMBER;
12591: --INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;

Line 12675: FROM mrp_atp_details_temp

12671: AND sup.source_sr_instance_id = p_source_org_instance_id
12672: AND sup.ship_method = p_ship_method
12673: AND sup.inventory_item_id = p_inventory_item_id
12674: AND sup.transaction_id <> (SELECT identifier3
12675: FROM mrp_atp_details_temp
12676: WHERE record_type = 3
12677: AND pegging_id = p_parent_pegging_id
12678: AND session_id = MSC_ATP_PVT.G_SESSION_ID
12679: ))