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.INV_UI_RCV_LOVS dependencies on MTL_PARAMETERS

Line 64: , mtl_parameters mp

60: , rcv_transactions rt
61: , po_headers_all poh
62: , po_lines_all pol
63: , po_line_types plt
64: , mtl_parameters mp
65: WHERE poh.po_header_id = ms.po_header_id
66: AND ms.quantity > 0
67: AND ms.supply_type_code = 'RECEIVING'
68: AND ms.to_organization_id = p_organization_id

Line 112: mtl_Parameters mp

108:
109: FROM rcv_Supply ms ,
110: rcv_Transactions rt,
111: po_Headers_trx_v poh , -- CLM, bug 9403291
112: mtl_Parameters mp
113: WHERE poh.po_Header_Id = ms.po_Header_Id
114: AND ms.Quantity > 0
115: AND ms.Supply_Type_Code = 'RECEIVING'
116: AND ms.To_Organization_Id = p_organization_id

Line 181: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

177: , to_char(poh.org_id) --
178: FROM po_headers_trx_v poh -- CLM project, bug 9403291
179: WHERE exists (SELECT 'Valid PO Shipments'
180: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
181: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
182: , mtl_parameters mp,
183: rcv_parameters rp
184: -- End for Bug 7440217
185: WHERE poh.po_header_id = poll.po_header_id

Line 182: , mtl_parameters mp,

178: FROM po_headers_trx_v poh -- CLM project, bug 9403291
179: WHERE exists (SELECT 'Valid PO Shipments'
180: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
181: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
182: , mtl_parameters mp,
183: rcv_parameters rp
184: -- End for Bug 7440217
185: WHERE poh.po_header_id = poll.po_header_id
186: AND Nvl(poll.approved_flag,'N') = 'Y'

Line 225: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

221: FROM po_headers_trx_v poh -- CLM project, bug 9403291
222: , rcv_shipment_lines rsl
223: WHERE exists (SELECT 'Valid PO Shipments'
224: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
225: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
226: , mtl_parameters mp,
227: rcv_parameters rp
228: -- End for Bug 7440217
229: WHERE poh.po_header_id = poll.po_header_id

Line 226: , mtl_parameters mp,

222: , rcv_shipment_lines rsl
223: WHERE exists (SELECT 'Valid PO Shipments'
224: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
225: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
226: , mtl_parameters mp,
227: rcv_parameters rp
228: -- End for Bug 7440217
229: WHERE poh.po_header_id = poll.po_header_id
230: AND Nvl(poll.approved_flag,'N') = 'Y'

Line 277: mtl_parameters mp --BUG 5166887

273: PO_LINES_trx_v pol, -- CLM project, bug 9403291
274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291
275: PO_HEADERS_trx_v POH, -- CLM project, bug 9403291
276: po_line_types plt,--BUG 5166887
277: mtl_parameters mp --BUG 5166887
278: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not
279: , rcv_parameters rp
280: -- End for Bug 7440217
281: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'

Line 352: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

348: and nvl(pr.approved_flag, 'N') <> 'N'
349: and nvl(pr.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
350: AND exists (SELECT 'Valid PO Shipments' --Added the exists to fix bug4350175
351: FROM po_line_locations_all poll
352: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
353: , mtl_parameters mp,
354: rcv_parameters rp
355: -- End for Bug 7440217
356: WHERE pr.po_header_id = poll.po_header_id

Line 353: , mtl_parameters mp,

349: and nvl(pr.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
350: AND exists (SELECT 'Valid PO Shipments' --Added the exists to fix bug4350175
351: FROM po_line_locations_all poll
352: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
353: , mtl_parameters mp,
354: rcv_parameters rp
355: -- End for Bug 7440217
356: WHERE pr.po_header_id = poll.po_header_id
357: AND pr.po_release_id = poll.po_release_id

Line 449: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

445: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
446: and pl.po_header_id = p_po_header_id
447: and exists (SELECT 'Valid PO Shipments'
448: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
449: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
450: , mtl_parameters mp,
451: rcv_parameters rp
452: -- End for Bug 7440217
453: WHERE poll.po_header_id = pl.po_header_id

Line 450: , mtl_parameters mp,

446: and pl.po_header_id = p_po_header_id
447: and exists (SELECT 'Valid PO Shipments'
448: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
449: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
450: , mtl_parameters mp,
451: rcv_parameters rp
452: -- End for Bug 7440217
453: WHERE poll.po_header_id = pl.po_header_id
454: AND poll.po_line_id = pl.po_line_id

Line 724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

720: RCV_SHIPMENT_HEADERS RSH,
721: PO_LOOKUP_CODES PLC,
722: PO_LINE_LOCATIONS_ALL PLL,
723: HR_ALL_ORGANIZATION_UNITS_TL OOD
724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
725: , mtl_parameters mp,
726: rcv_parameters rp
727: -- End for Bug 7440217
728: WHERE RSH.receipt_source_code <> 'VENDOR'

Line 725: , mtl_parameters mp,

721: PO_LOOKUP_CODES PLC,
722: PO_LINE_LOCATIONS_ALL PLL,
723: HR_ALL_ORGANIZATION_UNITS_TL OOD
724: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
725: , mtl_parameters mp,
726: rcv_parameters rp
727: -- End for Bug 7440217
728: WHERE RSH.receipt_source_code <> 'VENDOR'
729: AND RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'

Line 959: , mtl_parameters mp

955: FROM rcv_supply ms
956: , rcv_transactions rt
957: , rcv_shipment_headers rsh
958: , rcv_shipment_lines rsl
959: , mtl_parameters mp
960: WHERE rsh.shipment_header_id = ms.shipment_header_id
961: AND rsh.shipment_header_id = rt.shipment_header_id
962: AND ms.to_organization_id = p_organization_id
963: and mp.organization_id = ms.to_organization_id

Line 1118: mtl_parameters mp --BUG 5166887

1114: RCV_SHIPMENT_HEADERS RSH,
1115: RCV_SHIPMENT_LINES RSL,
1116: PO_LOOKUP_CODES PLC,
1117: PO_LINE_LOCATIONS_ALL PLL,
1118: mtl_parameters mp --BUG 5166887
1119: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'
1120: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1121: AND RT.TRANSACTION_TYPE = PLC.LOOKUP_CODE
1122: AND PLC.LOOKUP_TYPE = 'RCV TRANSACTION TYPE'

Line 1567: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1563: SELECT
1564: 'Valid PO Shipments'
1565: FROM po_lines_trx_v pl, -- CLM project, bug 9403291
1566: po_line_locations_trx_v poll -- CLM project, bug 9403291
1567: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1568: , mtl_parameters mp,
1569: rcv_parameters rp
1570: -- End for Bug 7440217
1571: WHERE pl.item_id = p_inventory_item_id

Line 1568: , mtl_parameters mp,

1564: 'Valid PO Shipments'
1565: FROM po_lines_trx_v pl, -- CLM project, bug 9403291
1566: po_line_locations_trx_v poll -- CLM project, bug 9403291
1567: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1568: , mtl_parameters mp,
1569: rcv_parameters rp
1570: -- End for Bug 7440217
1571: WHERE pl.item_id = p_inventory_item_id
1572: AND pl.po_header_id = poh.po_header_id

Line 1633: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1629: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
1630: mtl_related_items mri ,
1631: mtl_system_items_kfv msi ,
1632: po_line_locations_trx_v poll -- CLM project, bug 9403291
1633: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1634: , mtl_parameters mp,
1635: rcv_parameters rp
1636: -- End for Bug 7440217
1637: WHERE msi.organization_id = p_organization_id

Line 1634: , mtl_parameters mp,

1630: mtl_related_items mri ,
1631: mtl_system_items_kfv msi ,
1632: po_line_locations_trx_v poll -- CLM project, bug 9403291
1633: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1634: , mtl_parameters mp,
1635: rcv_parameters rp
1636: -- End for Bug 7440217
1637: WHERE msi.organization_id = p_organization_id
1638: AND pl.po_header_id = poh.po_header_id

Line 1707: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1703: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1704: fnd_lookup_values_vl flv ,
1705: po_lines_trx_v pl, -- CLM project, bug 9403291
1706: po_line_locations_trx_v poll -- CLM project, bug 9403291
1707: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1708: , mtl_parameters mp,
1709: rcv_parameters rp
1710: -- End for Bug 7440217
1711: WHERE flv.lookup_code = 'PO'

Line 1708: , mtl_parameters mp,

1704: fnd_lookup_values_vl flv ,
1705: po_lines_trx_v pl, -- CLM project, bug 9403291
1706: po_line_locations_trx_v poll -- CLM project, bug 9403291
1707: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1708: , mtl_parameters mp,
1709: rcv_parameters rp
1710: -- End for Bug 7440217
1711: WHERE flv.lookup_code = 'PO'
1712: AND flv.lookup_type = 'DOC_TYPE'

Line 1768: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1764: po_lines_trx_v pl , -- CLM project, bug 9403291
1765: mtl_related_items mri ,
1766: mtl_system_items_kfv msi ,
1767: po_line_locations_trx_v poll -- CLM project, bug 9403291
1768: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1769: , mtl_parameters mp,
1770: rcv_parameters rp
1771: -- End for Bug 7440217
1772: WHERE flv.lookup_code = 'PO'

Line 1769: , mtl_parameters mp,

1765: mtl_related_items mri ,
1766: mtl_system_items_kfv msi ,
1767: po_line_locations_trx_v poll -- CLM project, bug 9403291
1768: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1769: , mtl_parameters mp,
1770: rcv_parameters rp
1771: -- End for Bug 7440217
1772: WHERE flv.lookup_code = 'PO'
1773: AND flv.lookup_type = 'DOC_TYPE'

Line 1831: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1827: po_lines_trx_v pl , -- CLM project, bug 9403291
1828: mtl_related_items mri ,
1829: mtl_system_items_kfv msi ,
1830: po_line_locations_trx_v poll -- CLM project, bug 9403291
1831: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1832: , mtl_parameters mp,
1833: rcv_parameters rp
1834: -- End for Bug 7440217
1835: WHERE flv.lookup_code = 'PO'

Line 1832: , mtl_parameters mp,

1828: mtl_related_items mri ,
1829: mtl_system_items_kfv msi ,
1830: po_line_locations_trx_v poll -- CLM project, bug 9403291
1831: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1832: , mtl_parameters mp,
1833: rcv_parameters rp
1834: -- End for Bug 7440217
1835: WHERE flv.lookup_code = 'PO'
1836: AND flv.lookup_type = 'DOC_TYPE'

Line 1911: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1907: SELECT
1908: 'Valid PO Shipments'
1909: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
1910: po_line_locations_trx_v poll -- CLM project, bug 9403291
1911: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1912: , mtl_parameters mp,
1913: rcv_parameters rp
1914: -- End for Bug 7440217
1915: WHERE pl.ITEM_ID IS NULL

Line 1912: , mtl_parameters mp,

1908: 'Valid PO Shipments'
1909: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
1910: po_line_locations_trx_v poll -- CLM project, bug 9403291
1911: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1912: , mtl_parameters mp,
1913: rcv_parameters rp
1914: -- End for Bug 7440217
1915: WHERE pl.ITEM_ID IS NULL
1916: AND pl.item_description LIKE p_item_description||'%'

Line 1978: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

1974: (
1975: SELECT
1976: 'Valid PO Shipments'
1977: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
1978: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1979: , mtl_parameters mp,
1980: rcv_parameters rp
1981: -- End for Bug 7440217
1982: WHERE poh.po_header_id = poll.po_header_id

Line 1979: , mtl_parameters mp,

1975: SELECT
1976: 'Valid PO Shipments'
1977: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
1978: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1979: , mtl_parameters mp,
1980: rcv_parameters rp
1981: -- End for Bug 7440217
1982: WHERE poh.po_header_id = poll.po_header_id
1983: AND poll.approved_flag = 'Y'

Line 2467: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

2463: SELECT
2464: 'Valid PO Shipments'
2465: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2466: po_line_locations_trx_v poll --CLM project, bug 9403291
2467: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2468: , mtl_parameters mp,
2469: rcv_parameters rp
2470: -- End for Bug 7440217
2471: WHERE pl.po_header_id = poh.po_header_id

Line 2468: , mtl_parameters mp,

2464: 'Valid PO Shipments'
2465: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2466: po_line_locations_trx_v poll --CLM project, bug 9403291
2467: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2468: , mtl_parameters mp,
2469: rcv_parameters rp
2470: -- End for Bug 7440217
2471: WHERE pl.po_header_id = poh.po_header_id
2472: AND Nvl(pl.vendor_product_num,' ') = Nvl(p_vendor_prod_num, Nvl(pl.vendor_product_num,' '))

Line 2534: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

2530: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2531: mtl_related_items mri ,
2532: mtl_system_items_kfv msi ,
2533: po_line_locations_trx_v poll -- CLM project, bug 9403291
2534: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2535: , mtl_parameters mp,
2536: rcv_parameters rp
2537: -- End for Bug 7440217
2538: WHERE msi.organization_id = p_organization_id

Line 2535: , mtl_parameters mp,

2531: mtl_related_items mri ,
2532: mtl_system_items_kfv msi ,
2533: po_line_locations_trx_v poll -- CLM project, bug 9403291
2534: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2535: , mtl_parameters mp,
2536: rcv_parameters rp
2537: -- End for Bug 7440217
2538: WHERE msi.organization_id = p_organization_id
2539: AND

Line 2614: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

2610: SELECT
2611: 'Valid PO Shipments'
2612: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2613: po_line_locations_trx_v poll -- CLM project, bug 9403291
2614: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2615: , mtl_parameters mp,
2616: rcv_parameters rp
2617: -- End for Bug 7440217
2618: WHERE pl.item_id IS NULL

Line 2615: , mtl_parameters mp,

2611: 'Valid PO Shipments'
2612: FROM po_lines_trx_v pl , -- CLM project, bug 9403291
2613: po_line_locations_trx_v poll -- CLM project, bug 9403291
2614: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2615: , mtl_parameters mp,
2616: rcv_parameters rp
2617: -- End for Bug 7440217
2618: WHERE pl.item_id IS NULL
2619: AND pl.item_description LIKE p_item_description||'%'

Line 2986: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

2982: and (pl.item_id is null or msi.organization_id = p_organization_id) --Bug 8687063
2983: and pl.po_header_id = p_po_header_id
2984: and exists (SELECT 'Valid PO Shipments'
2985: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
2986: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2987: , mtl_parameters mp,
2988: rcv_parameters rp
2989: -- End for Bug 7440217
2990: WHERE poll.po_header_id = pl.po_header_id

Line 2987: , mtl_parameters mp,

2983: and pl.po_header_id = p_po_header_id
2984: and exists (SELECT 'Valid PO Shipments'
2985: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
2986: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2987: , mtl_parameters mp,
2988: rcv_parameters rp
2989: -- End for Bug 7440217
2990: WHERE poll.po_header_id = pl.po_header_id
2991: AND poll.po_line_id = pl.po_line_id

Line 3032: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3028: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
3029: and pl.po_header_id = p_po_header_id
3030: and exists (SELECT 'Valid PO Shipments'
3031: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
3032: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3033: , mtl_parameters mp,
3034: rcv_parameters rp
3035: -- End for Bug 7440217
3036: WHERE poll.po_header_id = pl.po_header_id

Line 3033: , mtl_parameters mp,

3029: and pl.po_header_id = p_po_header_id
3030: and exists (SELECT 'Valid PO Shipments'
3031: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
3032: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3033: , mtl_parameters mp,
3034: rcv_parameters rp
3035: -- End for Bug 7440217
3036: WHERE poll.po_header_id = pl.po_header_id
3037: AND poll.po_line_id = pl.po_line_id

Line 3249: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3245: , pr.release_date
3246: from po_releases_all pr
3247: , po_line_locations_all pll
3248: , po_lines_all pl
3249: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3250: , mtl_parameters mp
3251: , rcv_parameters rp
3252: -- End for Bug 7440217
3253: where pr.po_header_id = p_po_header_id

Line 3250: , mtl_parameters mp

3246: from po_releases_all pr
3247: , po_line_locations_all pll
3248: , po_lines_all pl
3249: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3250: , mtl_parameters mp
3251: , rcv_parameters rp
3252: -- End for Bug 7440217
3253: where pr.po_header_id = p_po_header_id
3254: and nvl(pr.cancel_flag, 'N') = 'N'

Line 3439: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3435: and pol.po_header_id = p_poHeaderID -- Bug 14645109 s change this
3436:
3437: and exists (select 1
3438: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3439: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3440: , mtl_parameters mp,
3441: rcv_parameters rp
3442: -- End for Bug 7440217
3443: WHERE NVL(pll.closed_code,'OPEN')

Line 3440: , mtl_parameters mp,

3436:
3437: and exists (select 1
3438: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3439: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3440: , mtl_parameters mp,
3441: rcv_parameters rp
3442: -- End for Bug 7440217
3443: WHERE NVL(pll.closed_code,'OPEN')
3444: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 3536: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3532: and pol.item_id = mri.related_item_id
3533: and mri.reciprocal_flag = 'Y'))
3534: and exists (select 1
3535: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3536: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3537: , mtl_parameters mp,
3538: rcv_parameters rp
3539: -- End for Bug 7440217
3540: where NVL(pll.closed_code,'OPEN')

Line 3537: , mtl_parameters mp,

3533: and mri.reciprocal_flag = 'Y'))
3534: and exists (select 1
3535: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3536: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3537: , mtl_parameters mp,
3538: rcv_parameters rp
3539: -- End for Bug 7440217
3540: where NVL(pll.closed_code,'OPEN')
3541: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 3629: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3625: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol
3626: where pol.po_header_id = p_poHeaderID
3627: and exists (select 1
3628: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3629: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3630: , mtl_parameters mp,
3631: rcv_parameters rp
3632: -- End for Bug 7440217
3633: WHERE NVL(pll.closed_code,'OPEN')

Line 3630: , mtl_parameters mp,

3626: where pol.po_header_id = p_poHeaderID
3627: and exists (select 1
3628: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3629: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3630: , mtl_parameters mp,
3631: rcv_parameters rp
3632: -- End for Bug 7440217
3633: WHERE NVL(pll.closed_code,'OPEN')
3634: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 3734: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3730: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
3731: to shipments due to be received only in the organizationientered with.*/
3732: and exists (select 1
3733: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3734: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3735: , mtl_parameters mp,
3736: rcv_parameters rp
3737: -- End for Bug 7440217
3738: where pll.po_header_id = p_poHeaderID

Line 3735: , mtl_parameters mp,

3731: to shipments due to be received only in the organizationientered with.*/
3732: and exists (select 1
3733: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3734: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3735: , mtl_parameters mp,
3736: rcv_parameters rp
3737: -- End for Bug 7440217
3738: where pll.po_header_id = p_poHeaderID
3739: and pll.po_line_id = pol.po_line_id

Line 3826: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3822: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291
3823: where pol.po_header_id = p_poHeaderID
3824: and exists (select 1
3825: from po_line_locations_trx_v pll --CLM project, bug 9403291
3826: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3827: , mtl_parameters mp,
3828: rcv_parameters rp
3829: -- End for Bug 7440217
3830: WHERE NVL(pll.closed_code,'OPEN')

Line 3827: , mtl_parameters mp,

3823: where pol.po_header_id = p_poHeaderID
3824: and exists (select 1
3825: from po_line_locations_trx_v pll --CLM project, bug 9403291
3826: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3827: , mtl_parameters mp,
3828: rcv_parameters rp
3829: -- End for Bug 7440217
3830: WHERE NVL(pll.closed_code,'OPEN')
3831: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 3932: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

3928: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
3929: to shipments due to be received only in the organizationientered with.*/
3930: and exists (select 1
3931: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3932: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3933: , mtl_parameters mp,
3934: rcv_parameters rp
3935: -- End for Bug 7440217
3936: where pll.po_header_id = p_poHeaderID

Line 3933: , mtl_parameters mp,

3929: to shipments due to be received only in the organizationientered with.*/
3930: and exists (select 1
3931: from po_line_locations_trx_v pll -- CLM project, bug 9403291
3932: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3933: , mtl_parameters mp,
3934: rcv_parameters rp
3935: -- End for Bug 7440217
3936: where pll.po_header_id = p_poHeaderID
3937: -- For Bug 7440217 Checking if it is LCM enabled

Line 4019: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4015:
4016: and pol.po_line_id = p_poLineID
4017: and exists (select 1
4018: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4019: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4020: , mtl_parameters mp,
4021: rcv_parameters rp
4022: -- End for Bug 7440217
4023: where NVL(pll.closed_code, 'OPEN')

Line 4020: , mtl_parameters mp,

4016: and pol.po_line_id = p_poLineID
4017: and exists (select 1
4018: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4019: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4020: , mtl_parameters mp,
4021: rcv_parameters rp
4022: -- End for Bug 7440217
4023: where NVL(pll.closed_code, 'OPEN')
4024: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' )

Line 4116: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4112: and mri.reciprocal_flag = 'Y'))
4113: and pol.po_line_id = p_poLineID
4114: and exists (select 1
4115: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4116: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4117: , mtl_parameters mp,
4118: rcv_parameters rp
4119: -- End for Bug 7440217
4120: where NVL(pll.closed_code,'OPEN')

Line 4117: , mtl_parameters mp,

4113: and pol.po_line_id = p_poLineID
4114: and exists (select 1
4115: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4116: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4117: , mtl_parameters mp,
4118: rcv_parameters rp
4119: -- End for Bug 7440217
4120: where NVL(pll.closed_code,'OPEN')
4121: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 4209: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4205: WHERE pl.po_header_id = p_poHeaderID
4206: and pl.po_line_id = p_poLineID
4207: and exists (select 1
4208: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4209: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4210: , mtl_parameters mp,
4211: rcv_parameters rp
4212: -- End for Bug 7440217
4213: where NVL(pll.closed_code, 'OPEN')

Line 4210: , mtl_parameters mp,

4206: and pl.po_line_id = p_poLineID
4207: and exists (select 1
4208: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4209: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4210: , mtl_parameters mp,
4211: rcv_parameters rp
4212: -- End for Bug 7440217
4213: where NVL(pll.closed_code, 'OPEN')
4214: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING' , 'CLOSED') -- 3687249

Line 4313: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4309: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
4310: to shipments due to be received only in the organization entered with.*/
4311: and exists (select 1
4312: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4313: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4314: , mtl_parameters mp,
4315: rcv_parameters rp
4316: -- End for Bug 7440217
4317: where pll.po_header_id = p_poHeaderID

Line 4314: , mtl_parameters mp,

4310: to shipments due to be received only in the organization entered with.*/
4311: and exists (select 1
4312: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4313: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4314: , mtl_parameters mp,
4315: rcv_parameters rp
4316: -- End for Bug 7440217
4317: where pll.po_header_id = p_poHeaderID
4318: and pll.po_line_id = pol.po_line_id

Line 4405: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4401: WHERE pl.po_header_id = p_poHeaderID
4402: and pl.po_line_id = p_poLineID
4403: and exists (select 1
4404: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4405: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4406: , mtl_parameters mp,
4407: rcv_parameters rp
4408: -- End for Bug 7440217
4409: where NVL(pll.closed_code, 'OPEN')

Line 4406: , mtl_parameters mp,

4402: and pl.po_line_id = p_poLineID
4403: and exists (select 1
4404: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4405: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4406: , mtl_parameters mp,
4407: rcv_parameters rp
4408: -- End for Bug 7440217
4409: where NVL(pll.closed_code, 'OPEN')
4410: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 4512: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4508: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
4509: to shipments due to be received only in the organizationientered with.*/
4510: and exists (select 1
4511: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4512: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4513: , mtl_parameters mp,
4514: rcv_parameters rp
4515: -- End for Bug 7440217
4516: where pll.po_header_id = p_poHeaderID

Line 4513: , mtl_parameters mp,

4509: to shipments due to be received only in the organizationientered with.*/
4510: and exists (select 1
4511: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4512: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4513: , mtl_parameters mp,
4514: rcv_parameters rp
4515: -- End for Bug 7440217
4516: where pll.po_header_id = p_poHeaderID
4517:

Line 4607: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4603: and inventory_item_id = pol.item_id -- bug 4602289
4604: and pol.po_header_id = p_poHeaderID -- bug 4602289
4605: and exists (select 1
4606: from po_line_locations_trx_v pll -- CLM Project, bug 9403291
4607: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4608: , mtl_parameters mp,
4609: rcv_parameters rp
4610: -- End for Bug 7440217
4611: where NVL(pll.closed_code,'OPEN')

Line 4608: , mtl_parameters mp,

4604: and pol.po_header_id = p_poHeaderID -- bug 4602289
4605: and exists (select 1
4606: from po_line_locations_trx_v pll -- CLM Project, bug 9403291
4607: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4608: , mtl_parameters mp,
4609: rcv_parameters rp
4610: -- End for Bug 7440217
4611: where NVL(pll.closed_code,'OPEN')
4612: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 4703: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4699: and pol.item_id = mri.related_item_id
4700: and mri.reciprocal_flag = 'Y'))
4701: and exists (select 1
4702: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4703: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4704: , mtl_parameters mp,
4705: rcv_parameters rp
4706: -- End for Bug 7440217
4707: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 4704: , mtl_parameters mp,

4700: and mri.reciprocal_flag = 'Y'))
4701: and exists (select 1
4702: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4703: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4704: , mtl_parameters mp,
4705: rcv_parameters rp
4706: -- End for Bug 7440217
4707: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')
4708: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 4796: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4792: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
4793: WHERE pl.po_header_id = p_poHeaderID
4794: and exists (select 1
4795: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4796: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4797: , mtl_parameters mp,
4798: rcv_parameters rp
4799: -- End for Bug 7440217
4800: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 4797: , mtl_parameters mp,

4793: WHERE pl.po_header_id = p_poHeaderID
4794: and exists (select 1
4795: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4796: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4797: , mtl_parameters mp,
4798: rcv_parameters rp
4799: -- End for Bug 7440217
4800: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')
4801: and pll.po_header_id = p_poHeaderID

Line 4899: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4895: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
4896: to shipments due to be received only in the organizationientered with.*/
4897: and exists (select 1
4898: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4899: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4900: , mtl_parameters mp,
4901: rcv_parameters rp
4902: -- End for Bug 7440217
4903: where pll.po_header_id = p_poHeaderID

Line 4900: , mtl_parameters mp,

4896: to shipments due to be received only in the organizationientered with.*/
4897: and exists (select 1
4898: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4899: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4900: , mtl_parameters mp,
4901: rcv_parameters rp
4902: -- End for Bug 7440217
4903: where pll.po_header_id = p_poHeaderID
4904: and pll.po_line_id = pol.po_line_id

Line 4991: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

4987: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
4988: WHERE pl.po_header_id = p_poHeaderID
4989: and exists (select 1
4990: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4991: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4992: , mtl_parameters mp,
4993: rcv_parameters rp
4994: -- End for Bug 7440217
4995: where NVL(pll.closed_code,'OPEN')

Line 4992: , mtl_parameters mp,

4988: WHERE pl.po_header_id = p_poHeaderID
4989: and exists (select 1
4990: from po_line_locations_trx_v pll -- CLM project, bug 9403291
4991: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4992: , mtl_parameters mp,
4993: rcv_parameters rp
4994: -- End for Bug 7440217
4995: where NVL(pll.closed_code,'OPEN')
4996: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 5087: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5083: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5084: to shipments due to be received only in the organizationientered with.*/
5085: and exists (select 1
5086: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5087: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5088: , mtl_parameters mp,
5089: rcv_parameters rp
5090: -- End for Bug 7440217
5091: where pll.po_header_id = p_poHeaderID

Line 5088: , mtl_parameters mp,

5084: to shipments due to be received only in the organizationientered with.*/
5085: and exists (select 1
5086: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5087: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5088: , mtl_parameters mp,
5089: rcv_parameters rp
5090: -- End for Bug 7440217
5091: where pll.po_header_id = p_poHeaderID
5092: -- For Bug 7440217 Checking if it is LCM enabled

Line 5177: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5173: and inventory_item_id =pol.item_id --Bug 14645109 s changed from this part
5174: and pol.po_header_id = p_poHeaderID
5175: and exists (select 1
5176: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5177: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5178: , mtl_parameters mp,
5179: rcv_parameters rp
5180: -- End for Bug 7440217
5181: WHERE NVL(pll.closed_code,'OPEN')

Line 5178: , mtl_parameters mp,

5174: and pol.po_header_id = p_poHeaderID
5175: and exists (select 1
5176: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5177: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5178: , mtl_parameters mp,
5179: rcv_parameters rp
5180: -- End for Bug 7440217
5181: WHERE NVL(pll.closed_code,'OPEN')
5182: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 5266: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5262: and pol.item_id = mri.related_item_id
5263: and mri.reciprocal_flag = 'Y'))
5264: and exists (select 1
5265: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5266: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5267: , mtl_parameters mp,
5268: rcv_parameters rp
5269: -- End for Bug 7440217
5270: where NVL(pll.closed_code,'OPEN')

Line 5267: , mtl_parameters mp,

5263: and mri.reciprocal_flag = 'Y'))
5264: and exists (select 1
5265: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5266: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5267: , mtl_parameters mp,
5268: rcv_parameters rp
5269: -- End for Bug 7440217
5270: where NVL(pll.closed_code,'OPEN')
5271: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 5351: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5347: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291
5348: where pol.po_header_id = p_poHeaderID
5349: and exists (select 1
5350: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5351: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5352: , mtl_parameters mp,
5353: rcv_parameters rp
5354: -- End for Bug 7440217
5355: WHERE NVL(pll.closed_code,'OPEN')

Line 5352: , mtl_parameters mp,

5348: where pol.po_header_id = p_poHeaderID
5349: and exists (select 1
5350: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5351: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5352: , mtl_parameters mp,
5353: rcv_parameters rp
5354: -- End for Bug 7440217
5355: WHERE NVL(pll.closed_code,'OPEN')
5356: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 5440: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5436: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5437: to shipments due to be received only in the organizationientered with.*/
5438: and exists (select 1
5439: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5440: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5441: , mtl_parameters mp,
5442: rcv_parameters rp
5443: -- End for Bug 7440217
5444: where pll.po_header_id = p_poHeaderID

Line 5441: , mtl_parameters mp,

5437: to shipments due to be received only in the organizationientered with.*/
5438: and exists (select 1
5439: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5440: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5441: , mtl_parameters mp,
5442: rcv_parameters rp
5443: -- End for Bug 7440217
5444: where pll.po_header_id = p_poHeaderID
5445: and pll.po_line_id = pol.po_line_id

Line 5533: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5529: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291
5530: where pol.po_header_id = p_poHeaderID
5531: and exists (select 1
5532: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5533: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5534: , mtl_parameters mp,
5535: rcv_parameters rp
5536: -- End for Bug 7440217
5537: WHERE NVL(pll.closed_code,'OPEN')

Line 5534: , mtl_parameters mp,

5530: where pol.po_header_id = p_poHeaderID
5531: and exists (select 1
5532: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5533: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5534: , mtl_parameters mp,
5535: rcv_parameters rp
5536: -- End for Bug 7440217
5537: WHERE NVL(pll.closed_code,'OPEN')
5538: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 5623: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5619: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5620: to shipments due to be received only in the organizationientered with.*/
5621: and exists (select 1
5622: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5623: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5624: , mtl_parameters mp,
5625: rcv_parameters rp
5626: -- End for Bug 7440217
5627: where pll.po_header_id = p_poHeaderID

Line 5624: , mtl_parameters mp,

5620: to shipments due to be received only in the organizationientered with.*/
5621: and exists (select 1
5622: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5623: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5624: , mtl_parameters mp,
5625: rcv_parameters rp
5626: -- End for Bug 7440217
5627: where pll.po_header_id = p_poHeaderID
5628: -- For Bug 7440217 Checking if it is LCM enabled

Line 5708: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5704: and pl.po_header_id = p_poHeaderID
5705: and pl.po_line_id = p_poLineID
5706: and exists (select 1
5707: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5708: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5709: , mtl_parameters mp,
5710: rcv_parameters rp
5711: -- End for Bug 7440217
5712: where NVL(pll.closed_code, 'OPEN')

Line 5709: , mtl_parameters mp,

5705: and pl.po_line_id = p_poLineID
5706: and exists (select 1
5707: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5708: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5709: , mtl_parameters mp,
5710: rcv_parameters rp
5711: -- End for Bug 7440217
5712: where NVL(pll.closed_code, 'OPEN')
5713: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 5797: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5793: and mri.reciprocal_flag = 'Y'))
5794: and pol.po_line_id = p_poLineID
5795: and exists (select 1
5796: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5797: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5798: , mtl_parameters mp,
5799: rcv_parameters rp
5800: -- End for Bug 7440217
5801: where NVL(pll.closed_code,'OPEN')

Line 5798: , mtl_parameters mp,

5794: and pol.po_line_id = p_poLineID
5795: and exists (select 1
5796: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5797: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5798: , mtl_parameters mp,
5799: rcv_parameters rp
5800: -- End for Bug 7440217
5801: where NVL(pll.closed_code,'OPEN')
5802: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 5881: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5877: WHERE pl.po_header_id = p_poHeaderID
5878: and pl.po_line_id = p_poLineID
5879: and exists (select 1
5880: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5881: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5882: , mtl_parameters mp,
5883: rcv_parameters rp
5884: -- End for Bug 7440217
5885: where NVL(pll.closed_code, 'OPEN')

Line 5882: , mtl_parameters mp,

5878: and pl.po_line_id = p_poLineID
5879: and exists (select 1
5880: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5881: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5882: , mtl_parameters mp,
5883: rcv_parameters rp
5884: -- End for Bug 7440217
5885: where NVL(pll.closed_code, 'OPEN')
5886: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 5969: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

5965: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5966: to shipments due to be received only in the organizationientered with.*/
5967: and exists (select 1
5968: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5969: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5970: , mtl_parameters mp,
5971: rcv_parameters rp
5972: -- End for Bug 7440217
5973: where pll.po_header_id = p_poHeaderID

Line 5970: , mtl_parameters mp,

5966: to shipments due to be received only in the organizationientered with.*/
5967: and exists (select 1
5968: from po_line_locations_trx_v pll -- CLM project, bug 9403291
5969: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5970: , mtl_parameters mp,
5971: rcv_parameters rp
5972: -- End for Bug 7440217
5973: where pll.po_header_id = p_poHeaderID
5974: -- For Bug 7440217 Checking if it is LCM enabled

Line 6060: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6056: WHERE pl.po_header_id = p_poHeaderID
6057: and pl.po_line_id = p_poLineID
6058: and exists (select 1
6059: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6060: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6061: , mtl_parameters mp,
6062: rcv_parameters rp
6063: -- End for Bug 7440217
6064: where NVL(pll.closed_code, 'OPEN')

Line 6061: , mtl_parameters mp,

6057: and pl.po_line_id = p_poLineID
6058: and exists (select 1
6059: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6060: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6061: , mtl_parameters mp,
6062: rcv_parameters rp
6063: -- End for Bug 7440217
6064: where NVL(pll.closed_code, 'OPEN')
6065: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 6149: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6145: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
6146: to shipments due to be received only in the organizationientered with.*/
6147: and exists (select 1
6148: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6149: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6150: , mtl_parameters mp,
6151: rcv_parameters rp
6152: -- End for Bug 7440217
6153: where pll.po_header_id = p_poHeaderID

Line 6150: , mtl_parameters mp,

6146: to shipments due to be received only in the organizationientered with.*/
6147: and exists (select 1
6148: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6149: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6150: , mtl_parameters mp,
6151: rcv_parameters rp
6152: -- End for Bug 7440217
6153: where pll.po_header_id = p_poHeaderID
6154: -- For Bug 7440217 Checking if it is LCM enabled

Line 6232: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6228: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
6229: WHERE pl.po_header_id = p_poHeaderID
6230: and exists (select 1
6231: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6232: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6233: , mtl_parameters mp,
6234: rcv_parameters rp
6235: -- End for Bug 7440217
6236: where NVL(pll.closed_code,'OPEN')

Line 6233: , mtl_parameters mp,

6229: WHERE pl.po_header_id = p_poHeaderID
6230: and exists (select 1
6231: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6232: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6233: , mtl_parameters mp,
6234: rcv_parameters rp
6235: -- End for Bug 7440217
6236: where NVL(pll.closed_code,'OPEN')
6237: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 6319: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6315: and pol.item_id = mri.related_item_id
6316: and mri.reciprocal_flag = 'Y'))
6317: and exists (select 1
6318: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6319: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6320: , mtl_parameters mp,
6321: rcv_parameters rp
6322: -- End for Bug 7440217
6323: where NVL(pll.closed_code,'OPEN')

Line 6320: , mtl_parameters mp,

6316: and mri.reciprocal_flag = 'Y'))
6317: and exists (select 1
6318: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6319: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6320: , mtl_parameters mp,
6321: rcv_parameters rp
6322: -- End for Bug 7440217
6323: where NVL(pll.closed_code,'OPEN')
6324: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 6403: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6399: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
6400: WHERE pl.po_header_id = p_poHeaderID
6401: and exists (select 1
6402: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6403: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6404: , mtl_parameters mp,
6405: rcv_parameters rp
6406: -- End for Bug 7440217
6407: where NVL(pll.closed_code,'OPEN')

Line 6404: , mtl_parameters mp,

6400: WHERE pl.po_header_id = p_poHeaderID
6401: and exists (select 1
6402: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6403: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6404: , mtl_parameters mp,
6405: rcv_parameters rp
6406: -- End for Bug 7440217
6407: where NVL(pll.closed_code,'OPEN')
6408: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 6490: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6486: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
6487: to shipments due to be received only in the organizationientered with.*/
6488: and exists (select 1
6489: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6490: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6491: , mtl_parameters mp,
6492: rcv_parameters rp
6493: -- End for Bug 7440217
6494: where pll.po_header_id = p_poHeaderID

Line 6491: , mtl_parameters mp,

6487: to shipments due to be received only in the organizationientered with.*/
6488: and exists (select 1
6489: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6490: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6491: , mtl_parameters mp,
6492: rcv_parameters rp
6493: -- End for Bug 7440217
6494: where pll.po_header_id = p_poHeaderID
6495: -- For Bug 7440217 Checking if it is LCM enabled

Line 6581: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6577: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
6578: WHERE pl.po_header_id = p_poHeaderID
6579: and exists (select 1
6580: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6581: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6582: , mtl_parameters mp,
6583: rcv_parameters rp
6584: -- End for Bug 7440217
6585: where NVL(pll.closed_code,'OPEN')

Line 6582: , mtl_parameters mp,

6578: WHERE pl.po_header_id = p_poHeaderID
6579: and exists (select 1
6580: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6581: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6582: , mtl_parameters mp,
6583: rcv_parameters rp
6584: -- End for Bug 7440217
6585: where NVL(pll.closed_code,'OPEN')
6586: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

Line 6669: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6665: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
6666: to shipments due to be received only in the organizationientered with.*/
6667: and exists (select 1
6668: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6669: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6670: , mtl_parameters mp,
6671: rcv_parameters rp
6672: -- End for Bug 7440217
6673: where pll.po_header_id = p_poHeaderID

Line 6670: , mtl_parameters mp,

6666: to shipments due to be received only in the organizationientered with.*/
6667: and exists (select 1
6668: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6669: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6670: , mtl_parameters mp,
6671: rcv_parameters rp
6672: -- End for Bug 7440217
6673: where pll.po_header_id = p_poHeaderID
6674: -- For Bug 7440217 Checking if it is LCM enabled

Line 6851: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6847: WHERE pl.po_header_id = rsl.po_header_id
6848: and pl.po_line_id = rsl.po_line_id
6849: and exists (select 1
6850: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6851: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6852: , mtl_parameters mp,
6853: rcv_parameters rp
6854: -- End for Bug 7440217
6855: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 6852: , mtl_parameters mp,

6848: and pl.po_line_id = rsl.po_line_id
6849: and exists (select 1
6850: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6851: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6852: , mtl_parameters mp,
6853: rcv_parameters rp
6854: -- End for Bug 7440217
6855: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249
6856: -- For Bug 7440217 Checking if it is LCM enabled

Line 6953: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

6949: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
6950: to shipments due to be received only in the organizationientered with.*/
6951: and exists (select 1
6952: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6953: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6954: , mtl_parameters mp,
6955: rcv_parameters rp
6956: -- End for Bug 7440217
6957: where pll.po_header_id = rsl.po_header_id --Bug 13490287

Line 6954: , mtl_parameters mp,

6950: to shipments due to be received only in the organizationientered with.*/
6951: and exists (select 1
6952: from po_line_locations_trx_v pll -- CLM project, bug 9403291
6953: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6954: , mtl_parameters mp,
6955: rcv_parameters rp
6956: -- End for Bug 7440217
6957: where pll.po_header_id = rsl.po_header_id --Bug 13490287
6958: -- For Bug 7440217 Checking if it is LCM enabled

Line 7188: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

7184: WHERE pl.po_header_id = rsl.po_header_id
7185: and pl.po_line_id = rsl.po_line_id
7186: and exists (select 1
7187: from po_line_locations_trx_v pll -- CLM project, bug 9403291
7188: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7189: , mtl_parameters mp,
7190: rcv_parameters rp
7191: -- End for Bug 7440217
7192: where NVL(pll.closed_code,'OPEN')

Line 7189: , mtl_parameters mp,

7185: and pl.po_line_id = rsl.po_line_id
7186: and exists (select 1
7187: from po_line_locations_trx_v pll -- CLM project, bug 9403291
7188: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7189: , mtl_parameters mp,
7190: rcv_parameters rp
7191: -- End for Bug 7440217
7192: where NVL(pll.closed_code,'OPEN')
7193: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

Line 7291: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

7287: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
7288: to shipments due to be received only in the organizationientered with.*/
7289: and exists (select 1
7290: from po_line_locations_trx_v pll -- CLM project, bug 9403291
7291: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7292: , mtl_parameters mp,
7293: rcv_parameters rp
7294: -- End for Bug 7440217
7295: where pll.po_header_id = rsl.po_header_id --Bug 13490287

Line 7292: , mtl_parameters mp,

7288: to shipments due to be received only in the organizationientered with.*/
7289: and exists (select 1
7290: from po_line_locations_trx_v pll -- CLM project, bug 9403291
7291: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7292: , mtl_parameters mp,
7293: rcv_parameters rp
7294: -- End for Bug 7440217
7295: where pll.po_header_id = rsl.po_header_id --Bug 13490287
7296: -- For Bug 7440217 Checking if it is LCM enabled

Line 7965: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

7961: AND EXISTS (SELECT '1'
7962: FROM po_lines_trx_v pol, -- CLM project, bug 9403291
7963: mtl_related_items mri,
7964: po_line_locations_trx_v pll -- CLM project, bug 9403291
7965: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7966: , mtl_parameters mp,
7967: rcv_parameters rp
7968: -- End for Bug 7440217
7969: WHERE NVL(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED')

Line 7966: , mtl_parameters mp,

7962: FROM po_lines_trx_v pol, -- CLM project, bug 9403291
7963: mtl_related_items mri,
7964: po_line_locations_trx_v pll -- CLM project, bug 9403291
7965: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7966: , mtl_parameters mp,
7967: rcv_parameters rp
7968: -- End for Bug 7440217
7969: WHERE NVL(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED')
7970: AND NVL(pll.allow_substitute_receipts_flag, 'N') = 'Y'

Line 8053: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

8049: AND pol.item_id = msi.inventory_item_id
8050: AND pol.vendor_product_num IS NOT NULL
8051: AND EXISTS (SELECT '1'
8052: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291
8053: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
8054: , mtl_parameters mp,
8055: rcv_parameters rp
8056: -- End for Bug 7440217
8057: WHERE pll.po_line_id = pol.po_line_id

Line 8054: , mtl_parameters mp,

8050: AND pol.vendor_product_num IS NOT NULL
8051: AND EXISTS (SELECT '1'
8052: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291
8053: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
8054: , mtl_parameters mp,
8055: rcv_parameters rp
8056: -- End for Bug 7440217
8057: WHERE pll.po_line_id = pol.po_line_id
8058: AND pll.ship_to_organization_id = msi.organization_id

Line 8205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

8201: AND pol.item_description IS NOT NULL
8202: AND pol.item_description LIKE p_concatenated_segments
8203: AND EXISTS (SELECT '1'
8204: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291
8205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
8206: , mtl_parameters mp,
8207: rcv_parameters rp
8208: -- End for Bug 7440217
8209: WHERE pll.po_line_id = pol.po_line_id

Line 8206: , mtl_parameters mp,

8202: AND pol.item_description LIKE p_concatenated_segments
8203: AND EXISTS (SELECT '1'
8204: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291
8205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
8206: , mtl_parameters mp,
8207: rcv_parameters rp
8208: -- End for Bug 7440217
8209: WHERE pll.po_line_id = pol.po_line_id
8210: AND pll.ship_to_organization_id = p_organization_id