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 MSC_REGIONS_TEMP

Line 3271: msc_regions_temp mrt

3267: p_partner_site_id NUMBER) IS
3268: SELECT ( (10 * (10 - mrt.region_type)) +
3269: DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level, mrt.region_id
3270: FROM msc_interorg_ship_methods mism,
3271: msc_regions_temp mrt
3272: WHERE mism.plan_id = -1
3273: AND mism.from_location_id = p_from_location_id
3274: AND mism.sr_instance_id = p_from_instance_id
3275: AND mism.sr_instance_id2 = p_to_instance_id

Line 3430: 'INSERT INTO MSC_REGIONS_TEMP(

3426: --bug 4507141: l_dynstring indicates whether we are truely in distributed mode or not
3427: --IF l_dblink is not null THEN
3428: IF l_dynstring is not null THEN
3429: sql_stmt :=
3430: 'INSERT INTO MSC_REGIONS_TEMP(
3431: session_id,
3432: partner_site_id,
3433: region_id,
3434: region_type,

Line 3445: FROM msc_regions_temp' || l_dynstring || '

3441: region_id,
3442: region_type,
3443: zone_flag,
3444: partner_type
3445: FROM msc_regions_temp' || l_dynstring || '
3446: WHERE session_id = :x_session_id)';
3447: EXECUTE IMMEDIATE sql_stmt USING x_session_id;
3448:
3449: IF PG_DEBUG in ('Y', 'C') THEN

Line 3450: msc_sch_wb.atp_debug('Rows inserted in msc_regions_temp:'|| sql%rowcount);

3446: WHERE session_id = :x_session_id)';
3447: EXECUTE IMMEDIATE sql_stmt USING x_session_id;
3448:
3449: IF PG_DEBUG in ('Y', 'C') THEN
3450: msc_sch_wb.atp_debug('Rows inserted in msc_regions_temp:'|| sql%rowcount);
3451: END IF;
3452: END IF;
3453: --bug3610706 End Changes
3454:

Line 3742: ' , msc_regions_temp mrt '||

3738: ',sysdate' ||
3739: ',:last_update_by' ||
3740: ',:last_update_login ' ||
3741: ' FROM msc_interorg_ship_methods msim '||
3742: ' , msc_regions_temp mrt '||
3743: -- ' , fnd_common_lookups fnd '||
3744: ' WHERE mrt.session_id = :x_session_id '||
3745: ' AND msim.plan_id = -1 '||
3746: ' AND msim.from_location_id = :l_from_location_id '||

Line 3859: -- Delete records from MSC_REGIONS_TEMP before returning back to calling

3855: x_error_mesg := 'MRP_ATP_NO_SOURCES';
3856: END IF; -- IF l_sources.organization_id.COUNT > 0
3857: END IF; -- IF l_item_arr.COUNT > 0 THEN
3858:
3859: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
3860: -- application so as to clean up the table for another request within
3861: -- same session for Region Level Sourcing Support
3862:
3863: DELETE msc_regions_temp

Line 3863: DELETE msc_regions_temp

3859: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
3860: -- application so as to clean up the table for another request within
3861: -- same session for Region Level Sourcing Support
3862:
3863: DELETE msc_regions_temp
3864: WHERE session_id = x_session_id;
3865:
3866: IF PG_DEBUG in ('Y', 'C') THEN
3867: msc_sch_wb.atp_debug('get_Supply_Sources: '

Line 3868: || 'Rows deleted from msc_regions_temp : '

3864: WHERE session_id = x_session_id;
3865:
3866: IF PG_DEBUG in ('Y', 'C') THEN
3867: msc_sch_wb.atp_debug('get_Supply_Sources: '
3868: || 'Rows deleted from msc_regions_temp : '
3869: ||sql%rowcount);
3870: END IF;
3871: --ubadrina bug 2265012 begin
3872: EXCEPTION

Line 4930: msc_regions_temp mrt

4926: IS
4927: SELECT mism.ship_method, mism.intransit_time,
4928: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4929: FROM mtl_interorg_ship_methods mism,
4930: msc_regions_temp mrt
4931: WHERE mism.from_location_id = c_from_loc_id
4932: AND mism.to_region_id = mrt.region_id
4933: AND mrt.session_id = c_session_id
4934: AND mrt.partner_site_id = c_partner_site_id

Line 4947: msc_regions_temp mrt

4943: IS
4944: SELECT mism.ship_method, mism.intransit_time,
4945: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4946: FROM msc_interorg_ship_methods mism,
4947: msc_regions_temp mrt
4948: WHERE mism.plan_id = -1
4949: AND mism.from_location_id = c_from_location_id
4950: AND mism.sr_instance_id = c_from_instance_id
4951: AND mism.sr_instance_id2 = c_to_instance_id

Line 5315: -- Delete data from MSC_REGIONS_TEMP

5311: end if; --sql rowcount = 0
5312: end if; -- p_org_id is not nULL
5313: end if; -- calling module check
5314:
5315: -- Delete data from MSC_REGIONS_TEMP
5316: DELETE MSC_REGIONS_TEMP
5317: where session_id = p_session_id;
5318:
5319: IF PG_DEBUG in ('Y', 'C') THEN

Line 5316: DELETE MSC_REGIONS_TEMP

5312: end if; -- p_org_id is not nULL
5313: end if; -- calling module check
5314:
5315: -- Delete data from MSC_REGIONS_TEMP
5316: DELETE MSC_REGIONS_TEMP
5317: where session_id = p_session_id;
5318:
5319: IF PG_DEBUG in ('Y', 'C') THEN
5320: msc_sch_wb.atp_debug (sql%rowcount || ' rows deleted from regions temp table.');

Line 5407: DELETE MSC_REGIONS_TEMP

5403: x_ship_method,
5404: x_intransit_time
5405: );
5406:
5407: DELETE MSC_REGIONS_TEMP
5408: WHERE session_id = p_session_id
5409: AND partner_site_id = p_to_customer_site_id;
5410:
5411: if (PG_DEBUG in ('Y','C')) then

Line 5633: MSC_REGIONS_TEMP MRT_INNER

5629: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
5630: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
5631: MSC_SOURCING_RULES MSR_INNER,
5632: MSC_SR_ASSIGNMENTS MSRA_INNER,
5633: MSC_REGIONS_TEMP MRT_INNER
5634: WHERE
5635: MSRA_INNER.ASSIGNMENT_TYPE = 9
5636: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
5637: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 5695: MSC_REGIONS_TEMP MRT

5691: MSC_SR_SOURCE_ORG SOURCE_ORG,
5692: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5693: MSC_SOURCING_RULES MSR,
5694: MSC_SR_ASSIGNMENTS MSRA,
5695: MSC_REGIONS_TEMP MRT
5696: WHERE
5697: MSRA.ASSIGNMENT_TYPE = 9
5698: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5699: AND MSRA.REGION_ID = MRT.REGION_ID

Line 5922: MSC_REGIONS_TEMP MRT_INNER

5918: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
5919: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
5920: MSC_SOURCING_RULES MSR_INNER,
5921: MSC_SR_ASSIGNMENTS MSRA_INNER,
5922: MSC_REGIONS_TEMP MRT_INNER
5923: WHERE
5924: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5925: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
5926: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 5984: MSC_REGIONS_TEMP MRT

5980: MSC_SR_SOURCE_ORG SOURCE_ORG,
5981: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5982: MSC_SOURCING_RULES MSR,
5983: MSC_SR_ASSIGNMENTS MSRA,
5984: MSC_REGIONS_TEMP MRT
5985: WHERE
5986: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5987: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5988: AND MSRA.REGION_ID = MRT.REGION_ID

Line 6210: MSC_REGIONS_TEMP MRT_INNER

6206: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
6207: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
6208: MSC_SOURCING_RULES MSR_INNER,
6209: MSC_SR_ASSIGNMENTS MSRA_INNER,
6210: MSC_REGIONS_TEMP MRT_INNER
6211: WHERE
6212: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
6213: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
6214: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 6271: MSC_REGIONS_TEMP MRT

6267: MSC_SR_SOURCE_ORG SOURCE_ORG,
6268: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6269: MSC_SOURCING_RULES MSR,
6270: MSC_SR_ASSIGNMENTS MSRA,
6271: MSC_REGIONS_TEMP MRT
6272: WHERE
6273: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */
6274: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6275: AND MSRA.REGION_ID = MRT.REGION_ID

Line 6580: MSC_REGIONS_TEMP MRT_INNER,

6576: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
6577: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
6578: MSC_SOURCING_RULES MSR_INNER,
6579: MSC_SR_ASSIGNMENTS MSRA_INNER,
6580: MSC_REGIONS_TEMP MRT_INNER,
6581: MSC_SHIP_SET_TEMP MSST_INNER
6582: WHERE
6583: MSRA_INNER.ASSIGNMENT_TYPE = 9
6584: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6654: MSC_REGIONS_TEMP MRT,

6650: MSC_SR_SOURCE_ORG SOURCE_ORG,
6651: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6652: MSC_SOURCING_RULES MSR,
6653: MSC_SR_ASSIGNMENTS MSRA,
6654: MSC_REGIONS_TEMP MRT,
6655: MSC_SHIP_SET_TEMP MSST
6656: WHERE
6657: MSRA.ASSIGNMENT_TYPE = 9
6658: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7070: MSC_REGIONS_TEMP MRT_INNER,

7066: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
7067: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
7068: MSC_SOURCING_RULES MSR_INNER,
7069: MSC_SR_ASSIGNMENTS MSRA_INNER,
7070: MSC_REGIONS_TEMP MRT_INNER,
7071: MSC_SHIP_SET_TEMP MSST_INNER
7072: WHERE
7073:
7074: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */

Line 7143: MSC_REGIONS_TEMP MRT,

7139: MSC_SR_SOURCE_ORG SOURCE_ORG,
7140: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7141: MSC_SOURCING_RULES MSR,
7142: MSC_SR_ASSIGNMENTS MSRA,
7143: MSC_REGIONS_TEMP MRT,
7144: MSC_SHIP_SET_TEMP MSST
7145: WHERE
7146:
7147: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */

Line 7545: MSC_REGIONS_TEMP MRT_INNER,

7541: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
7542: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
7543: MSC_SOURCING_RULES MSR_INNER,
7544: MSC_SR_ASSIGNMENTS MSRA_INNER,
7545: MSC_REGIONS_TEMP MRT_INNER,
7546: MSC_SHIP_SET_TEMP MSST_INNER
7547: WHERE
7548: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
7549: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7616: MSC_REGIONS_TEMP MRT,

7612: MSC_SR_SOURCE_ORG SOURCE_ORG,
7613: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7614: MSC_SOURCING_RULES MSR,
7615: MSC_SR_ASSIGNMENTS MSRA,
7616: MSC_REGIONS_TEMP MRT,
7617: MSC_SHIP_SET_TEMP MSST
7618: WHERE
7619:
7620: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */

Line 8509: msc_regions_temp mrt

8505: IS
8506: SELECT intransit_time,
8507: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8508: FROM msc_interorg_ship_methods mism,
8509: msc_regions_temp mrt
8510: WHERE mism.plan_id = -1
8511: AND mism.from_location_id = p_from_loc_id
8512: AND mism.sr_instance_id = p_from_instance_id
8513: AND mism.sr_instance_id2 = p_to_instance_id

Line 8526: msc_regions_temp mrt

8522: IS
8523: SELECT ship_method, intransit_time,
8524: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8525: FROM msc_interorg_ship_methods mism,
8526: msc_regions_temp mrt
8527: WHERE mism.plan_id = -1
8528: AND mism.from_location_id = p_from_loc_id
8529: AND mism.sr_instance_id = p_from_instance_id
8530: AND mism.sr_instance_id2 = p_to_instance_id

Line 8544: msc_regions_temp mrt

8540: IS
8541: SELECT intransit_time,
8542: mrt.region_type region_level -- collection has already translated data
8543: FROM msc_interorg_ship_methods mism,
8544: msc_regions_temp mrt
8545: WHERE mism.plan_id = -1
8546: AND mism.to_location_id = p_to_loc_id
8547: AND mism.sr_instance_id2 = p_to_instance_id
8548: AND mism.sr_instance_id = p_from_instance_id

Line 8561: msc_regions_temp mrt

8557: IS
8558: SELECT ship_method, intransit_time,
8559: mrt.region_type region_level -- collection has already translated data
8560: FROM msc_interorg_ship_methods mism,
8561: msc_regions_temp mrt
8562: WHERE mism.plan_id = -1
8563: AND mism.to_location_id = p_to_loc_id
8564: AND mism.sr_instance_id2 = p_to_instance_id
8565: AND mism.sr_instance_id = p_from_instance_id