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_LINES_TRX_V

Line 129: FROM po_Lines_trx_v

125: FROM po_Line_Types
126: WHERE Outside_Operation_Flag = 'Y'
127: AND Line_Type_Id IN
128: (SELECT Line_Type_Id
129: FROM po_Lines_trx_v
130: WHERE po_Header_Id = poh.po_Header_Id
131: )
132: )
133: OR EXISTS

Line 135: FROM po_Lines_trx_v -- CLM project, bug 9403291

131: )
132: )
133: OR EXISTS
134: (SELECT 1
135: FROM po_Lines_trx_v -- CLM project, bug 9403291
136: WHERE po_Header_Id = poh.po_Header_Id
137: AND Item_Id IS NULL
138: )
139: OR EXISTS

Line 144: FROM po_Lines_trx_v

140: (SELECT 1
141: FROM mtl_System_Items_kfv msik
142: WHERE msik.Inventory_Item_Id IN
143: (SELECT Item_Id
144: FROM po_Lines_trx_v
145: WHERE po_Header_Id = poh.po_Header_Id
146: )
147: AND msik.Organization_Id = p_organization_id
148: AND msik.mtl_Transactions_Enabled_Flag = 'N'

Line 273: PO_LINES_trx_v pol, -- CLM project, bug 9403291

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

Line 442: from po_lines_trx_v pl -- CLM project, bug 9403291

438: , pl.item_id
439: , pl.item_revision
440: , msi.concatenated_segments
441: , msi.outside_operation_flag
442: from po_lines_trx_v pl -- CLM project, bug 9403291
443: , mtl_system_items_vl msi
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

Line 490: , po_lines_trx_v pl -- CLM project, bug 9403291

486: uom_code
487: FROM rcv_supply rsup
488: -- bug 2805640
489: , mtl_units_of_measure mum
490: , po_lines_trx_v pl -- CLM project, bug 9403291
491: , mtl_system_items_vl msi
492: WHERE rsup.po_line_id = pl.po_line_id
493: -- bug 2805640
494: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 1565: FROM po_lines_trx_v pl, -- CLM project, bug 9403291

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

Line 1629: FROM po_lines_trx_v pl , -- CLM project, bug 9403291

1625: AND EXISTS
1626: (
1627: SELECT
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

Line 1705: po_lines_trx_v pl, -- CLM project, bug 9403291

1701: lookup_code FIELD14,
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

Line 1764: po_lines_trx_v pl , -- CLM project, bug 9403291

1760: lookup_code FIELD14,
1761: to_char(poh.org_id) FIELD15 --
1762: FROM po_headers_trx_v poh, -- 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

Line 1827: po_lines_trx_v pl , -- CLM project, bug 9403291

1823: lookup_code FIELD14,
1824: to_char(poh.org_id) FIELD15 --
1825: FROM po_headers_trx_v poh, -- 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

Line 1909: FROM po_lines_trx_v pl , -- CLM project, bug 9403291

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

Line 2465: FROM po_lines_trx_v pl , -- CLM project, bug 9403291

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

Line 2530: FROM po_lines_trx_v pl , -- CLM project, bug 9403291

2526: AND EXISTS
2527: (
2528: SELECT
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

Line 2612: FROM po_lines_trx_v pl , -- CLM project, bug 9403291

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

Line 2976: from po_lines_trx_v pl -- CLM project, bug 9403291

2972: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
2973: p_organization_id,
2974: pl.Item_Id)
2975: uom_code
2976: from po_lines_trx_v pl -- CLM project, bug 9403291
2977: , mtl_units_of_measure mum
2978: , mtl_system_items_vl msi
2979: where pl.item_id = msi.inventory_item_id (+)
2980: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE

Line 3022: from po_lines_trx_v pl -- CLM project, bug 9403291

3018: , inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
3019: p_organization_id,
3020: pl.Item_Id)
3021: uom_code
3022: from po_lines_trx_v pl -- CLM project, bug 9403291
3023: , mtl_units_of_measure mum
3024: , mtl_system_items_vl msi
3025: , mtl_related_items mri
3026: where msi.organization_id = p_organization_id -- Bug 6437363

Line 3081: , po_lines_trx_v pl -- CLM project, bug 9403291

3077: pl.Item_Id)
3078: uom_code
3079: FROM rcv_supply rsup
3080: , mtl_units_of_measure mum
3081: , po_lines_trx_v pl -- CLM project, bug 9403291
3082: , mtl_system_items_vl msi
3083: WHERE rsup.po_line_id = pl.po_line_id
3084: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
3085: AND pl.item_id = msi.inventory_item_id (+)

Line 3520: from po_lines_trx_v pol -- CLM project, bug 9403291

3516: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3517: msi.stock_enabled_flag,
3518: ' ',
3519: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3520: from po_lines_trx_v pol -- CLM project, bug 9403291
3521: ,mtl_related_items mri
3522: ,mtl_system_items_vl msi /* Bug 5581528 */
3523: /*,mtl_system_items_kfv msia */ /* Bug 6334679*/
3524: where msi.organization_id = p_organization_id

Line 3617: from po_lines_trx_v pol -- CLM project, bug 9403291

3613: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3614: msi.stock_enabled_flag,
3615: ' ',
3616: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3617: from po_lines_trx_v pol -- CLM project, bug 9403291
3618: , mtl_system_items_vl msi /* Bug 5581528 */
3619: where organization_id = p_organization_id
3620: and pol.vendor_product_num like p_concatenated_segments
3621: and pol.item_id = msi.inventory_item_id

Line 3625: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol

3621: and pol.item_id = msi.inventory_item_id
3622: and pol.vendor_product_num IS NOT NULL
3623: and pol.po_header_id = p_poHeaderID
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

Line 3710: from po_lines_trx_v pol -- CLM project, bug 9403291

3706: 0,
3707: 'N',
3708: ' ',
3709: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3710: from po_lines_trx_v pol -- CLM project, bug 9403291
3711: , mtl_units_of_measure mum
3712: -- Bug 2619063, 2614016
3713: -- Modified to select the base uom for the uom class defined on po.
3714: where mum.uom_class = (SELECT mum2.uom_class

Line 3805: from po_lines_trx_v pol -- CLM project, bug 9403291

3801: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3802: msi.stock_enabled_flag,
3803: ' ',
3804: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3805: from po_lines_trx_v pol -- CLM project, bug 9403291
3806: ,mtl_system_items_vl msi /* Bug 5581528 */
3807: ,mtl_cross_references mcr
3808: where msi.organization_id = p_organization_id
3809: and ( (mcr.cross_reference_type = p_crossreftype

Line 3822: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291

3818: and mcr.inventory_item_id = msi.inventory_item_id
3819: and pol.item_id = msi.inventory_item_id
3820: and pol.po_header_id = p_poHeaderID
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

Line 3908: from po_lines_trx_v pol -- CLM project, bug 9403291

3904: 0,
3905: 'N',
3906: ' ',
3907: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3908: from po_lines_trx_v pol -- CLM project, bug 9403291
3909: , mtl_units_of_measure mum
3910: -- Bug 2619063, 2614016
3911: -- Modified to select the base uom for the uom class defined on po.
3912: where mum.uom_class = (SELECT mum2.uom_class

Line 4099: from po_lines_trx_v pol -- CLM project, bug 9403291

4095: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4096: msi.stock_enabled_flag,
4097: ' ',
4098: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4099: from po_lines_trx_v pol -- CLM project, bug 9403291
4100: ,mtl_related_items mri
4101: ,mtl_system_items_vl msi /* Bug 5581528 */
4102: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4103: where msi.organization_id = p_organization_id

Line 4196: from po_lines_trx_v pol -- CLM project, bug 9403291

4192: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4193: msi.stock_enabled_flag,
4194: ' ',
4195: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4196: from po_lines_trx_v pol -- CLM project, bug 9403291
4197: , mtl_system_items_vl msi /* Bug 5581528 */
4198: where organization_id = p_organization_id
4199: and pol.vendor_product_num like p_concatenated_segments
4200: and pol.item_id = msi.inventory_item_id

Line 4204: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

4200: and pol.item_id = msi.inventory_item_id
4201: and pol.vendor_product_num IS NOT NULL
4202: and pol.po_header_id = p_poHeaderID
4203: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 4289: from po_lines_trx_v pol -- CLM project, bug 9403291

4285: 0,
4286: 'N',
4287: ' ',
4288: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4289: from po_lines_trx_v pol -- CLM project, bug 9403291
4290: , mtl_units_of_measure mum
4291: -- Bug 2619063, 2614016
4292: -- Modified to select the base uom for the uom class defined on po.
4293: where mum.uom_class = (SELECT mum2.uom_class

Line 4383: from po_lines_trx_v pol -- CLM project, bug 9403291

4379: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4380: msi.stock_enabled_flag,
4381: ' ',
4382: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4383: from po_lines_trx_v pol -- CLM project, bug 9403291
4384: ,mtl_system_items_vl msi /* Bug 5581528 */
4385: ,mtl_cross_references mcr
4386: where msi.organization_id = p_organization_id
4387: and ( (mcr.cross_reference_type = p_crossreftype

Line 4400: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

4396: and mcr.inventory_item_id = msi.inventory_item_id
4397: and pol.item_id = msi.inventory_item_id
4398: and pol.po_header_id = p_poHeaderID
4399: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 4488: from po_lines_trx_v pol -- CLM project, bug 9403291

4484: 0,
4485: 'N',
4486: ' ',
4487: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4488: from po_lines_trx_v pol -- CLM project, bug 9403291
4489: , mtl_units_of_measure mum
4490: -- Bug 2619063, 2614016
4491: -- Modified to select the base uom for the uom class defined on po.
4492: where mum.uom_class = (SELECT mum2.uom_class

Line 4599: po_lines_trx_v pol --CLM project, bug 9403291 -- bug 4602289

4595: stock_enabled_flag,
4596: ' ',
4597: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4598: from mtl_system_items_vl , /* Bug 5581528 */
4599: po_lines_trx_v pol --CLM project, bug 9403291 -- bug 4602289
4600: WHERE organization_id = p_Organization_Id
4601: and concatenated_segments like p_concatenated_segments||l_append
4602: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
4603: and inventory_item_id = pol.item_id -- bug 4602289

Line 4687: from po_lines_trx_v pol -- CLM project, bug 9403291

4683: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4684: msi.stock_enabled_flag,
4685: ' ',
4686: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4687: from po_lines_trx_v pol -- CLM project, bug 9403291
4688: ,mtl_related_items mri
4689: ,mtl_system_items_vl msi /* Bug 5581528 */
4690: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
4691: where msi.organization_id = p_organization_id

Line 4783: from po_lines_trx_v pol -- CLM project, bug 9403291

4779: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4780: msi.stock_enabled_flag,
4781: ' ',
4782: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4783: from po_lines_trx_v pol -- CLM project, bug 9403291
4784: , mtl_system_items_vl msi /* Bug 5581528 */
4785: where organization_id = p_organization_id
4786: and pol.vendor_product_num like p_concatenated_segments
4787: and pol.item_id = msi.inventory_item_id

Line 4792: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

4788: and pol.vendor_product_num IS NOT NULL
4789: and pol.po_header_id = p_poHeaderID
4790: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 4875: from po_lines_trx_v pol -- CLM project, bug 9403291

4871: 0,
4872: 'N',
4873: ' ',
4874: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4875: from po_lines_trx_v pol -- CLM project, bug 9403291
4876: , mtl_units_of_measure mum
4877: -- Bug 2619063, 2614016
4878: -- Modified to select the base uom for the uom class defined on po.
4879: where mum.uom_class = (SELECT mum2.uom_class

Line 4969: from po_lines_trx_v pol -- CLM project, bug 9403291

4965: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4966: msi.stock_enabled_flag,
4967: ' ',
4968: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4969: from po_lines_trx_v pol -- CLM project, bug 9403291
4970: ,mtl_system_items_vl msi /* Bug 5581528 */
4971: ,mtl_cross_references mcr
4972: where msi.organization_id = p_organization_id
4973: and ( (mcr.cross_reference_type = p_crossreftype

Line 4987: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

4983: and pol.item_id = msi.inventory_item_id
4984: and pol.po_header_id = p_poHeaderID
4985: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 5071: from po_lines_trx_v pol -- CLM project, bug 9403291

5067: 0,
5068: 'N',
5069: ' ',
5070: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5071: from po_lines_trx_v pol -- CLM project, bug 9403291
5072: , mtl_units_of_measure mum
5073: -- Bug 2619063, 2614016
5074: -- Modified to select the base uom for the uom class defined on po.
5075: where mum.uom_class = (SELECT mum2.uom_class

Line 5250: from po_lines_trx_v pol -- CLM project, bug 9403291

5246: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5247: msi.stock_enabled_flag,
5248: ' ',
5249: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5250: from po_lines_trx_v pol -- CLM project, bug 9403291
5251: ,mtl_related_items mri
5252: ,mtl_system_items_vl msi /* Bug 5581528 */
5253: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
5254: where msi.organization_id = p_organization_id

Line 5339: from po_lines_trx_v pol -- CLM project, bug 9403291

5335: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5336: msi.stock_enabled_flag,
5337: ' ',
5338: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5339: from po_lines_trx_v pol -- CLM project, bug 9403291
5340: , mtl_system_items_vl msi /* Bug 5581528 */
5341: where organization_id = p_organization_id
5342: and pol.vendor_product_num like p_concatenated_segments
5343: and pol.item_id = msi.inventory_item_id

Line 5347: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291

5343: and pol.item_id = msi.inventory_item_id
5344: and pol.vendor_product_num IS NOT NULL
5345: and pol.po_header_id = p_poHeaderID
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

Line 5424: from po_lines_trx_v pol -- CLM project, bug 9403291

5420: 0,
5421: 'N',
5422: ' ',
5423: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5424: from po_lines_trx_v pol -- CLM project, bug 9403291
5425: , mtl_units_of_measure mum
5426: -- Bug 2619063, 2614016
5427: -- Modified to select the base uom for the uom class defined on po.
5428: where mum.uom_class = (SELECT mum2.uom_class

Line 5512: from po_lines_trx_v pol -- CLM project, bug 9403291

5508: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5509: msi.stock_enabled_flag,
5510: ' ',
5511: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5512: from po_lines_trx_v pol -- CLM project, bug 9403291
5513: ,mtl_system_items_vl msi /* Bug 5581528 */
5514: ,mtl_cross_references mcr
5515: where msi.organization_id = p_organization_id
5516: and ( (mcr.cross_reference_type = p_crossreftype

Line 5529: and msi.inventory_item_id IN (SELECT pol.item_id FROM po_lines_trx_v pol -- CLM project, bug 9403291

5525: and mcr.inventory_item_id = msi.inventory_item_id
5526: and pol.item_id = msi.inventory_item_id
5527: and pol.po_header_id = p_poHeaderID
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

Line 5607: from po_lines_trx_v pol -- CLM project, bug 9403291

5603: 0,
5604: 'N',
5605: ' ',
5606: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5607: from po_lines_trx_v pol -- CLM project, bug 9403291
5608: , mtl_units_of_measure mum
5609: -- Bug 2619063, 2614016
5610: -- Modified to select the base uom for the uom class defined on po.
5611: where mum.uom_class = (SELECT mum2.uom_class

Line 5780: from po_lines_trx_v pol -- CLM project, bug 9403291

5776: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5777: msi.stock_enabled_flag,
5778: ' ',
5779: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5780: from po_lines_trx_v pol -- CLM project, bug 9403291
5781: ,mtl_related_items mri
5782: ,mtl_system_items_vl msi /* Bug 5581528 */
5783: /*,mtl_system_items_kfv msia*/ /* Bug 6334679 */
5784: where msi.organization_id = p_organization_id

Line 5868: from po_lines_trx_v pol -- CLM project, bug 9403291

5864: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5865: msi.stock_enabled_flag,
5866: ' ',
5867: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5868: from po_lines_trx_v pol -- CLM project, bug 9403291
5869: ,mtl_system_items_vl msi /* Bug 5581528 */
5870: where organization_id = p_organization_id
5871: and pol.vendor_product_num like p_concatenated_segments
5872: and pol.item_id = msi.inventory_item_id

Line 5876: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

5872: and pol.item_id = msi.inventory_item_id
5873: and pol.vendor_product_num IS NOT NULL
5874: and pol.po_header_id = p_poHeaderID
5875: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 5952: from po_lines_trx_v pol -- CLM project, bug 9403291

5948: 0,
5949: 'N',
5950: ' ',
5951: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5952: from po_lines_trx_v pol -- CLM project, bug 9403291
5953: , mtl_units_of_measure mum
5954: -- Bug 2619063, 2614016
5955: -- Modified to select the base uom for the uom class defined on po.
5956: where mum.uom_class = (SELECT mum2.uom_class

Line 6038: from po_lines_trx_v pol -- CLM project, bug 9403291

6034: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6035: msi.stock_enabled_flag,
6036: ' ',
6037: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6038: from po_lines_trx_v pol -- CLM project, bug 9403291
6039: ,mtl_system_items_vl msi /* Bug 5581528 */
6040: ,mtl_cross_references mcr
6041: where msi.organization_id = p_organization_id
6042: and ( (mcr.cross_reference_type = p_crossreftype

Line 6055: and msi.inventory_item_id IN (SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

6051: and mcr.inventory_item_id = msi.inventory_item_id
6052: and pol.item_id = msi.inventory_item_id
6053: and pol.po_header_id = p_poHeaderID
6054: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 6132: from po_lines_trx_v pol -- CLM project, bug 9403291

6128: 0,
6129: 'N',
6130: ' ',
6131: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6132: from po_lines_trx_v pol -- CLM project, bug 9403291
6133: , mtl_units_of_measure mum
6134: -- Bug 2619063, 2614016
6135: -- Modified to select the base uom for the uom class defined on po.
6136: where mum.uom_class = (SELECT mum2.uom_class

Line 6228: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

6224: WHERE organization_id = p_Organization_Id
6225: and concatenated_segments like p_concatenated_segments||l_append
6226: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 6303: from po_lines_trx_v pol -- CLM project, bug 9403291

6299: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6300: msi.stock_enabled_flag,
6301: ' ',
6302: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6303: from po_lines_trx_v pol -- CLM project, bug 9403291
6304: ,mtl_related_items mri
6305: ,mtl_system_items_vl msi /* Bug 5581528 */
6306: /*,mtl_system_items_kfv msia */ /* Bug 6334679 */
6307: where msi.organization_id = p_organization_id

Line 6390: from po_lines_trx_v pol -- CLM project, bug 9403291

6386: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6387: msi.stock_enabled_flag,
6388: ' ',
6389: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6390: from po_lines_trx_v pol -- CLM project, bug 9403291
6391: , mtl_system_items_vl msi /* Bug 5581528 */
6392: where organization_id = p_organization_id
6393: and pol.vendor_product_num like p_concatenated_segments
6394: and pol.item_id = msi.inventory_item_id

Line 6399: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

6395: and pol.vendor_product_num IS NOT NULL
6396: and pol.po_header_id = p_poHeaderID
6397: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 6474: from po_lines_trx_v pol -- CLM project, bug 9403291

6470: 0,
6471: 'N',
6472: ' ',
6473: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6474: from po_lines_trx_v pol -- CLM project, bug 9403291
6475: , mtl_units_of_measure mum
6476: -- Bug 2619063, 2614016
6477: -- Modified to select the base uom for the uom class defined on po.
6478: where mum.uom_class = (SELECT mum2.uom_class

Line 6559: from po_lines_trx_v pol -- CLM project, bug 9403291

6555: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6556: msi.stock_enabled_flag,
6557: ' ',
6558: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6559: from po_lines_trx_v pol -- CLM project, bug 9403291
6560: ,mtl_system_items_vl msi /* Bug 5581528 */
6561: ,mtl_cross_references mcr
6562: where msi.organization_id = p_organization_id
6563: and ( (mcr.cross_reference_type = p_crossreftype

Line 6577: ( SELECT pl.item_id FROM po_lines_trx_v pl -- CLM project, bug 9403291

6573: and pol.item_id = msi.inventory_item_id
6574: and pol.po_header_id = p_poHeaderID
6575: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
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

Line 6653: from po_lines_trx_v pol -- CLM project, bug 9403291

6649: 0,
6650: 'N',
6651: ' ',
6652: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6653: from po_lines_trx_v pol -- CLM project, bug 9403291
6654: , mtl_units_of_measure mum
6655: -- Bug 2619063, 2614016
6656: -- Modified to select the base uom for the uom class defined on po.
6657: where mum.uom_class = (SELECT mum2.uom_class

Line 6832: ,po_lines_trx_v pol -- CLM project, bug 9403291

6828: rsh.shipment_num),
6829: DECODE (p_reqHeaderID,to_char(null),' ',
6830: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6831: from wms_lpn_contents wlc
6832: ,po_lines_trx_v pol -- CLM project, bug 9403291
6833: ,mtl_system_items_vl msi /* Bug 5581528 */
6834: ,rcv_shipment_lines rsl
6835: ,rcv_shipment_headers rsh /* Added for Bug9257750 */
6836: where msi.organization_id = p_Organization_Id

Line 6846: FROM po_lines_trx_v pl

6842: and pol.po_header_id = Nvl(p_poheaderid,pol.po_header_id)
6843: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6844: and msi.inventory_item_id IN
6845: (SELECT pl.item_id
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

Line 6930: from po_lines_trx_v pol -- CLM project, bug 9403291

6926: DECODE (p_reqHeaderID,to_char(null),' ',
6927: rsh.shipment_num),
6928: DECODE (p_reqHeaderID,to_char(null),' ',
6929: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6930: from po_lines_trx_v pol -- CLM project, bug 9403291
6931: , mtl_units_of_measure mum
6932: ,rcv_shipment_lines rsl
6933: , rcv_shipment_headers rsh /* Added for Bug9257750 */
6934: -- Bug 2619063, 2614016

Line 7172: from po_lines_trx_v pol -- CLM project, bug 9403291

7168: DECODE (p_reqHeaderID,to_char(null),' ',
7169: rsh.shipment_num),
7170: DECODE (p_reqHeaderID,to_char(null),' ',
7171: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7172: from po_lines_trx_v pol -- CLM project, bug 9403291
7173: ,mtl_system_items_vl msi /* Bug 5581528 */
7174: ,rcv_shipment_lines rsl
7175: ,rcv_shipment_headers rsh /* Added for Bug9257750 */
7176: where msi.organization_id = p_Organization_Id

Line 7183: FROM po_lines_trx_v pl

7179: and pol.vendor_product_num IS NOT NULL
7180: and pol.po_header_id = Nvl(p_poheaderid,pol.po_header_id)
7181: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7182: and msi.inventory_item_id IN (SELECT pl.item_id
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

Line 7268: from po_lines_trx_v pol -- CLM project, bug 9403291

7264: DECODE (p_reqHeaderID,to_char(null),' ',
7265: rsh.shipment_num),
7266: DECODE (p_reqHeaderID,to_char(null),' ',
7267: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7268: from po_lines_trx_v pol -- CLM project, bug 9403291
7269: , mtl_units_of_measure mum
7270: ,rcv_shipment_lines rsl
7271: , rcv_shipment_headers rsh /* Added for Bug9257750 */
7272: -- Bug 2619063, 2614016

Line 7962: FROM po_lines_trx_v pol, -- CLM project, bug 9403291

7958: WHERE msi.organization_id = p_organization_Id
7959: AND msi.concatenated_segments LIKE p_concatenated_segments||l_append
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,

Line 8044: po_lines_trx_v pol, -- CLM project, bug 9403291

8040: msi.stock_enabled_flag,
8041: ' ',
8042: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8043: FROM
8044: po_lines_trx_v pol, -- CLM project, bug 9403291
8045: mtl_system_items_vl msi /* Bug 5581528 */
8046: WHERE msi.organization_id = p_organization_Id
8047: AND (msi.purchasing_enabled_flag = 'Y' OR msi.stock_enabled_flag = 'Y')
8048: AND pol.vendor_product_num like p_concatenated_segments

Line 8192: po_lines_trx_v pol, -- CLM project, bug 9403291

8188: 'N',
8189: ' ',
8190: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8191: FROM
8192: po_lines_trx_v pol, -- CLM project, bug 9403291
8193: mtl_units_of_measure mum
8194: -- Bug 2619063, 2614016
8195: -- Modified to select the base uom for the uom class defined on po.
8196: WHERE mum.uom_class = (SELECT mum2.uom_class