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 PO_LINE_LOCATIONS_TRX_V

Line 180: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

176: , poh.note_to_receiver
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

Line 224: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

220: , to_char(poh.org_id) --
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

Line 274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291

270: FROM RCV_SUPPLY RSUP,
271: RCV_TRANSACTIONS RT,
272: PO_LOOKUP_CODES PLC,
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

Line 448: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

444: where pl.item_id = msi.inventory_item_id (+)
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

Line 1566: po_line_locations_trx_v poll -- CLM project, bug 9403291

1562: (
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

Line 1632: po_line_locations_trx_v poll -- CLM project, bug 9403291

1628: 'Valid PO Shipments'
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

Line 1706: po_line_locations_trx_v poll -- CLM project, bug 9403291

1702: to_char(poh.org_id) FIELD15 --
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

Line 1767: po_line_locations_trx_v poll -- CLM project, bug 9403291

1763: fnd_lookup_values_vl flv ,
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

Line 1830: po_line_locations_trx_v poll -- CLM project, bug 9403291

1826: fnd_lookup_values_vl flv ,
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

Line 1910: po_line_locations_trx_v poll -- CLM project, bug 9403291

1906: (
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

Line 1977: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

1973: AND EXISTS
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

Line 2466: po_line_locations_trx_v poll --CLM project, bug 9403291

2462: (
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

Line 2533: po_line_locations_trx_v poll -- CLM project, bug 9403291

2529: 'Valid PO Shipments'
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

Line 2613: po_line_locations_trx_v poll -- CLM project, bug 9403291

2609: (
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

Line 2985: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

2981: -- and msi.organization_id = p_organization_id -- Bug 6437363
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

Line 3031: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291

3027: and msi.inventory_item_id = p_inventory_item_id -- Bug 6311550
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

Line 3438: from po_line_locations_trx_v pll -- CLM project, bug 9403291

3434: and inventory_item_id = pol.item_id -- Bug 14645109 s change this
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

Line 3535: from po_line_locations_trx_v pll -- CLM project, bug 9403291

3531: ( mri.inventory_item_id = msi.inventory_item_id
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

Line 3628: from po_line_locations_trx_v pll -- CLM project, bug 9403291

3624: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 3733: from po_line_locations_trx_v pll -- CLM project, bug 9403291

3729: )
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

Line 3825: from po_line_locations_trx_v pll --CLM project, bug 9403291

3821: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 3931: from po_line_locations_trx_v pll -- CLM project, bug 9403291

3927: )
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

Line 4018: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4014:
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

Line 4115: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4111: and pol.item_id = mri.related_item_id
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

Line 4208: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4204: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
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

Line 4312: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4308: )
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

Line 4404: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4400: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
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

Line 4511: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4507: )
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

Line 4606: from po_line_locations_trx_v pll -- CLM Project, bug 9403291

4602: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 4702: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4698: ( mri.inventory_item_id = msi.inventory_item_id
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

Line 4795: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4791: and inventory_item_id IN
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

Line 4898: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4894: )
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

Line 4990: from po_line_locations_trx_v pll -- CLM project, bug 9403291

4986: and msi.inventory_item_id IN
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

Line 5086: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5082: and pol.vendor_product_num like p_concatenated_segments
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

Line 5176: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5172: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 5265: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5261: ( mri.inventory_item_id = msi.inventory_item_id
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

Line 5350: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5346: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 5439: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5435: and pol.item_description like p_concatenated_segments
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

Line 5532: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5528: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 5622: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5618: and pol.vendor_product_num like p_concatenated_segments
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

Line 5707: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5703: and inventory_item_id = pl.item_id -- Bug 14624321 changed this part
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

Line 5796: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5792: and pol.item_id = mri.related_item_id
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

Line 5880: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5876: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
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

Line 5968: from po_line_locations_trx_v pll -- CLM project, bug 9403291

5964: and pol.po_line_id = p_poLineID
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

Line 6059: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6055: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291
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

Line 6148: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6144: and pol.po_line_id = p_poLineID
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

Line 6231: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6227: and inventory_item_id IN
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

Line 6318: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6314: ( mri.inventory_item_id = msi.inventory_item_id
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

Line 6402: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6398: and inventory_item_id IN
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

Line 6489: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6485: and pol.item_description like p_concatenated_segments
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

Line 6580: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6576: and msi.inventory_item_id IN
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

Line 6668: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6664: and pol.vendor_product_num like p_concatenated_segments
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

Line 6850: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6846: FROM po_lines_trx_v pl
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

Line 6952: from po_line_locations_trx_v pll -- CLM project, bug 9403291

6948: and rsl.source_document_code = 'PO'
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

Line 7187: from po_line_locations_trx_v pll -- CLM project, bug 9403291

7183: FROM po_lines_trx_v pl
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

Line 7290: from po_line_locations_trx_v pll -- CLM project, bug 9403291

7286: AND rsl.source_document_code = 'PO'
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

Line 7964: po_line_locations_trx_v pll -- CLM project, bug 9403291

7960: AND (msi.purchasing_enabled_flag = 'Y' OR msi.stock_enabled_flag = 'Y')
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

Line 8052: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291

8048: AND pol.vendor_product_num like p_concatenated_segments
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

Line 8204: FROM po_line_locations_trx_v pll -- CLM project, bug 9403291

8200: AND pol.ITEM_ID is NULL
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