[Home] [Help]
1023: x_atp_sources.Lead_Time,
1024: x_atp_sources.Ship_Method,
1025: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
1088: x_atp_sources.Preferred,
1089: x_atp_sources.Lead_Time,
1090: x_atp_sources.Ship_Method,
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,
1162: x_atp_sources.Lead_Time,
1163: x_atp_sources.Ship_Method,
1164: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
1226: x_atp_sources.Lead_Time,
1227: x_atp_sources.Ship_Method,
1228: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
1284: x_atp_sources.Lead_Time,
1285: x_atp_sources.Ship_Method,
1286: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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
1344: x_atp_sources.Preferred,
1345: x_atp_sources.Lead_Time,
1346: x_atp_sources.Ship_Method,
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
1407: x_atp_sources.Preferred,
1408: x_atp_sources.Lead_Time,
1409: x_atp_sources.Ship_Method,
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
1469: x_atp_sources.Preferred,
1470: x_atp_sources.Lead_Time,
1471: x_atp_sources.Ship_Method,
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
5486: 9, 2) Level_id
5487: BULK COLLECT INTO
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
5565: FROM
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 */
5627: FROM
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
5689: FROM
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
5772: FROM
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 */
5855: FROM
5856: MSC_SYSTEM_ITEMS ITEM,
5857: MSC_SR_SOURCE_ORG SOURCE_ORG,
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
5916: FROM
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 */
5978: FROM
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 */
6062: MSC_ITEM_CATEGORIES CAT,
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 */
6144: FROM
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 */
6204: FROM
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 */
6265: FROM
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 */
6348: MSC_SYSTEM_ITEMS ITEM,
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 */
6438: FROM
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
6574: FROM
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
6648: FROM
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
6787: FROM
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
6931: MSC_SYSTEM_ITEMS ITEM,
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
7064: FROM
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
7137: FROM
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
7263: MSC_ITEM_CATEGORIES CAT,
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
7406: FROM
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
7539: FROM
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
7610: FROM
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
7735: MSC_SYSTEM_ITEMS ITEM,
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