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_ALL

Line 161: FROM po_line_locations_all poll

157: , poh.note_to_receiver
158: , to_char(poh.org_id) --
159: FROM po_headers poh
160: WHERE exists (SELECT 'Valid PO Shipments'
161: FROM po_line_locations_all poll
162: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
163: , mtl_parameters mp,
164: rcv_parameters rp
165: -- End for Bug 7440217

Line 253: PO_LINE_LOCATIONS_ALL PLL,

249: FROM RCV_SUPPLY RSUP,
250: RCV_TRANSACTIONS RT,
251: PO_LOOKUP_CODES PLC,
252: PO_LINES_ALL pol,
253: PO_LINE_LOCATIONS_ALL PLL,
254: PO_HEADERS_ALL POH,
255: po_line_types plt,--BUG 5166887
256: mtl_parameters mp --BUG 5166887
257: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not

Line 330: FROM po_line_locations_all poll

326: and nvl(pr.cancel_flag, 'N') = 'N'
327: and nvl(pr.approved_flag, 'N') <> 'N'
328: and nvl(pr.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249
329: AND exists (SELECT 'Valid PO Shipments' --Added the exists to fix bug4350175
330: FROM po_line_locations_all poll
331: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
332: , mtl_parameters mp,
333: rcv_parameters rp
334: -- End for Bug 7440217

Line 420: FROM po_line_locations_all poll

416: where pl.item_id = msi.inventory_item_id (+)
417: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
418: and pl.po_header_id = p_po_header_id
419: and exists (SELECT 'Valid PO Shipments'
420: FROM po_line_locations_all poll
421: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
422: , mtl_parameters mp,
423: rcv_parameters rp
424: -- End for Bug 7440217

Line 694: PO_LINE_LOCATIONS_ALL PLL,

690: RCV_SHIPMENT_LINES RSL,
691: RCV_TRANSACTIONS RT,
692: RCV_SHIPMENT_HEADERS RSH,
693: PO_LOOKUP_CODES PLC,
694: PO_LINE_LOCATIONS_ALL PLL,
695: HR_ALL_ORGANIZATION_UNITS_TL OOD
696: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
697: , mtl_parameters mp,
698: rcv_parameters rp

Line 1085: PO_LINE_LOCATIONS_ALL PLL,

1081: RCV_TRANSACTIONS RT,
1082: RCV_SHIPMENT_HEADERS RSH,
1083: RCV_SHIPMENT_LINES RSL,
1084: PO_LOOKUP_CODES PLC,
1085: PO_LINE_LOCATIONS_ALL PLL,
1086: mtl_parameters mp --BUG 5166887
1087: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'
1088: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1089: AND RT.TRANSACTION_TYPE = PLC.LOOKUP_CODE

Line 1531: po_line_locations_all poll

1527: (
1528: SELECT
1529: 'Valid PO Shipments'
1530: FROM po_lines_all pl,
1531: po_line_locations_all poll
1532: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1533: , mtl_parameters mp,
1534: rcv_parameters rp
1535: -- End for Bug 7440217

Line 1596: po_line_locations_all poll

1592: 'Valid PO Shipments'
1593: FROM po_lines_all pl ,
1594: mtl_related_items mri ,
1595: mtl_system_items_kfv msi ,
1596: po_line_locations_all poll
1597: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1598: , mtl_parameters mp,
1599: rcv_parameters rp
1600: -- End for Bug 7440217

Line 1669: po_line_locations_all poll

1665: to_char(poh.org_id) FIELD14 --
1666: FROM po_headers poh,
1667: fnd_lookup_values_vl flv ,
1668: po_lines_all pl,
1669: po_line_locations_all poll
1670: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1671: , mtl_parameters mp,
1672: rcv_parameters rp
1673: -- End for Bug 7440217

Line 1729: po_line_locations_all poll

1725: fnd_lookup_values_vl flv ,
1726: po_lines_all pl ,
1727: mtl_related_items mri ,
1728: mtl_system_items_kfv msi ,
1729: po_line_locations_all poll
1730: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1731: , mtl_parameters mp,
1732: rcv_parameters rp
1733: -- End for Bug 7440217

Line 1791: po_line_locations_all poll

1787: fnd_lookup_values_vl flv ,
1788: po_lines_all pl ,
1789: mtl_related_items mri ,
1790: mtl_system_items_kfv msi ,
1791: po_line_locations_all poll
1792: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1793: , mtl_parameters mp,
1794: rcv_parameters rp
1795: -- End for Bug 7440217

Line 1870: po_line_locations_all poll

1866: (
1867: SELECT
1868: 'Valid PO Shipments'
1869: FROM po_lines_all pl ,
1870: po_line_locations_all poll
1871: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1872: , mtl_parameters mp,
1873: rcv_parameters rp
1874: -- End for Bug 7440217

Line 1936: FROM po_line_locations_all poll

1932: AND EXISTS
1933: (
1934: SELECT
1935: 'Valid PO Shipments'
1936: FROM po_line_locations_all poll
1937: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1938: , mtl_parameters mp,
1939: rcv_parameters rp
1940: -- End for Bug 7440217

Line 2415: po_line_locations_all poll

2411: (
2412: SELECT
2413: 'Valid PO Shipments'
2414: FROM po_lines_all pl ,
2415: po_line_locations_all poll
2416: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2417: , mtl_parameters mp,
2418: rcv_parameters rp
2419: -- End for Bug 7440217

Line 2481: po_line_locations_all poll

2477: 'Valid PO Shipments'
2478: FROM po_lines_all pl ,
2479: mtl_related_items mri ,
2480: mtl_system_items_kfv msi ,
2481: po_line_locations_all poll
2482: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2483: , mtl_parameters mp,
2484: rcv_parameters rp
2485: -- End for Bug 7440217

Line 2560: po_line_locations_all poll

2556: (
2557: SELECT
2558: 'Valid PO Shipments'
2559: FROM po_lines_all pl ,
2560: po_line_locations_all poll
2561: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2562: , mtl_parameters mp,
2563: rcv_parameters rp
2564: -- End for Bug 7440217

Line 2911: FROM po_line_locations_all poll

2907: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
2908: and msi.organization_id = p_organization_id -- Bug 6437363
2909: and pl.po_header_id = p_po_header_id
2910: and exists (SELECT 'Valid PO Shipments'
2911: FROM po_line_locations_all poll
2912: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2913: , mtl_parameters mp,
2914: rcv_parameters rp
2915: -- End for Bug 7440217

Line 2956: FROM po_line_locations_all poll

2952: and msi.inventory_item_id = p_inventory_item_id -- Bug 6311550
2953: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
2954: and pl.po_header_id = p_po_header_id
2955: and exists (SELECT 'Valid PO Shipments'
2956: FROM po_line_locations_all poll
2957: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
2958: , mtl_parameters mp,
2959: rcv_parameters rp
2960: -- End for Bug 7440217

Line 3131: , po_line_locations_all pll

3127: select distinct pr.release_num
3128: , pr.po_release_id
3129: , pr.release_date
3130: from po_releases_all pr
3131: , po_line_locations_all pll
3132: , po_lines_all pl
3133: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3134: , mtl_parameters mp
3135: , rcv_parameters rp

Line 3297: from po_line_locations_all pll

3293: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3294: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
3295: where pol.po_header_id = p_poHeaderID
3296: and exists (select 1
3297: from po_line_locations_all pll
3298: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3299: , mtl_parameters mp,
3300: rcv_parameters rp
3301: -- End for Bug 7440217

Line 3390: from po_line_locations_all pll

3386: ( mri.inventory_item_id = msi.inventory_item_id
3387: and pol.item_id = mri.related_item_id
3388: and mri.reciprocal_flag = 'Y'))
3389: and exists (select 1
3390: from po_line_locations_all pll
3391: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3392: , mtl_parameters mp,
3393: rcv_parameters rp
3394: -- End for Bug 7440217

Line 3479: from po_line_locations_all pll

3475: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3476: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
3477: where pol.po_header_id = p_poHeaderID
3478: and exists (select 1
3479: from po_line_locations_all pll
3480: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3481: , mtl_parameters mp,
3482: rcv_parameters rp
3483: -- End for Bug 7440217

Line 3579: from po_line_locations_all pll

3575: )
3576: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
3577: to shipments due to be received only in the organizationientered with.*/
3578: and exists (select 1
3579: from po_line_locations_all pll
3580: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3581: , mtl_parameters mp,
3582: rcv_parameters rp
3583: -- End for Bug 7440217

Line 3667: from po_line_locations_all pll

3663: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3664: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
3665: where pol.po_header_id = p_poHeaderID
3666: and exists (select 1
3667: from po_line_locations_all pll
3668: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3669: , mtl_parameters mp,
3670: rcv_parameters rp
3671: -- End for Bug 7440217

Line 3758: from po_line_locations_all pll

3754: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol WHERE
3755: pol.po_header_id = p_poHeaderID
3756: and pol.po_line_id = p_poLineID
3757: and exists (select 1
3758: from po_line_locations_all pll
3759: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3760: , mtl_parameters mp,
3761: rcv_parameters rp
3762: -- End for Bug 7440217

Line 3852: from po_line_locations_all pll

3848: and pol.item_id = mri.related_item_id
3849: and mri.reciprocal_flag = 'Y'))
3850: and pol.po_line_id = p_poLineID
3851: and exists (select 1
3852: from po_line_locations_all pll
3853: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3854: , mtl_parameters mp,
3855: rcv_parameters rp
3856: -- End for Bug 7440217

Line 3942: from po_line_locations_all pll

3938: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
3939: pl.po_header_id = p_poHeaderID
3940: and pl.po_line_id = p_poLineID
3941: and exists (select 1
3942: from po_line_locations_all pll
3943: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
3944: , mtl_parameters mp,
3945: rcv_parameters rp
3946: -- End for Bug 7440217

Line 4043: from po_line_locations_all pll

4039: )
4040: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
4041: to shipments due to be received only in the organization entered with.*/
4042: and exists (select 1
4043: from po_line_locations_all pll
4044: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4045: , mtl_parameters mp,
4046: rcv_parameters rp
4047: -- End for Bug 7440217

Line 4132: from po_line_locations_all pll

4128: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
4129: pl.po_header_id = p_poHeaderID
4130: and pl.po_line_id = p_poLineID
4131: and exists (select 1
4132: from po_line_locations_all pll
4133: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4134: , mtl_parameters mp,
4135: rcv_parameters rp
4136: -- End for Bug 7440217

Line 4230: from po_line_locations_all pll

4226: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
4227: and inventory_item_id = pol.item_id -- bug 4602289
4228: and pol.po_header_id = p_poHeaderID -- bug 4602289
4229: and exists (select 1
4230: from po_line_locations_all pll
4231: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4232: , mtl_parameters mp,
4233: rcv_parameters rp
4234: -- End for Bug 7440217

Line 4323: from po_line_locations_all pll

4319: ( mri.inventory_item_id = msi.inventory_item_id
4320: and pol.item_id = mri.related_item_id
4321: and mri.reciprocal_flag = 'Y'))
4322: and exists (select 1
4323: from po_line_locations_all pll
4324: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4325: , mtl_parameters mp,
4326: rcv_parameters rp
4327: -- End for Bug 7440217

Line 4413: from po_line_locations_all pll

4409: and inventory_item_id IN
4410: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
4411: p_poHeaderID
4412: and exists (select 1
4413: from po_line_locations_all pll
4414: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4415: , mtl_parameters mp,
4416: rcv_parameters rp
4417: -- End for Bug 7440217

Line 4513: from po_line_locations_all pll

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

Line 4602: from po_line_locations_all pll

4598: and msi.inventory_item_id IN
4599: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
4600: p_poHeaderID
4601: and exists (select 1
4602: from po_line_locations_all pll
4603: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4604: , mtl_parameters mp,
4605: rcv_parameters rp
4606: -- End for Bug 7440217

Line 4698: from po_line_locations_all pll

4694: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
4695: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
4696: where pol.po_header_id = p_poHeaderID
4697: and exists (select 1
4698: from po_line_locations_all pll
4699: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4700: , mtl_parameters mp,
4701: rcv_parameters rp
4702: -- End for Bug 7440217

Line 4784: from po_line_locations_all pll

4780: ( mri.inventory_item_id = msi.inventory_item_id
4781: and pol.item_id = mri.related_item_id
4782: and mri.reciprocal_flag = 'Y'))
4783: and exists (select 1
4784: from po_line_locations_all pll
4785: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4786: , mtl_parameters mp,
4787: rcv_parameters rp
4788: -- End for Bug 7440217

Line 4866: from po_line_locations_all pll

4862: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
4863: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
4864: where pol.po_header_id = p_poHeaderID
4865: and exists (select 1
4866: from po_line_locations_all pll
4867: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4868: , mtl_parameters mp,
4869: rcv_parameters rp
4870: -- End for Bug 7440217

Line 4952: from po_line_locations_all pll

4948: and pol.item_description like p_concatenated_segments
4949: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
4950: to shipments due to be received only in the organizationientered with.*/
4951: and exists (select 1
4952: from po_line_locations_all pll
4953: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
4954: , mtl_parameters mp,
4955: rcv_parameters rp
4956: -- End for Bug 7440217

Line 5041: from po_line_locations_all pll

5037: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
5038: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol
5039: where pol.po_header_id = p_poHeaderID
5040: and exists (select 1
5041: from po_line_locations_all pll
5042: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5043: , mtl_parameters mp,
5044: rcv_parameters rp
5045: -- End for Bug 7440217

Line 5124: from po_line_locations_all pll

5120: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
5121: pl.po_header_id = p_poHeaderID
5122: and pl.po_line_id = p_poLineID
5123: and exists (select 1
5124: from po_line_locations_all pll
5125: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5126: , mtl_parameters mp,
5127: rcv_parameters rp
5128: -- End for Bug 7440217

Line 5209: from po_line_locations_all pll

5205: and pol.item_id = mri.related_item_id
5206: and mri.reciprocal_flag = 'Y'))
5207: and pol.po_line_id = p_poLineID
5208: and exists (select 1
5209: from po_line_locations_all pll
5210: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5211: , mtl_parameters mp,
5212: rcv_parameters rp
5213: -- End for Bug 7440217

Line 5290: from po_line_locations_all pll

5286: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
5287: pl.po_header_id = p_poHeaderID
5288: and pl.po_line_id = p_poLineID
5289: and exists (select 1
5290: from po_line_locations_all pll
5291: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5292: , mtl_parameters mp,
5293: rcv_parameters rp
5294: -- End for Bug 7440217

Line 5374: from po_line_locations_all pll

5370: and pol.item_description like p_concatenated_segments
5371: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5372: to shipments due to be received only in the organizationientered with.*/
5373: and exists (select 1
5374: from po_line_locations_all pll
5375: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5376: , mtl_parameters mp,
5377: rcv_parameters rp
5378: -- End for Bug 7440217

Line 5462: from po_line_locations_all pll

5458: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE
5459: pl.po_header_id = p_poHeaderID
5460: and pl.po_line_id = p_poLineID
5461: and exists (select 1
5462: from po_line_locations_all pll
5463: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5464: , mtl_parameters mp,
5465: rcv_parameters rp
5466: -- End for Bug 7440217

Line 5543: from po_line_locations_all pll

5539: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
5540: and inventory_item_id IN
5541: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID
5542: and exists (select 1
5543: from po_line_locations_all pll
5544: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5545: , mtl_parameters mp,
5546: rcv_parameters rp
5547: -- End for Bug 7440217

Line 5627: from po_line_locations_all pll

5623: ( mri.inventory_item_id = msi.inventory_item_id
5624: and pol.item_id = mri.related_item_id
5625: and mri.reciprocal_flag = 'Y'))
5626: and exists (select 1
5627: from po_line_locations_all pll
5628: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5629: , mtl_parameters mp,
5630: rcv_parameters rp
5631: -- End for Bug 7440217

Line 5708: from po_line_locations_all pll

5704: and inventory_item_id IN
5705: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id =
5706: p_poHeaderID
5707: and exists (select 1
5708: from po_line_locations_all pll
5709: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5710: , mtl_parameters mp,
5711: rcv_parameters rp
5712: -- End for Bug 7440217

Line 5792: from po_line_locations_all pll

5788: and pol.item_description like p_concatenated_segments
5789: /* Bug 3972931-Added the following exists condition to restrict the PO receipt
5790: to shipments due to be received only in the organizationientered with.*/
5791: and exists (select 1
5792: from po_line_locations_all pll
5793: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5794: , mtl_parameters mp,
5795: rcv_parameters rp
5796: -- End for Bug 7440217

Line 5879: from po_line_locations_all pll

5875: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
5876: and msi.inventory_item_id IN
5877: ( SELECT pl.item_id FROM po_lines_all pl WHERE pl.po_header_id = p_poHeaderID
5878: and exists (select 1
5879: from po_line_locations_all pll
5880: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
5881: , mtl_parameters mp,
5882: rcv_parameters rp
5883: -- End for Bug 7440217

Line 6048: from po_line_locations_all pll

6044: FROM po_lines_all pl
6045: WHERE pl.po_header_id = rsl.po_header_id
6046: and pl.po_line_id = rsl.po_line_id
6047: and exists (select 1
6048: from po_line_locations_all pll
6049: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6050: , mtl_parameters mp,
6051: rcv_parameters rp
6052: -- End for Bug 7440217

Line 6148: from po_line_locations_all pll

6144: AND rsl.source_document_code = 'PO'
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_all pll
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 6919: po_line_locations_all pll

6915: AND (msi.purchasing_enabled_flag = 'Y' OR msi.stock_enabled_flag = 'Y')
6916: AND EXISTS (SELECT '1'
6917: FROM po_lines_all pol,
6918: mtl_related_items mri,
6919: po_line_locations_all pll
6920: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
6921: , mtl_parameters mp,
6922: rcv_parameters rp
6923: -- End for Bug 7440217

Line 7004: FROM po_line_locations_all pll

7000: AND pol.vendor_product_num like p_concatenated_segments
7001: AND pol.item_id = msi.inventory_item_id
7002: AND pol.vendor_product_num IS NOT NULL
7003: AND EXISTS (SELECT '1'
7004: FROM po_line_locations_all pll
7005: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7006: , mtl_parameters mp,
7007: rcv_parameters rp
7008: -- End for Bug 7440217

Line 7150: FROM po_line_locations_all pll

7146: AND pol.ITEM_ID is NULL
7147: AND pol.item_description IS NOT NULL
7148: AND pol.item_description LIKE p_concatenated_segments
7149: AND EXISTS (SELECT '1'
7150: FROM po_line_locations_all pll
7151: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
7152: , mtl_parameters mp,
7153: rcv_parameters rp
7154: -- End for Bug 7440217