eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PROC dependencies on MRP_ATP_SCHEDULE_TEMP

Line 3212: -- items into mrp_atp_schedule_temp for Supply Chain ATP.

3208:
3209:
3210: -- ========================================================================
3211: -- This procedure inserts information source org information for the request
3212: -- items into mrp_atp_schedule_temp for Supply Chain ATP.
3213: -- ========================================================================
3214:
3215: PROCEDURE get_Supply_Sources(
3216: x_session_id IN NUMBER,

Line 3372: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||

3368: ' mast.sr_instance_id,mast.source_organization_id, '||
3369: ' mast.organization_id, '||
3370: ' mast.customer_id,mast.customer_site_id, '||
3371: ' mast.ship_method,mast.delivery_lead_time,mast.ship_method_text '||
3372: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||
3373: ' WHERE mast.session_id = :x_session_id '||
3374: ' AND status_flag = 4 and '||
3375: ' order_line_id = nvl(ato_model_line_id, order_line_id)'||
3376: ' AND rownum = 1';

Line 3402: ' FROM mrp_atp_schedule_temp'||l_dynstring||

3398:
3399: sql_stmt :=
3400: ' SELECT inventory_item_id ,order_line_id, ato_model_line_id,'||
3401: ' match_item_id' ||
3402: ' FROM mrp_atp_schedule_temp'||l_dynstring||
3403: ' WHERE session_id = :x_session_id '||
3404: ' AND status_flag = 4';
3405:
3406: OPEN mast_cursor FOR sql_stmt using x_session_id;

Line 3646: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

3642: EXIT WHEN SH_METHODS%NOTFOUND;
3643:
3644: sql_stmt :=
3645: ' INSERT INTO '||
3646: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
3647: ' ( SESSION_ID,'||
3648: ' DELIVERY_LEAD_TIME,SHIP_METHOD, '||
3649: ' STATUS_FLAG, '||
3650: ' ship_method_text, '||

Line 3724: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

3720: END IF;
3721:
3722: sql_stmt :=
3723: ' INSERT INTO '||
3724: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
3725: ' ( SESSION_ID,'||
3726: ' DELIVERY_LEAD_TIME,SHIP_METHOD, '||
3727: ' STATUS_FLAG, '||
3728: ' SHIP_METHOD_TEXT, '||

Line 3783: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||

3779: begin
3780: sql_stmt :=
3781: ' SELECT '||
3782: ' distinct mast.ship_method '||
3783: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||
3784: ' WHERE mast.session_id = :x_session_id '||
3785: ' AND status_flag = -99'||
3786: ' AND mast.source_organization_id=:source_org_id '||
3787: ' AND mast.ship_method = :ship_method ';

Line 3812: ' FROM mrp_atp_schedule_temp'||l_dynstring||

3808: BEGIN
3809: sql_stmt :=
3810: ' SELECT DISTINCT '||
3811: ' delivery_lead_time '||
3812: ' FROM mrp_atp_schedule_temp'||l_dynstring||
3813: ' WHERE session_id = :x_session_id '||
3814: ' AND status_flag = -99'||
3815: ' AND ship_method =:g_ship_method'||
3816: ' AND source_organization_id = :l_om_org';

Line 4053: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

4049: END IF;
4050:
4051: sql_stmt :=
4052: ' INSERT INTO '||
4053: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
4054: ' (ACTION, CALLING_MODULE, SESSION_ID, ORDER_HEADER_ID, ORDER_LINE_ID, '||
4055: ' INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, ORGANIZATION_CODE, '||
4056: ' SOURCE_ORGANIZATION_ID, '||
4057: ' order_number, '||

Line 4134: ' FROM mrp_atp_schedule_temp'||l_dynstring||' '||

4130: ' ,:created_by ' ||
4131: ' ,sysdate ' ||
4132: ' ,:last_update_by' ||
4133: ' ,:last_update_login' ||
4134: ' FROM mrp_atp_schedule_temp'||l_dynstring||' '||
4135: ' WHERE session_id = :x_session_id '||
4136: ' AND status_flag = 4';
4137: --msc_sch_wb.atp_debug(' sql stmt '||sql_stmt);
4138:

Line 5018: insert into mrp_atp_schedule_temp

5014: -- Bug 3515520, don't use org in case customer/site is populated.
5015: -- Org - Org Intransit Lead Time
5016: -- bug 2958287
5017: BEGIN
5018: insert into mrp_atp_schedule_temp
5019: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5020: (
5021: select p_session_id,
5022: -1,

Line 5070: insert into mrp_atp_schedule_temp

5066:
5067: -- Now try region mapping.
5068: BEGIN
5069: -- bug 2958287
5070: insert into mrp_atp_schedule_temp
5071: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5072: (
5073: select p_session_id,
5074: -1,

Line 5143: insert into mrp_atp_schedule_temp

5139: END IF;
5140: else
5141: BEGIN
5142: forall l_counter2 in 1..l_counter
5143: insert into mrp_atp_schedule_temp
5144: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5145: values
5146: (
5147: p_session_id,

Line 5174: insert into mrp_atp_schedule_temp

5170: BEGIN
5171: IF PG_DEBUG in ('Y', 'C') THEN
5172: msc_sch_wb.atp_debug ('To Organization Specified ');
5173: END IF;
5174: insert into mrp_atp_schedule_temp
5175: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5176: (
5177: select p_session_id,
5178: -1,

Line 5232: insert into mrp_atp_schedule_temp

5228: msc_sch_wb.atp_debug ('To Location ID : ' || l_to_location_id );
5229: END IF;
5230:
5231: BEGIN
5232: insert into mrp_atp_schedule_temp
5233: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5234: (
5235: select p_session_id,
5236: -1,

Line 5302: insert into mrp_atp_schedule_temp

5298: END IF;
5299: else
5300: BEGIN
5301: forall l_counter2 in 1..l_counter
5302: insert into mrp_atp_schedule_temp
5303: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5304: values
5305: (
5306: p_session_id,