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 1030: msc_sr_assignments msa,

1026: FROM
1027: msc_sourcing_rules msr,
1028: msc_sr_receipt_org receiptorg,
1029: msc_sr_source_org sourceorg,
1030: msc_sr_assignments msa,
1031: msc_system_items msi,
1032: msc_ship_set_temp msst
1033: WHERE
1034: msa.assignment_type = 3

Line 1095: msc_sr_assignments msa,

1091: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
1092: FROM msc_sourcing_rules msr,
1093: msc_sr_receipt_org receiptorg,
1094: msc_sr_source_org sourceorg,
1095: msc_sr_assignments msa,
1096: msc_item_categories cat,
1097: msc_ship_set_temp msst
1098: WHERE msa.assignment_type = 2 and
1099: msa.assignment_set_id = p_assign_set_id and

Line 1169: msc_sr_assignments msa,

1165: FROM
1166: msc_sourcing_rules msr,
1167: msc_sr_receipt_org receiptorg,
1168: msc_sr_source_org sourceorg,
1169: msc_sr_assignments msa,
1170: msc_system_items msi,
1171: msc_ship_set_temp msst
1172: WHERE
1173: msa.assignment_type = 1

Line 1233: msc_sr_assignments msa,

1229: FROM
1230: msc_sourcing_rules msr,
1231: msc_sr_receipt_org receiptorg,
1232: msc_sr_source_org sourceorg,
1233: msc_sr_assignments msa,
1234: msc_system_items msi,
1235: msc_ship_set_temp msst
1236: WHERE
1237: msa.assignment_type = 1

Line 1291: msc_sr_assignments msa,

1287:
1288: FROM msc_sourcing_rules msr,
1289: msc_sr_receipt_org receipt_org,
1290: msc_sr_source_org source_org,
1291: msc_sr_assignments msa,
1292: msc_system_items msi
1293: WHERE msa.assignment_type = 3 and
1294: msa.assignment_set_id = p_assign_set_id and
1295: msa.inventory_item_id = l_inv_item_id and

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

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

Line 1351: msc_sr_assignments msa,

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

Line 1414: msc_sr_assignments msa,

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

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

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

Line 1476: msc_sr_assignments msa,

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

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

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

Line 5492: MSC_SR_ASSIGNMENTS MSRA,

5488: l_dist_level_type
5489: FROM
5490: MSC_SOURCING_RULES MSR,
5491: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5492: MSC_SR_ASSIGNMENTS MSRA,
5493: MSC_SR_SOURCE_ORG SOURCE_ORG
5494: WHERE
5495: MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5496: AND MSRA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID

Line 5570: MSC_SR_ASSIGNMENTS MSRA,

5566: MSC_SYSTEM_ITEMS ITEM,
5567: MSC_SR_SOURCE_ORG SOURCE_ORG,
5568: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5569: MSC_SOURCING_RULES MSR,
5570: MSC_SR_ASSIGNMENTS MSRA,
5571: MSC_TP_SITE_ID_LID MTSIL
5572: WHERE
5573: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
5574: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5632: MSC_SR_ASSIGNMENTS MSRA_INNER,

5628: MSC_SYSTEM_ITEMS ITEM_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

Line 5694: MSC_SR_ASSIGNMENTS MSRA,

5690: MSC_SYSTEM_ITEMS ITEM,
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

Line 5777: MSC_SR_ASSIGNMENTS MSRA,

5773: MSC_ITEM_CATEGORIES CAT,
5774: MSC_SR_SOURCE_ORG SOURCE_ORG,
5775: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5776: MSC_SOURCING_RULES MSR,
5777: MSC_SR_ASSIGNMENTS MSRA,
5778: MSC_TP_SITE_ID_LID MTSIL
5779: WHERE
5780: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
5781: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 5862: MSC_SR_ASSIGNMENTS MSRA

5858: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5859: MSC_SOURCING_RULES MSR,
5860: -- MSC_TRADING_PARTNER_SITES TP,
5861: -- MSC_TP_SITE_ID_LID MTSIL,
5862: MSC_SR_ASSIGNMENTS MSRA
5863: WHERE
5864: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */
5865: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5866: AND MSRA.INVENTORY_ITEM_ID = p_inventory_item_id

Line 5921: MSC_SR_ASSIGNMENTS MSRA_INNER,

5917: MSC_ITEM_CATEGORIES CAT_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

Line 5983: MSC_SR_ASSIGNMENTS MSRA,

5979: MSC_ITEM_CATEGORIES CAT,
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

Line 6067: MSC_SR_ASSIGNMENTS MSRA

6063: -- MSC_TRADING_PARTNER_SITES TP,
6064: MSC_SR_SOURCE_ORG SOURCE_ORG,
6065: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6066: MSC_SOURCING_RULES MSR,
6067: MSC_SR_ASSIGNMENTS MSRA
6068: -- MSC_TP_SITE_ID_LID MTSIL
6069: WHERE
6070: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */
6071: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6149: MSC_SR_ASSIGNMENTS MSRA,

6145: MSC_SYSTEM_ITEMS ITEM,
6146: MSC_SR_SOURCE_ORG SOURCE_ORG,
6147: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6148: MSC_SOURCING_RULES MSR,
6149: MSC_SR_ASSIGNMENTS MSRA,
6150: MSC_TP_SITE_ID_LID MTSIL
6151: WHERE
6152: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
6153: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6209: MSC_SR_ASSIGNMENTS MSRA_INNER,

6205: MSC_SYSTEM_ITEMS ITEM_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

Line 6270: MSC_SR_ASSIGNMENTS MSRA,

6266: MSC_SYSTEM_ITEMS ITEM,
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

Line 6353: MSC_SR_ASSIGNMENTS MSRA

6349: -- MSC_TRADING_PARTNER_SITES TP,
6350: MSC_SR_SOURCE_ORG SOURCE_ORG,
6351: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6352: MSC_SOURCING_RULES MSR,
6353: MSC_SR_ASSIGNMENTS MSRA
6354: -- MSC_TP_SITE_ID_LID MTSIL
6355: WHERE
6356: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
6357: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6443: MSC_SR_ASSIGNMENTS MSRA,

6439: MSC_SYSTEM_ITEMS ITEM,
6440: MSC_SR_SOURCE_ORG SOURCE_ORG,
6441: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6442: MSC_SOURCING_RULES MSR,
6443: MSC_SR_ASSIGNMENTS MSRA,
6444: MSC_TP_SITE_ID_LID MTSIL,
6445: MSC_SHIP_SET_TEMP MSST
6446: WHERE
6447: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */

Line 6579: MSC_SR_ASSIGNMENTS MSRA_INNER,

6575: MSC_SYSTEM_ITEMS ITEM_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

Line 6653: MSC_SR_ASSIGNMENTS MSRA,

6649: MSC_SYSTEM_ITEMS ITEM,
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

Line 6792: MSC_SR_ASSIGNMENTS MSRA,

6788: MSC_ITEM_CATEGORIES CAT,
6789: MSC_SR_SOURCE_ORG SOURCE_ORG,
6790: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6791: MSC_SOURCING_RULES MSR,
6792: MSC_SR_ASSIGNMENTS MSRA,
6793: MSC_TP_SITE_ID_LID MTSIL,
6794: MSC_SHIP_SET_TEMP MSST
6795: WHERE
6796: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */

Line 6936: MSC_SR_ASSIGNMENTS MSRA,

6932: -- MSC_TRADING_PARTNER_SITES TP,
6933: MSC_SR_SOURCE_ORG SOURCE_ORG,
6934: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6935: MSC_SOURCING_RULES MSR,
6936: MSC_SR_ASSIGNMENTS MSRA,
6937: -- MSC_TP_SITE_ID_LID MTSIL,
6938: MSC_SHIP_SET_TEMP MSST
6939: WHERE
6940:

Line 7069: MSC_SR_ASSIGNMENTS MSRA_INNER,

7065: MSC_ITEM_CATEGORIES CAT_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:

Line 7142: MSC_SR_ASSIGNMENTS MSRA,

7138: MSC_ITEM_CATEGORIES CAT,
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:

Line 7268: MSC_SR_ASSIGNMENTS MSRA,

7264: -- MSC_TRADING_PARTNER_SITES TP,
7265: MSC_SR_SOURCE_ORG SOURCE_ORG,
7266: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7267: MSC_SOURCING_RULES MSR,
7268: MSC_SR_ASSIGNMENTS MSRA,
7269: -- MSC_TP_SITE_ID_LID MTSIL,
7270: MSC_SHIP_SET_TEMP MSST
7271: WHERE
7272:

Line 7411: MSC_SR_ASSIGNMENTS MSRA,

7407: MSC_SYSTEM_ITEMS ITEM,
7408: MSC_SR_SOURCE_ORG SOURCE_ORG,
7409: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7410: MSC_SOURCING_RULES MSR,
7411: MSC_SR_ASSIGNMENTS MSRA,
7412: MSC_TP_SITE_ID_LID MTSIL,
7413: MSC_SHIP_SET_TEMP MSST
7414: WHERE
7415: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */

Line 7544: MSC_SR_ASSIGNMENTS MSRA_INNER,

7540: MSC_SYSTEM_ITEMS ITEM_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 */

Line 7615: MSC_SR_ASSIGNMENTS MSRA,

7611: MSC_SYSTEM_ITEMS ITEM,
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:

Line 7740: MSC_SR_ASSIGNMENTS MSRA,

7736: -- MSC_TRADING_PARTNER_SITES TP,
7737: MSC_SR_SOURCE_ORG SOURCE_ORG,
7738: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7739: MSC_SOURCING_RULES MSR,
7740: MSC_SR_ASSIGNMENTS MSRA,
7741: -- MSC_TP_SITE_ID_LID MTSIL,
7742: MSC_SHIP_SET_TEMP MSST
7743: WHERE
7744: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */