[Home] [Help]
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
1101: msa.inventory_item_id = msst.inventory_item_id
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
1357: msa.sourcing_rule_id = msr.sourcing_rule_id and
1372: --Bug4567833
1373: NVL(source_org.circular_src, 'N') <> 'Y'
1374: ORDER BY rank asc, allocation_percent desc;
1375: -- BUG 2283260 Additional join between msc_sr_source_org snd
1376: -- msc_item_categories to ensure that the source is valid for item.
1377: END IF;
1378:
1379: IF (x_atp_sources.organization_id.count = 0) and (p_organization_id is not null) then
1380: IF PG_DEBUG in ('Y', 'C') THEN
5780: x_atp_sources.Lead_Time,
5781: x_atp_sources.Ship_Method,
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,
5924: -- Searching sources for min value of expression.
5925: SELECT NVL(MIN(5000 + ((10 - NVL(MRT_INNER.REGION_TYPE, 0)) * 10) + DECODE(MRT_INNER.ZONE_FLAG, 'Y', 1, 0)), 0)
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,
5986: x_atp_sources.Lead_Time,
5987: x_atp_sources.Ship_Method,
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,
6069: x_atp_sources.Lead_Time,
6070: x_atp_sources.Ship_Method,
6071: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
6795: 0,
6796: -1,
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,
7072: BULK COLLECT INTO
7073: l_inventory_item_id_arr,
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,
7145: 0,
7146: -1,
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,
7270: 0,
7271: -1,
7272: '@@@'
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,