[Home] [Help]
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
1100: msa.inventory_item_id = msst.inventory_item_id
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
1356: msa.sourcing_rule_id = msr.sourcing_rule_id and
1371: --Bug4567833
1372: NVL(source_org.circular_src, 'N') <> 'Y'
1373: ORDER BY rank asc, allocation_percent desc;
1374: -- BUG 2283260 Additional join between msc_sr_source_org snd
1375: -- msc_item_categories to ensure that the source is valid for item.
1376: END IF;
1377:
1378: IF (x_atp_sources.organization_id.count = 0) and (p_organization_id is not null) then
1379: IF PG_DEBUG in ('Y', 'C') THEN
5769: x_atp_sources.Lead_Time,
5770: x_atp_sources.Ship_Method,
5771: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
5913: -- Searching sources for min value of expression.
5914: SELECT NVL(MIN(5000 + ((10 - NVL(MRT_INNER.REGION_TYPE, 0)) * 10) + DECODE(MRT_INNER.ZONE_FLAG, 'Y', 1, 0)), 0)
5915: INTO l_min_region_value
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,
5975: x_atp_sources.Lead_Time,
5976: x_atp_sources.Ship_Method,
5977: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
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,
6058: x_atp_sources.Lead_Time,
6059: x_atp_sources.Ship_Method,
6060: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6061: FROM
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,
6784: 0,
6785: -1,
6786: '@@@'
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,
7061: BULK COLLECT INTO
7062: l_inventory_item_id_arr,
7063: l_min_region_value_arr
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,
7134: 0,
7135: -1,
7136: '@@@'
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,
7259: 0,
7260: -1,
7261: '@@@'
7262: FROM
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,