[Home] [Help]
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'
187: AND Nvl(poll.cancel_flag,'N') = 'N'
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'
231: AND Nvl(poll.cancel_flag,'N') = 'N'
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'
282: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
283: AND RT.TRANSACTION_TYPE = PLC.LOOKUP_CODE
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
358: AND Nvl(poll.approved_flag,'N') = 'Y'
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
455: AND Nvl(poll.approved_flag,'N') = 'Y'
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'
730: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
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
1573: AND Nvl(pl.vendor_product_num,' ') = Nvl(p_vendor_prod_num, Nvl(pl.vendor_product_num,' '))
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
1639: AND
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'
1713: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
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'
1774: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
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'
1837: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
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||'%'
1917: AND pl.po_header_id = poh.po_header_id
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'
1984: AND Nvl(poll.cancel_flag,'N') = 'N'
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,' '))
2473: AND Nvl(pl.item_id,-999) LIKE Nvl(p_inventory_item_id,'%')
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
2540: (
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||'%'
2620: AND pl.po_header_id = poh.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
2992: AND Nvl(poll.approved_flag,'N') = 'Y'
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
3038: AND Nvl(poll.approved_flag,'N') = 'Y'
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'
3255: and nvl(pr.approved_flag, 'N') <> 'N'
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')
3445: and pll.po_header_id = p_poHeaderID
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')
3542: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'
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')
3635: and pll.po_header_id = p_poHeaderID
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
3740: and pll.po_release_id = p_poReleaseID
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')
3832: and pll.po_header_id = p_poHeaderID
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
3938: AND mp.organization_id = p_organization_id
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' )
4025: and pll.po_header_id = p_poHeaderID
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
4122: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'
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
4215: and pll.po_header_id = p_poHeaderID
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
4319: and pll.ship_to_organization_id = p_Organization_Id
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
4411: and pll.po_header_id = p_poHeaderID
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:
4518:
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')
4613: and pll.po_header_id = p_poHeaderID
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'
4709: and pll.po_header_id = pol.po_header_id
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
4802: and pll.po_line_id = pl.po_line_id
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
4905: and pll.ship_to_organization_id = p_Organization_Id
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
4997: and pll.po_header_id = p_poHeaderID and pll.po_line_id = pl.po_line_id
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
5093: AND mp.organization_id = p_organization_id
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')
5183: and pll.po_header_id = p_poHeaderID
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
5272: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'
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')
5357: and pll.po_header_id = p_poHeaderID
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
5446: and pll.ship_to_organization_id = p_Organization_Id
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')
5539: and pll.po_header_id = p_poHeaderID
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
5629: AND mp.organization_id = p_organization_id
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
5714: and pll.po_header_id = p_poHeaderID
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
5803: -- For Bug 7440217 Checking if it is LCM enabled
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
5887: -- For Bug 7440217 Checking if it is LCM enabled
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
5975: AND mp.organization_id = p_organization_id
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
6066: -- For Bug 7440217 Checking if it is LCM enabled
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
6155: AND mp.organization_id = p_organization_id
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
6238: -- For Bug 7440217 Checking if it is LCM enabled
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
6325: -- For Bug 7440217 Checking if it is LCM enabled
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
6409: -- For Bug 7440217 Checking if it is LCM enabled
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
6496: AND mp.organization_id = p_organization_id
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
6587: -- For Bug 7440217 Checking if it is LCM enabled
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
6675: AND mp.organization_id = p_organization_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
6857: AND mp.organization_id = p_organization_id
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
6959: AND mp.organization_id = p_organization_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
7194: -- For Bug 7440217 Checking if it is LCM enabled
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
7297: AND mp.organization_id = p_organization_id
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'
7971: AND pll.po_line_id = pol.po_line_id
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
8059: AND NVL(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED')
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
8211: -- For Bug 7440217 Checking if it is LCM enabled