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 3280: msc_regions_temp mrt

3276: p_partner_site_id NUMBER) IS
3277: SELECT ( (10 * (10 - mrt.region_type)) +
3278: DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level, mrt.region_id
3279: FROM msc_interorg_ship_methods mism,
3280: msc_regions_temp mrt
3281: WHERE mism.plan_id = -1
3282: AND mism.from_location_id = p_from_location_id
3283: AND mism.sr_instance_id = p_from_instance_id
3284: AND mism.sr_instance_id2 = p_to_instance_id

Line 3439: 'INSERT INTO MSC_REGIONS_TEMP(

3435: --bug 4507141: l_dynstring indicates whether we are truely in distributed mode or not
3436: --IF l_dblink is not null THEN
3437: IF l_dynstring is not null THEN
3438: sql_stmt :=
3439: 'INSERT INTO MSC_REGIONS_TEMP(
3440: session_id,
3441: partner_site_id,
3442: region_id,
3443: region_type,

Line 3454: FROM msc_regions_temp' || l_dynstring || '

3450: region_id,
3451: region_type,
3452: zone_flag,
3453: partner_type
3454: FROM msc_regions_temp' || l_dynstring || '
3455: WHERE session_id = :x_session_id)';
3456: EXECUTE IMMEDIATE sql_stmt USING x_session_id;
3457:
3458: IF PG_DEBUG in ('Y', 'C') THEN

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

3455: WHERE session_id = :x_session_id)';
3456: EXECUTE IMMEDIATE sql_stmt USING x_session_id;
3457:
3458: IF PG_DEBUG in ('Y', 'C') THEN
3459: msc_sch_wb.atp_debug('Rows inserted in msc_regions_temp:'|| sql%rowcount);
3460: END IF;
3461: END IF;
3462: --bug3610706 End Changes
3463:

Line 3751: ' , msc_regions_temp mrt '||

3747: ',sysdate' ||
3748: ',:last_update_by' ||
3749: ',:last_update_login ' ||
3750: ' FROM msc_interorg_ship_methods msim '||
3751: ' , msc_regions_temp mrt '||
3752: -- ' , fnd_common_lookups fnd '||
3753: ' WHERE mrt.session_id = :x_session_id '||
3754: ' AND msim.plan_id = -1 '||
3755: ' AND msim.from_location_id = :l_from_location_id '||

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

3864: x_error_mesg := 'MRP_ATP_NO_SOURCES';
3865: END IF; -- IF l_sources.organization_id.COUNT > 0
3866: END IF; -- IF l_item_arr.COUNT > 0 THEN
3867:
3868: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
3869: -- application so as to clean up the table for another request within
3870: -- same session for Region Level Sourcing Support
3871:
3872: DELETE msc_regions_temp

Line 3872: DELETE msc_regions_temp

3868: -- Delete records from MSC_REGIONS_TEMP before returning back to calling
3869: -- application so as to clean up the table for another request within
3870: -- same session for Region Level Sourcing Support
3871:
3872: DELETE msc_regions_temp
3873: WHERE session_id = x_session_id;
3874:
3875: IF PG_DEBUG in ('Y', 'C') THEN
3876: msc_sch_wb.atp_debug('get_Supply_Sources: '

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

3873: WHERE session_id = x_session_id;
3874:
3875: IF PG_DEBUG in ('Y', 'C') THEN
3876: msc_sch_wb.atp_debug('get_Supply_Sources: '
3877: || 'Rows deleted from msc_regions_temp : '
3878: ||sql%rowcount);
3879: END IF;
3880: --ubadrina bug 2265012 begin
3881: EXCEPTION

Line 4939: msc_regions_temp mrt

4935: IS
4936: SELECT mism.ship_method, mism.intransit_time,
4937: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4938: FROM mtl_interorg_ship_methods mism,
4939: msc_regions_temp mrt
4940: WHERE mism.from_location_id = c_from_loc_id
4941: AND mism.to_region_id = mrt.region_id
4942: AND mrt.session_id = c_session_id
4943: AND mrt.partner_site_id = c_partner_site_id

Line 4956: msc_regions_temp mrt

4952: IS
4953: SELECT mism.ship_method, mism.intransit_time,
4954: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
4955: FROM msc_interorg_ship_methods mism,
4956: msc_regions_temp mrt
4957: WHERE mism.plan_id = -1
4958: AND mism.from_location_id = c_from_location_id
4959: AND mism.sr_instance_id = c_from_instance_id
4960: AND mism.sr_instance_id2 = c_to_instance_id

Line 5324: -- Delete data from MSC_REGIONS_TEMP

5320: end if; --sql rowcount = 0
5321: end if; -- p_org_id is not nULL
5322: end if; -- calling module check
5323:
5324: -- Delete data from MSC_REGIONS_TEMP
5325: DELETE MSC_REGIONS_TEMP
5326: where session_id = p_session_id;
5327:
5328: IF PG_DEBUG in ('Y', 'C') THEN

Line 5325: DELETE MSC_REGIONS_TEMP

5321: end if; -- p_org_id is not nULL
5322: end if; -- calling module check
5323:
5324: -- Delete data from MSC_REGIONS_TEMP
5325: DELETE MSC_REGIONS_TEMP
5326: where session_id = p_session_id;
5327:
5328: IF PG_DEBUG in ('Y', 'C') THEN
5329: msc_sch_wb.atp_debug (sql%rowcount || ' rows deleted from regions temp table.');

Line 5416: DELETE MSC_REGIONS_TEMP

5412: x_ship_method,
5413: x_intransit_time
5414: );
5415:
5416: DELETE MSC_REGIONS_TEMP
5417: WHERE session_id = p_session_id
5418: AND partner_site_id = p_to_customer_site_id;
5419:
5420: if (PG_DEBUG in ('Y','C')) then

Line 5644: MSC_REGIONS_TEMP MRT_INNER

5640: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
5641: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
5642: MSC_SOURCING_RULES MSR_INNER,
5643: MSC_SR_ASSIGNMENTS MSRA_INNER,
5644: MSC_REGIONS_TEMP MRT_INNER
5645: WHERE
5646: MSRA_INNER.ASSIGNMENT_TYPE = 9
5647: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
5648: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 5706: MSC_REGIONS_TEMP MRT

5702: MSC_SR_SOURCE_ORG SOURCE_ORG,
5703: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5704: MSC_SOURCING_RULES MSR,
5705: MSC_SR_ASSIGNMENTS MSRA,
5706: MSC_REGIONS_TEMP MRT
5707: WHERE
5708: MSRA.ASSIGNMENT_TYPE = 9
5709: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5710: AND MSRA.REGION_ID = MRT.REGION_ID

Line 5933: MSC_REGIONS_TEMP MRT_INNER

5929: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
5930: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
5931: MSC_SOURCING_RULES MSR_INNER,
5932: MSC_SR_ASSIGNMENTS MSRA_INNER,
5933: MSC_REGIONS_TEMP MRT_INNER
5934: WHERE
5935: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5936: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
5937: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 5995: MSC_REGIONS_TEMP MRT

5991: MSC_SR_SOURCE_ORG SOURCE_ORG,
5992: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5993: MSC_SOURCING_RULES MSR,
5994: MSC_SR_ASSIGNMENTS MSRA,
5995: MSC_REGIONS_TEMP MRT
5996: WHERE
5997: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5998: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5999: AND MSRA.REGION_ID = MRT.REGION_ID

Line 6221: MSC_REGIONS_TEMP MRT_INNER

6217: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
6218: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
6219: MSC_SOURCING_RULES MSR_INNER,
6220: MSC_SR_ASSIGNMENTS MSRA_INNER,
6221: MSC_REGIONS_TEMP MRT_INNER
6222: WHERE
6223: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
6224: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id
6225: AND MSRA_INNER.REGION_ID = MRT_INNER.REGION_ID

Line 6282: MSC_REGIONS_TEMP MRT

6278: MSC_SR_SOURCE_ORG SOURCE_ORG,
6279: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6280: MSC_SOURCING_RULES MSR,
6281: MSC_SR_ASSIGNMENTS MSRA,
6282: MSC_REGIONS_TEMP MRT
6283: WHERE
6284: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */
6285: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6286: AND MSRA.REGION_ID = MRT.REGION_ID

Line 6591: MSC_REGIONS_TEMP MRT_INNER,

6587: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
6588: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
6589: MSC_SOURCING_RULES MSR_INNER,
6590: MSC_SR_ASSIGNMENTS MSRA_INNER,
6591: MSC_REGIONS_TEMP MRT_INNER,
6592: MSC_SHIP_SET_TEMP MSST_INNER
6593: WHERE
6594: MSRA_INNER.ASSIGNMENT_TYPE = 9
6595: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6665: MSC_REGIONS_TEMP MRT,

6661: MSC_SR_SOURCE_ORG SOURCE_ORG,
6662: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6663: MSC_SOURCING_RULES MSR,
6664: MSC_SR_ASSIGNMENTS MSRA,
6665: MSC_REGIONS_TEMP MRT,
6666: MSC_SHIP_SET_TEMP MSST
6667: WHERE
6668: MSRA.ASSIGNMENT_TYPE = 9
6669: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7081: MSC_REGIONS_TEMP MRT_INNER,

7077: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
7078: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
7079: MSC_SOURCING_RULES MSR_INNER,
7080: MSC_SR_ASSIGNMENTS MSRA_INNER,
7081: MSC_REGIONS_TEMP MRT_INNER,
7082: MSC_SHIP_SET_TEMP MSST_INNER
7083: WHERE
7084:
7085: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */

Line 7154: MSC_REGIONS_TEMP MRT,

7150: MSC_SR_SOURCE_ORG SOURCE_ORG,
7151: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7152: MSC_SOURCING_RULES MSR,
7153: MSC_SR_ASSIGNMENTS MSRA,
7154: MSC_REGIONS_TEMP MRT,
7155: MSC_SHIP_SET_TEMP MSST
7156: WHERE
7157:
7158: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */

Line 7556: MSC_REGIONS_TEMP MRT_INNER,

7552: MSC_SR_SOURCE_ORG SOURCE_ORG_INNER,
7553: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,
7554: MSC_SOURCING_RULES MSR_INNER,
7555: MSC_SR_ASSIGNMENTS MSRA_INNER,
7556: MSC_REGIONS_TEMP MRT_INNER,
7557: MSC_SHIP_SET_TEMP MSST_INNER
7558: WHERE
7559: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
7560: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7627: MSC_REGIONS_TEMP MRT,

7623: MSC_SR_SOURCE_ORG SOURCE_ORG,
7624: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7625: MSC_SOURCING_RULES MSR,
7626: MSC_SR_ASSIGNMENTS MSRA,
7627: MSC_REGIONS_TEMP MRT,
7628: MSC_SHIP_SET_TEMP MSST
7629: WHERE
7630:
7631: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */

Line 8520: msc_regions_temp mrt

8516: IS
8517: SELECT intransit_time,
8518: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8519: FROM msc_interorg_ship_methods mism,
8520: msc_regions_temp mrt
8521: WHERE mism.plan_id = -1
8522: AND mism.from_location_id = p_from_loc_id
8523: AND mism.sr_instance_id = p_from_instance_id
8524: AND mism.sr_instance_id2 = p_to_instance_id

Line 8537: msc_regions_temp mrt

8533: IS
8534: SELECT ship_method, intransit_time,
8535: ((10 * (10 - mrt.region_type)) + DECODE(mrt.zone_flag, 'Y', 1, 0)) region_level
8536: FROM msc_interorg_ship_methods mism,
8537: msc_regions_temp mrt
8538: WHERE mism.plan_id = -1
8539: AND mism.from_location_id = p_from_loc_id
8540: AND mism.sr_instance_id = p_from_instance_id
8541: AND mism.sr_instance_id2 = p_to_instance_id

Line 8555: msc_regions_temp mrt

8551: IS
8552: SELECT intransit_time,
8553: mrt.region_type region_level -- collection has already translated data
8554: FROM msc_interorg_ship_methods mism,
8555: msc_regions_temp mrt
8556: WHERE mism.plan_id = -1
8557: AND mism.to_location_id = p_to_loc_id
8558: AND mism.sr_instance_id2 = p_to_instance_id
8559: AND mism.sr_instance_id = p_from_instance_id

Line 8572: msc_regions_temp mrt

8568: IS
8569: SELECT ship_method, intransit_time,
8570: mrt.region_type region_level -- collection has already translated data
8571: FROM msc_interorg_ship_methods mism,
8572: msc_regions_temp mrt
8573: WHERE mism.plan_id = -1
8574: AND mism.to_location_id = p_to_loc_id
8575: AND mism.sr_instance_id2 = p_to_instance_id
8576: AND mism.sr_instance_id = p_from_instance_id