[Home] [Help]
1024: x_atp_sources.Lead_Time,
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,
1089: x_atp_sources.Preferred,
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,
1163: x_atp_sources.Lead_Time,
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,
1227: x_atp_sources.Lead_Time,
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,
1285: x_atp_sources.Lead_Time,
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
1345: x_atp_sources.Preferred,
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
1408: x_atp_sources.Preferred,
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
1470: x_atp_sources.Preferred,
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
5497: 9, 2) Level_id
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
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
5584: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
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
5646: MSRA_INNER.ASSIGNMENT_TYPE = 9
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
5708: MSRA.ASSIGNMENT_TYPE = 9
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
5791: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
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
5874: WHERE
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
5935: MSRA_INNER.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
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
5997: MSRA.ASSIGNMENT_TYPE = 8 /* CATEGORY-REGION */
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
6081: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */
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
6163: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
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
6223: MSRA_INNER.ASSIGNMENT_TYPE = 7 /* REGION */
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
6284: MSRA.ASSIGNMENT_TYPE = 7 /* REGION */
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
6367: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
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
6457: WHERE
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
6593: WHERE
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
6667: WHERE
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
6806: WHERE
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
6950: WHERE
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
7083: WHERE
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
7156: WHERE
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
7282: WHERE
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
7425: WHERE
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
7558: WHERE
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
7629: WHERE
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
7754: WHERE