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 47: , mtl_parameters mp

43: , rcv_transactions rt
44: , po_headers_all poh
45: , po_lines_all pol
46: , po_line_types plt
47: , mtl_parameters mp
48: WHERE poh.po_header_id = ms.po_header_id
49: AND ms.quantity > 0
50: AND ms.supply_type_code = 'RECEIVING'
51: AND ms.to_organization_id = p_organization_id

Line 94: mtl_Parameters mp

90:
91: FROM rcv_Supply ms ,
92: rcv_Transactions rt,
93: po_Headers_All poh ,
94: mtl_Parameters mp
95: WHERE poh.po_Header_Id = ms.po_Header_Id
96: AND ms.Quantity > 0
97: AND ms.Supply_Type_Code = 'RECEIVING'
98: AND ms.To_Organization_Id = p_organization_id

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

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
166: WHERE poh.po_header_id = poll.po_header_id

Line 163: , mtl_parameters mp,

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
166: WHERE poh.po_header_id = poll.po_header_id
167: AND Nvl(poll.approved_flag,'N') = 'Y'

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

201: FROM po_headers_all poh
202: , rcv_shipment_lines rsl
203: WHERE exists (SELECT 'Valid PO Shipments'
204: FROM po_line_locations poll
205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
206: , mtl_parameters mp,
207: rcv_parameters rp
208: -- End for Bug 7440217
209: WHERE poh.po_header_id = poll.po_header_id

Line 206: , mtl_parameters mp,

202: , rcv_shipment_lines rsl
203: WHERE exists (SELECT 'Valid PO Shipments'
204: FROM po_line_locations poll
205: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
206: , mtl_parameters mp,
207: rcv_parameters rp
208: -- End for Bug 7440217
209: WHERE poh.po_header_id = poll.po_header_id
210: AND Nvl(poll.approved_flag,'N') = 'Y'

Line 256: mtl_parameters mp --BUG 5166887

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
258: , rcv_parameters rp
259: -- End for Bug 7440217
260: WHERE RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'

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

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
335: WHERE pr.po_header_id = poll.po_header_id

Line 332: , mtl_parameters mp,

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
335: WHERE pr.po_header_id = poll.po_header_id
336: AND pr.po_release_id = poll.po_release_id

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

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
425: WHERE poll.po_header_id = pl.po_header_id

Line 422: , mtl_parameters mp,

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
425: WHERE poll.po_header_id = pl.po_header_id
426: AND poll.po_line_id = pl.po_line_id

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

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
699: -- End for Bug 7440217
700: WHERE RSH.receipt_source_code <> 'VENDOR'

Line 697: , mtl_parameters mp,

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
699: -- End for Bug 7440217
700: WHERE RSH.receipt_source_code <> 'VENDOR'
701: AND RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'

Line 929: , mtl_parameters mp

925: FROM rcv_supply ms
926: , rcv_transactions rt
927: , rcv_shipment_headers rsh
928: , rcv_shipment_lines rsl
929: , mtl_parameters mp
930: WHERE rsh.shipment_header_id = ms.shipment_header_id
931: AND rsh.shipment_header_id = rt.shipment_header_id
932: AND ms.to_organization_id = p_organization_id
933: and mp.organization_id = ms.to_organization_id

Line 1086: mtl_parameters mp --BUG 5166887

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
1090: AND PLC.LOOKUP_TYPE = 'RCV TRANSACTION TYPE'

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

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
1536: WHERE pl.item_id = p_inventory_item_id

Line 1533: , mtl_parameters mp,

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
1536: WHERE pl.item_id = p_inventory_item_id
1537: AND pl.po_header_id = poh.po_header_id

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

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
1601: WHERE msi.organization_id = p_organization_id

Line 1598: , mtl_parameters mp,

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
1601: WHERE msi.organization_id = p_organization_id
1602: AND pl.po_header_id = poh.po_header_id

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

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
1674: WHERE flv.lookup_code = 'PO'

Line 1671: , mtl_parameters mp,

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
1674: WHERE flv.lookup_code = 'PO'
1675: AND flv.lookup_type = 'DOC_TYPE'

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

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
1734: WHERE flv.lookup_code = 'PO'

Line 1731: , mtl_parameters mp,

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
1734: WHERE flv.lookup_code = 'PO'
1735: AND flv.lookup_type = 'DOC_TYPE'

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

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
1796: WHERE flv.lookup_code = 'PO'

Line 1793: , mtl_parameters mp,

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
1796: WHERE flv.lookup_code = 'PO'
1797: AND flv.lookup_type = 'DOC_TYPE'

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

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
1875: WHERE pl.ITEM_ID IS NULL

Line 1872: , mtl_parameters mp,

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
1875: WHERE pl.ITEM_ID IS NULL
1876: AND pl.item_description LIKE p_item_description||'%'

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

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
1941: WHERE poh.po_header_id = poll.po_header_id

Line 1938: , mtl_parameters mp,

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
1941: WHERE poh.po_header_id = poll.po_header_id
1942: AND poll.approved_flag = 'Y'

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

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
2420: WHERE pl.po_header_id = poh.po_header_id

Line 2417: , mtl_parameters mp,

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
2420: WHERE pl.po_header_id = poh.po_header_id
2421: AND Nvl(pl.vendor_product_num,' ') = Nvl(p_vendor_prod_num, Nvl(pl.vendor_product_num,' '))

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

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
2486: WHERE msi.organization_id = p_organization_id

Line 2483: , mtl_parameters mp,

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
2486: WHERE msi.organization_id = p_organization_id
2487: AND

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

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
2565: WHERE pl.item_id IS NULL

Line 2562: , mtl_parameters mp,

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
2565: WHERE pl.item_id IS NULL
2566: AND pl.item_description LIKE p_item_description||'%'

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

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
2916: WHERE poll.po_header_id = pl.po_header_id

Line 2913: , mtl_parameters mp,

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
2916: WHERE poll.po_header_id = pl.po_header_id
2917: AND poll.po_line_id = pl.po_line_id

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

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
2961: WHERE poll.po_header_id = pl.po_header_id

Line 2958: , mtl_parameters mp,

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
2961: WHERE poll.po_header_id = pl.po_header_id
2962: AND poll.po_line_id = pl.po_line_id

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

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
3136: -- End for Bug 7440217
3137: where pr.po_header_id = p_po_header_id

Line 3134: , mtl_parameters mp

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
3136: -- End for Bug 7440217
3137: where pr.po_header_id = p_po_header_id
3138: and nvl(pr.cancel_flag, 'N') = 'N'

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

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
3302: WHERE NVL(pll.closed_code,'OPEN')

Line 3299: , mtl_parameters mp,

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
3302: WHERE NVL(pll.closed_code,'OPEN')
3303: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
3395: where NVL(pll.closed_code,'OPEN')

Line 3392: , mtl_parameters mp,

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
3395: where NVL(pll.closed_code,'OPEN')
3396: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
3484: WHERE NVL(pll.closed_code,'OPEN')

Line 3481: , mtl_parameters mp,

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
3484: WHERE NVL(pll.closed_code,'OPEN')
3485: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
3584: where pll.po_header_id = p_poHeaderID

Line 3581: , mtl_parameters mp,

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
3584: where pll.po_header_id = p_poHeaderID
3585: and pll.po_line_id = pol.po_line_id

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

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
3672: WHERE NVL(pll.closed_code,'OPEN')

Line 3669: , mtl_parameters mp,

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
3672: WHERE NVL(pll.closed_code,'OPEN')
3673: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
3763: where NVL(pll.closed_code, 'OPEN')

Line 3760: , mtl_parameters mp,

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
3763: where NVL(pll.closed_code, 'OPEN')
3764: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' )

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

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
3857: where NVL(pll.closed_code,'OPEN')

Line 3854: , mtl_parameters mp,

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
3857: where NVL(pll.closed_code,'OPEN')
3858: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
3947: where NVL(pll.closed_code, 'OPEN')

Line 3944: , mtl_parameters mp,

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
3947: where NVL(pll.closed_code, 'OPEN')
3948: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING' , 'CLOSED') -- 3687249

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

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
4048: where pll.po_header_id = p_poHeaderID

Line 4045: , mtl_parameters mp,

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
4048: where pll.po_header_id = p_poHeaderID
4049: and pll.po_line_id = pol.po_line_id

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

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
4137: where NVL(pll.closed_code, 'OPEN')

Line 4134: , mtl_parameters mp,

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
4137: where NVL(pll.closed_code, 'OPEN')
4138: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

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

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
4235: where NVL(pll.closed_code,'OPEN')

Line 4232: , mtl_parameters mp,

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
4235: where NVL(pll.closed_code,'OPEN')
4236: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
4328: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 4325: , mtl_parameters mp,

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
4328: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')
4329: and Nvl(pll.allow_substitute_receipts_flag, 'N') = 'Y'

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

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
4418: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

Line 4415: , mtl_parameters mp,

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
4418: where NVL(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')
4419: and pll.po_header_id = p_poHeaderID

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

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
4518: where pll.po_header_id = p_poHeaderID

Line 4515: , mtl_parameters mp,

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
4518: where pll.po_header_id = p_poHeaderID
4519: and pll.po_line_id = pol.po_line_id

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

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
4607: where NVL(pll.closed_code,'OPEN')

Line 4604: , mtl_parameters mp,

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
4607: where NVL(pll.closed_code,'OPEN')
4608: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
4703: WHERE NVL(pll.closed_code,'OPEN')

Line 4700: , mtl_parameters mp,

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
4703: WHERE NVL(pll.closed_code,'OPEN')
4704: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
4789: where NVL(pll.closed_code,'OPEN')

Line 4786: , mtl_parameters mp,

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
4789: where NVL(pll.closed_code,'OPEN')
4790: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
4871: WHERE NVL(pll.closed_code,'OPEN')

Line 4868: , mtl_parameters mp,

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
4871: WHERE NVL(pll.closed_code,'OPEN')
4872: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
4957: where pll.po_header_id = p_poHeaderID

Line 4954: , mtl_parameters mp,

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
4957: where pll.po_header_id = p_poHeaderID
4958: and pll.po_line_id = pol.po_line_id

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

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
5046: WHERE NVL(pll.closed_code,'OPEN')

Line 5043: , mtl_parameters mp,

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
5046: WHERE NVL(pll.closed_code,'OPEN')
5047: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED')

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

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
5129: where NVL(pll.closed_code, 'OPEN')

Line 5126: , mtl_parameters mp,

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
5129: where NVL(pll.closed_code, 'OPEN')
5130: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

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

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
5214: where NVL(pll.closed_code,'OPEN')

Line 5211: , mtl_parameters mp,

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
5214: where NVL(pll.closed_code,'OPEN')
5215: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
5295: where NVL(pll.closed_code, 'OPEN')

Line 5292: , mtl_parameters mp,

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
5295: where NVL(pll.closed_code, 'OPEN')
5296: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

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

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
5379: where pll.po_header_id = p_poHeaderID

Line 5376: , mtl_parameters mp,

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
5379: where pll.po_header_id = p_poHeaderID
5380: -- For Bug 7440217 Checking if it is LCM enabled

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

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
5467: where NVL(pll.closed_code, 'OPEN')

Line 5464: , mtl_parameters mp,

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
5467: where NVL(pll.closed_code, 'OPEN')
5468: not in ('FINALLY CLOSED' , 'CLOSED FOR RECEIVING', 'CLOSED' ) -- 3687249

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

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
5548: where NVL(pll.closed_code,'OPEN')

Line 5545: , mtl_parameters mp,

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
5548: where NVL(pll.closed_code,'OPEN')
5549: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
5632: where NVL(pll.closed_code,'OPEN')

Line 5629: , mtl_parameters mp,

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
5632: where NVL(pll.closed_code,'OPEN')
5633: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
5713: where NVL(pll.closed_code,'OPEN')

Line 5710: , mtl_parameters mp,

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
5713: where NVL(pll.closed_code,'OPEN')
5714: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
5797: where pll.po_header_id = p_poHeaderID

Line 5794: , mtl_parameters mp,

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
5797: where pll.po_header_id = p_poHeaderID
5798: -- For Bug 7440217 Checking if it is LCM enabled

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

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
5884: where NVL(pll.closed_code,'OPEN')

Line 5881: , mtl_parameters mp,

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
5884: where NVL(pll.closed_code,'OPEN')
5885: not in ('FINALLY CLOSED', 'CLOSED FOR RECEIVING', 'CLOSED') -- 3687249

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

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
6053: where NVL(pll.closed_code,'OPEN')

Line 6050: , mtl_parameters mp,

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
6053: where NVL(pll.closed_code,'OPEN')
6054: 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_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
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_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
6153: where pll.po_header_id = p_poHeaderID
6154: -- For Bug 7440217 Checking if it is LCM enabled

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

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
6924: WHERE NVL(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED')

Line 6921: , mtl_parameters mp,

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
6924: WHERE NVL(pll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED')
6925: AND NVL(pll.allow_substitute_receipts_flag, 'N') = 'Y'

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

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
7009: WHERE pll.po_line_id = pol.po_line_id

Line 7006: , mtl_parameters mp,

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
7009: WHERE pll.po_line_id = pol.po_line_id
7010: AND pll.ship_to_organization_id = msi.organization_id

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

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
7155: WHERE pll.po_line_id = pol.po_line_id

Line 7152: , mtl_parameters mp,

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
7155: WHERE pll.po_line_id = pol.po_line_id
7156: AND pll.ship_to_organization_id = p_organization_id