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.

[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MRP_ATP_SCHEDULE_TEMP

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

3200:
3201:
3202: -- ========================================================================
3203: -- This procedure inserts information source org information for the request
3204: -- items into mrp_atp_schedule_temp for Supply Chain ATP.
3205: -- ========================================================================
3206:
3207: PROCEDURE get_Supply_Sources(
3208: x_session_id IN NUMBER,

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

3359: ' mast.sr_instance_id,mast.source_organization_id, '||
3360: ' mast.organization_id, '||
3361: ' mast.customer_id,mast.customer_site_id, '||
3362: ' mast.ship_method,mast.delivery_lead_time,mast.ship_method_text '||
3363: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||
3364: ' WHERE mast.session_id = :x_session_id '||
3365: ' AND status_flag = 4 and '||
3366: ' order_line_id = nvl(ato_model_line_id, order_line_id)'||
3367: ' AND rownum = 1';

Line 3393: ' FROM mrp_atp_schedule_temp'||l_dynstring||

3389:
3390: sql_stmt :=
3391: ' SELECT inventory_item_id ,order_line_id, ato_model_line_id,'||
3392: ' match_item_id' ||
3393: ' FROM mrp_atp_schedule_temp'||l_dynstring||
3394: ' WHERE session_id = :x_session_id '||
3395: ' AND status_flag = 4';
3396:
3397: OPEN mast_cursor FOR sql_stmt using x_session_id;

Line 3637: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

3633: EXIT WHEN SH_METHODS%NOTFOUND;
3634:
3635: sql_stmt :=
3636: ' INSERT INTO '||
3637: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
3638: ' ( SESSION_ID,'||
3639: ' DELIVERY_LEAD_TIME,SHIP_METHOD, '||
3640: ' STATUS_FLAG, '||
3641: ' ship_method_text, '||

Line 3715: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

3711: END IF;
3712:
3713: sql_stmt :=
3714: ' INSERT INTO '||
3715: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
3716: ' ( SESSION_ID,'||
3717: ' DELIVERY_LEAD_TIME,SHIP_METHOD, '||
3718: ' STATUS_FLAG, '||
3719: ' SHIP_METHOD_TEXT, '||

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

3770: begin
3771: sql_stmt :=
3772: ' SELECT '||
3773: ' distinct mast.ship_method '||
3774: ' FROM mrp_atp_schedule_temp'||l_dynstring||' mast '||
3775: ' WHERE mast.session_id = :x_session_id '||
3776: ' AND status_flag = -99'||
3777: ' AND mast.source_organization_id=:source_org_id '||
3778: ' AND mast.ship_method = :ship_method ';

Line 3803: ' FROM mrp_atp_schedule_temp'||l_dynstring||

3799: BEGIN
3800: sql_stmt :=
3801: ' SELECT DISTINCT '||
3802: ' delivery_lead_time '||
3803: ' FROM mrp_atp_schedule_temp'||l_dynstring||
3804: ' WHERE session_id = :x_session_id '||
3805: ' AND status_flag = -99'||
3806: ' AND ship_method =:g_ship_method'||
3807: ' AND source_organization_id = :l_om_org';

Line 4044: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||

4040: END IF;
4041:
4042: sql_stmt :=
4043: ' INSERT INTO '||
4044: ' MRP_ATP_SCHEDULE_TEMP'||l_dynstring||' '||
4045: ' (ACTION, CALLING_MODULE, SESSION_ID, ORDER_HEADER_ID, ORDER_LINE_ID, '||
4046: ' INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, ORGANIZATION_CODE, '||
4047: ' SOURCE_ORGANIZATION_ID, '||
4048: ' order_number, '||

Line 4125: ' FROM mrp_atp_schedule_temp'||l_dynstring||' '||

4121: ' ,:created_by ' ||
4122: ' ,sysdate ' ||
4123: ' ,:last_update_by' ||
4124: ' ,:last_update_login' ||
4125: ' FROM mrp_atp_schedule_temp'||l_dynstring||' '||
4126: ' WHERE session_id = :x_session_id '||
4127: ' AND status_flag = 4';
4128: --msc_sch_wb.atp_debug(' sql stmt '||sql_stmt);
4129:

Line 5009: insert into mrp_atp_schedule_temp

5005: -- Bug 3515520, don't use org in case customer/site is populated.
5006: -- Org - Org Intransit Lead Time
5007: -- bug 2958287
5008: BEGIN
5009: insert into mrp_atp_schedule_temp
5010: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5011: (
5012: select p_session_id,
5013: -1,

Line 5061: insert into mrp_atp_schedule_temp

5057:
5058: -- Now try region mapping.
5059: BEGIN
5060: -- bug 2958287
5061: insert into mrp_atp_schedule_temp
5062: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5063: (
5064: select p_session_id,
5065: -1,

Line 5134: insert into mrp_atp_schedule_temp

5130: END IF;
5131: else
5132: BEGIN
5133: forall l_counter2 in 1..l_counter
5134: insert into mrp_atp_schedule_temp
5135: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5136: values
5137: (
5138: p_session_id,

Line 5165: insert into mrp_atp_schedule_temp

5161: BEGIN
5162: IF PG_DEBUG in ('Y', 'C') THEN
5163: msc_sch_wb.atp_debug ('To Organization Specified ');
5164: END IF;
5165: insert into mrp_atp_schedule_temp
5166: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5167: (
5168: select p_session_id,
5169: -1,

Line 5223: insert into mrp_atp_schedule_temp

5219: msc_sch_wb.atp_debug ('To Location ID : ' || l_to_location_id );
5220: END IF;
5221:
5222: BEGIN
5223: insert into mrp_atp_schedule_temp
5224: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5225: (
5226: select p_session_id,
5227: -1,

Line 5293: insert into mrp_atp_schedule_temp

5289: END IF;
5290: else
5291: BEGIN
5292: forall l_counter2 in 1..l_counter
5293: insert into mrp_atp_schedule_temp
5294: (session_id, inventory_item_id, scenario_id, delivery_lead_time, ship_method, status_flag)
5295: values
5296: (
5297: p_session_id,