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_SR_RECEIPT_ORG

Line 1029: msc_sr_receipt_org receiptorg,

1025: x_atp_sources.Ship_Method,
1026: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1027: FROM
1028: msc_sourcing_rules msr,
1029: msc_sr_receipt_org receiptorg,
1030: msc_sr_source_org sourceorg,
1031: msc_sr_assignments msa,
1032: msc_system_items msi,
1033: msc_ship_set_temp msst

Line 1094: msc_sr_receipt_org receiptorg,

1090: x_atp_sources.Lead_Time,
1091: x_atp_sources.Ship_Method,
1092: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1093: FROM msc_sourcing_rules msr,
1094: msc_sr_receipt_org receiptorg,
1095: msc_sr_source_org sourceorg,
1096: msc_sr_assignments msa,
1097: msc_item_categories cat,
1098: msc_ship_set_temp msst

Line 1168: msc_sr_receipt_org receiptorg,

1164: x_atp_sources.Ship_Method,
1165: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1166: FROM
1167: msc_sourcing_rules msr,
1168: msc_sr_receipt_org receiptorg,
1169: msc_sr_source_org sourceorg,
1170: msc_sr_assignments msa,
1171: msc_system_items msi,
1172: msc_ship_set_temp msst

Line 1232: msc_sr_receipt_org receiptorg,

1228: x_atp_sources.Ship_Method,
1229: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1230: FROM
1231: msc_sourcing_rules msr,
1232: msc_sr_receipt_org receiptorg,
1233: msc_sr_source_org sourceorg,
1234: msc_sr_assignments msa,
1235: msc_system_items msi,
1236: msc_ship_set_temp msst

Line 1290: msc_sr_receipt_org receipt_org,

1286: x_atp_sources.Ship_Method,
1287: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1288:
1289: FROM msc_sourcing_rules msr,
1290: msc_sr_receipt_org receipt_org,
1291: msc_sr_source_org source_org,
1292: msc_sr_assignments msa,
1293: msc_system_items msi
1294: WHERE msa.assignment_type = 3 and

Line 1350: msc_sr_receipt_org receipt_org,

1346: x_atp_sources.Lead_Time,
1347: x_atp_sources.Ship_Method,
1348: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1349: FROM msc_sourcing_rules msr,
1350: msc_sr_receipt_org receipt_org,
1351: msc_sr_source_org source_org,
1352: msc_sr_assignments msa,
1353: msc_item_categories cat
1354: WHERE msa.assignment_type = 2 and

Line 1413: msc_sr_receipt_org receipt_org,

1409: x_atp_sources.Lead_Time,
1410: x_atp_sources.Ship_Method,
1411: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1412: FROM msc_sourcing_rules msr,
1413: msc_sr_receipt_org receipt_org,
1414: msc_sr_source_org source_org,
1415: msc_sr_assignments msa,
1416: msc_system_items msi
1417: WHERE msa.assignment_type = 1 and

Line 1475: msc_sr_receipt_org receipt_org,

1471: x_atp_sources.Lead_Time,
1472: x_atp_sources.Ship_Method,
1473: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1474: FROM msc_sourcing_rules msr,
1475: msc_sr_receipt_org receipt_org,
1476: msc_sr_source_org source_org,
1477: msc_sr_assignments msa,
1478: msc_system_items msi
1479: WHERE msa.assignment_type = 1 and

Line 5502: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5498: BULK COLLECT INTO
5499: l_dist_level_type
5500: FROM
5501: MSC_SOURCING_RULES MSR,
5502: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5503: MSC_SR_ASSIGNMENTS MSRA,
5504: MSC_SR_SOURCE_ORG SOURCE_ORG
5505: WHERE
5506: MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5579: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5575: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
5576: FROM
5577: MSC_SYSTEM_ITEMS ITEM,
5578: MSC_SR_SOURCE_ORG SOURCE_ORG,
5579: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5580: MSC_SOURCING_RULES MSR,
5581: MSC_SR_ASSIGNMENTS MSRA,
5582: MSC_TP_SITE_ID_LID MTSIL
5583: WHERE

Line 5641: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

5637: INTO l_min_region_value
5638: FROM
5639: MSC_SYSTEM_ITEMS ITEM_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

Line 5703: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5699: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
5700: FROM
5701: MSC_SYSTEM_ITEMS ITEM,
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

Line 5786: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5782: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
5783: FROM
5784: MSC_ITEM_CATEGORIES CAT,
5785: MSC_SR_SOURCE_ORG SOURCE_ORG,
5786: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5787: MSC_SOURCING_RULES MSR,
5788: MSC_SR_ASSIGNMENTS MSRA,
5789: MSC_TP_SITE_ID_LID MTSIL
5790: WHERE

Line 5869: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5865: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
5866: FROM
5867: MSC_SYSTEM_ITEMS ITEM,
5868: MSC_SR_SOURCE_ORG SOURCE_ORG,
5869: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5870: MSC_SOURCING_RULES MSR,
5871: -- MSC_TRADING_PARTNER_SITES TP,
5872: -- MSC_TP_SITE_ID_LID MTSIL,
5873: MSC_SR_ASSIGNMENTS MSRA

Line 5930: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

5926: INTO l_min_region_value
5927: FROM
5928: MSC_ITEM_CATEGORIES CAT_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

Line 5992: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

5988: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
5989: FROM
5990: MSC_ITEM_CATEGORIES CAT,
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

Line 6076: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6072: FROM
6073: MSC_ITEM_CATEGORIES CAT,
6074: -- MSC_TRADING_PARTNER_SITES TP,
6075: MSC_SR_SOURCE_ORG SOURCE_ORG,
6076: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6077: MSC_SOURCING_RULES MSR,
6078: MSC_SR_ASSIGNMENTS MSRA
6079: -- MSC_TP_SITE_ID_LID MTSIL
6080: WHERE

Line 6158: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6154: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6155: FROM
6156: MSC_SYSTEM_ITEMS ITEM,
6157: MSC_SR_SOURCE_ORG SOURCE_ORG,
6158: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6159: MSC_SOURCING_RULES MSR,
6160: MSC_SR_ASSIGNMENTS MSRA,
6161: MSC_TP_SITE_ID_LID MTSIL
6162: WHERE

Line 6218: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

6214: INTO l_min_region_value
6215: FROM
6216: MSC_SYSTEM_ITEMS ITEM_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

Line 6279: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6275: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6276: FROM
6277: MSC_SYSTEM_ITEMS ITEM,
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

Line 6362: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6358: FROM
6359: MSC_SYSTEM_ITEMS ITEM,
6360: -- MSC_TRADING_PARTNER_SITES TP,
6361: MSC_SR_SOURCE_ORG SOURCE_ORG,
6362: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6363: MSC_SOURCING_RULES MSR,
6364: MSC_SR_ASSIGNMENTS MSRA
6365: -- MSC_TP_SITE_ID_LID MTSIL
6366: WHERE

Line 6452: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6448: '@@@'
6449: FROM
6450: MSC_SYSTEM_ITEMS ITEM,
6451: MSC_SR_SOURCE_ORG SOURCE_ORG,
6452: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6453: MSC_SOURCING_RULES MSR,
6454: MSC_SR_ASSIGNMENTS MSRA,
6455: MSC_TP_SITE_ID_LID MTSIL,
6456: MSC_SHIP_SET_TEMP MSST

Line 6588: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

6584: l_min_region_value_arr
6585: FROM
6586: MSC_SYSTEM_ITEMS ITEM_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

Line 6662: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6658: '@@@'
6659: FROM
6660: MSC_SYSTEM_ITEMS ITEM,
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

Line 6801: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6797: '@@@'
6798: FROM
6799: MSC_ITEM_CATEGORIES CAT,
6800: MSC_SR_SOURCE_ORG SOURCE_ORG,
6801: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6802: MSC_SOURCING_RULES MSR,
6803: MSC_SR_ASSIGNMENTS MSRA,
6804: MSC_TP_SITE_ID_LID MTSIL,
6805: MSC_SHIP_SET_TEMP MSST

Line 6945: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

6941: FROM
6942: MSC_SYSTEM_ITEMS ITEM,
6943: -- MSC_TRADING_PARTNER_SITES TP,
6944: MSC_SR_SOURCE_ORG SOURCE_ORG,
6945: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6946: MSC_SOURCING_RULES MSR,
6947: MSC_SR_ASSIGNMENTS MSRA,
6948: -- MSC_TP_SITE_ID_LID MTSIL,
6949: MSC_SHIP_SET_TEMP MSST

Line 7078: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

7074: l_min_region_value_arr
7075: FROM
7076: MSC_ITEM_CATEGORIES CAT_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

Line 7151: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

7147: '@@@'
7148: FROM
7149: MSC_ITEM_CATEGORIES CAT,
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

Line 7277: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

7273: FROM
7274: MSC_ITEM_CATEGORIES CAT,
7275: -- MSC_TRADING_PARTNER_SITES TP,
7276: MSC_SR_SOURCE_ORG SOURCE_ORG,
7277: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7278: MSC_SOURCING_RULES MSR,
7279: MSC_SR_ASSIGNMENTS MSRA,
7280: -- MSC_TP_SITE_ID_LID MTSIL,
7281: MSC_SHIP_SET_TEMP MSST

Line 7420: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

7416: '@@@'
7417: FROM
7418: MSC_SYSTEM_ITEMS ITEM,
7419: MSC_SR_SOURCE_ORG SOURCE_ORG,
7420: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7421: MSC_SOURCING_RULES MSR,
7422: MSC_SR_ASSIGNMENTS MSRA,
7423: MSC_TP_SITE_ID_LID MTSIL,
7424: MSC_SHIP_SET_TEMP MSST

Line 7553: MSC_SR_RECEIPT_ORG RECEIPT_ORG_INNER,

7549: l_min_region_value_arr
7550: FROM
7551: MSC_SYSTEM_ITEMS ITEM_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

Line 7624: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

7620: '@@@'
7621: FROM
7622: MSC_SYSTEM_ITEMS ITEM,
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

Line 7749: MSC_SR_RECEIPT_ORG RECEIPT_ORG,

7745: FROM
7746: MSC_SYSTEM_ITEMS ITEM,
7747: -- MSC_TRADING_PARTNER_SITES TP,
7748: MSC_SR_SOURCE_ORG SOURCE_ORG,
7749: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7750: MSC_SOURCING_RULES MSR,
7751: MSC_SR_ASSIGNMENTS MSRA,
7752: -- MSC_TP_SITE_ID_LID MTSIL,
7753: MSC_SHIP_SET_TEMP MSST