APPS.INV_UI_RCV_LOVS dependencies on PO_HEADERS_TRX_V

Line 111: po_Headers_trx_v poh , -- CLM, bug 9403291

107: to_char(poh.org_id) --
108:
109: FROM rcv_Supply ms ,
110: rcv_Transactions rt,
111: po_Headers_trx_v poh , -- CLM, bug 9403291
112: mtl_Parameters mp
113: WHERE poh.po_Header_Id = ms.po_Header_Id
114: AND ms.Quantity > 0
115: AND ms.Supply_Type_Code = 'RECEIVING'

Line 178: FROM po_headers_trx_v poh -- CLM project, bug 9403291

174: , poh.vendor_site_id
175: , 'Vendor'
176: , poh.note_to_receiver
177: , to_char(poh.org_id) --
178: FROM po_headers_trx_v poh -- CLM project, bug 9403291
179: WHERE exists (SELECT 'Valid PO Shipments'
180: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
181: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
182: , mtl_parameters mp,

Line 221: FROM po_headers_trx_v poh -- CLM project, bug 9403291

217: , poh.vendor_site_id
218: , 'Vendor'
219: , poh.note_to_receiver
220: , to_char(poh.org_id) --
221: FROM po_headers_trx_v poh -- CLM project, bug 9403291
222: , rcv_shipment_lines rsl
223: WHERE exists (SELECT 'Valid PO Shipments'
224: FROM po_line_locations_trx_v poll -- CLM project, bug 9403291
225: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not

Line 275: PO_HEADERS_trx_v POH, -- CLM project, bug 9403291

271: RCV_TRANSACTIONS RT,
272: PO_LOOKUP_CODES PLC,
273: PO_LINES_trx_v pol, -- CLM project, bug 9403291
274: PO_LINE_LOCATIONS_trx_v PLL, -- CLM project, bug 9403291
275: PO_HEADERS_trx_v POH, -- CLM project, bug 9403291
276: po_line_types plt,--BUG 5166887
277: mtl_parameters mp --BUG 5166887
278: -- For Bug 7440217 Added RCV_PRAMETERS to find out if the organization is LCM enabled or not
279: , rcv_parameters rp

Line 1549: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1545: NULL FIELD12 ,
1546: NULL FIELD13 ,
1547: lookup_code FIELD14 ,
1548: to_char(poh.org_id) FIELD15 --
1549: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1550: fnd_lookup_values_vl flv
1551: WHERE flv.lookup_code = 'PO'
1552: AND flv.lookup_type = 'DOC_TYPE'
1553: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 1613: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1609: NULL FIELD12 ,
1610: NULL FIELD13 ,
1611: lookup_code FIELD14 ,
1612: to_char(poh.org_id) FIELD15 --
1613: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1614: fnd_lookup_values_vl flv
1615: WHERE flv.lookup_code = 'PO'
1616: AND flv.lookup_type = 'DOC_TYPE'
1617: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 1703: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1699: NULL FIELD12,
1700: NULL FIELD13,
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

Line 1762: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1758: NULL FIELD12 ,
1759: NULL FIELD13 ,
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 ,

Line 1825: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1821: NULL FIELD12 ,
1822: NULL FIELD13 ,
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 ,

Line 1893: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1889: NULL FIELD12 ,
1890: NULL FIELD13 ,
1891: lookup_code FIELD14 ,
1892: to_char(poh.org_id) FIELD15 --
1893: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1894: fnd_lookup_values_vl flv
1895: WHERE flv.lookup_code = 'PO'
1896: AND flv.lookup_type = 'DOC_TYPE'
1897: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 1961: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

1957: NULL FIELD12 ,
1958: NULL FIELD13 ,
1959: lookup_code FIELD14 ,
1960: to_char(poh.org_id) FIELD15 --
1961: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
1962: fnd_lookup_values_vl flv
1963: WHERE flv.lookup_code = 'PO'
1964: AND flv.lookup_type = 'DOC_TYPE'
1965: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 2449: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

2445: NULL FIELD12 ,
2446: NULL FIELD13 ,
2447: lookup_code FIELD14 ,
2448: to_char(poh.org_id) FIELD15 --
2449: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
2450: fnd_lookup_values_vl flv
2451: WHERE flv.lookup_code = 'PO'
2452: AND flv.lookup_type = 'DOC_TYPE'
2453: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 2514: FROM po_headers_trx_v poh, --CLM project, bug 9403291

2510: NULL FIELD12 ,
2511: NULL FIELD13 ,
2512: lookup_code FIELD14 ,
2513: to_char(poh.org_id) FIELD15 --
2514: FROM po_headers_trx_v poh, --CLM project, bug 9403291
2515: fnd_lookup_values_vl flv
2516: WHERE flv.lookup_code = 'PO'
2517: AND flv.lookup_type = 'DOC_TYPE'
2518: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE

Line 2596: FROM po_headers_trx_v poh, -- CLM project, bug 9403291

2592: NULL FIELD12 ,
2593: NULL FIELD13 ,
2594: lookup_code FIELD14 ,
2595: to_char(poh.org_id) FIELD15 --
2596: FROM po_headers_trx_v poh, -- CLM project, bug 9403291
2597: fnd_lookup_values_vl flv
2598: WHERE flv.lookup_code = 'PO'
2599: AND flv.lookup_type = 'DOC_TYPE'
2600: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE