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_ASSIGNMENTS

Line 1031: msc_sr_assignments msa,

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
1034: WHERE
1035: msa.assignment_type = 3

Line 1096: msc_sr_assignments msa,

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
1099: WHERE msa.assignment_type = 2 and
1100: msa.assignment_set_id = p_assign_set_id and

Line 1170: msc_sr_assignments msa,

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
1173: WHERE
1174: msa.assignment_type = 1

Line 1234: msc_sr_assignments msa,

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
1237: WHERE
1238: msa.assignment_type = 1

Line 1292: msc_sr_assignments msa,

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
1295: msa.assignment_set_id = p_assign_set_id and
1296: msa.inventory_item_id = l_inv_item_id and

Line 1316: -- join with msc_sr_assignments (msa) will bring no rows.

1312: msi.plan_id = -1
1313: ORDER BY rank asc, allocation_percent desc;
1314: -- BUG 2283260 Note that join happens between msc_system_items(msi)
1315: -- and msc_sr_source_org (src) for org, instance as in certain cases
1316: -- join with msc_sr_assignments (msa) will bring no rows.
1317: -- Filter on item in msc_system_items.
1318:
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: msc_sch_wb.atp_debug('Count after item level = '||x_atp_sources.organization_id.count);

Line 1352: msc_sr_assignments msa,

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
1355: msa.assignment_set_id = p_assign_set_id and
1356: msa.inventory_item_id = l_inv_item_id and

Line 1415: msc_sr_assignments msa,

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
1418: msa.assignment_set_id = p_assign_set_id and
1419: ---msa.inventory_item_id = l_inv_item_id and

Line 1441: -- join with msc_sr_assignments (msa) will bring no rows.

1437: msi.plan_id = -1
1438: ORDER BY rank asc, allocation_percent desc;
1439: -- BUG 2283260 Note that join happens between msc_system_items(msi)
1440: -- and msc_sr_source_org (src) for org, instance as in certain cases
1441: -- join with msc_sr_assignments (msa) will bring no rows.
1442: -- Filter on item in msc_system_items.
1443: END IF;
1444:
1445: IF (x_atp_sources.organization_id.count = 0) then

Line 1477: msc_sr_assignments msa,

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
1480: msa.assignment_set_id = p_assign_set_id and
1481: ---msa.inventory_item_id = l_inv_item_id and

Line 1501: -- join with msc_sr_assignments (msa) will bring no rows.

1497: msi.plan_id = -1
1498: ORDER BY rank asc, allocation_percent desc;
1499: -- BUG 2283260 Note that join happens between msc_system_items(msi)
1500: -- and msc_sr_source_org (src) for org, instance as in certain cases
1501: -- join with msc_sr_assignments (msa) will bring no rows.
1502: -- Filter on item in msc_system_items.
1503: END IF;
1504:
1505: END IF;

Line 5503: MSC_SR_ASSIGNMENTS MSRA,

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
5507: AND MSRA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID

Line 5581: MSC_SR_ASSIGNMENTS MSRA,

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
5584: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
5585: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5643: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
5646: MSRA_INNER.ASSIGNMENT_TYPE = 9
5647: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5705: MSC_SR_ASSIGNMENTS MSRA,

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
5708: MSRA.ASSIGNMENT_TYPE = 9
5709: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5788: MSC_SR_ASSIGNMENTS MSRA,

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
5791: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
5792: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5873: MSC_SR_ASSIGNMENTS MSRA

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
5874: WHERE
5875: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */
5876: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5877: AND MSRA.INVENTORY_ITEM_ID = p_inventory_item_id

Line 5932: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
5935: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5936: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5994: MSC_SR_ASSIGNMENTS MSRA,

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
5997: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
5998: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6078: MSC_SR_ASSIGNMENTS MSRA

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
6081: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */
6082: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6160: MSC_SR_ASSIGNMENTS MSRA,

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
6163: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
6164: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6220: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
6223: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
6224: AND MSRA_INNER.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6281: MSC_SR_ASSIGNMENTS MSRA,

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
6284: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */
6285: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6364: MSC_SR_ASSIGNMENTS MSRA

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
6367: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
6368: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6454: MSC_SR_ASSIGNMENTS MSRA,

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
6457: WHERE
6458: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */

Line 6590: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
6593: WHERE
6594: MSRA_INNER.ASSIGNMENT_TYPE = 9

Line 6664: MSC_SR_ASSIGNMENTS MSRA,

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
6667: WHERE
6668: MSRA.ASSIGNMENT_TYPE = 9

Line 6803: MSC_SR_ASSIGNMENTS MSRA,

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
6806: WHERE
6807: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */

Line 6947: MSC_SR_ASSIGNMENTS MSRA,

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
6950: WHERE
6951:

Line 7080: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
7083: WHERE
7084:

Line 7153: MSC_SR_ASSIGNMENTS MSRA,

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
7156: WHERE
7157:

Line 7279: MSC_SR_ASSIGNMENTS MSRA,

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
7282: WHERE
7283:

Line 7422: MSC_SR_ASSIGNMENTS MSRA,

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
7425: WHERE
7426: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */

Line 7555: MSC_SR_ASSIGNMENTS MSRA_INNER,

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
7558: WHERE
7559: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */

Line 7626: MSC_SR_ASSIGNMENTS MSRA,

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
7629: WHERE
7630:

Line 7751: MSC_SR_ASSIGNMENTS MSRA,

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
7754: WHERE
7755: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */