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 FND_LOOKUP_VALUES_VL

Line 1434: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id

1430: AND nvl(end_date_active,sysdate)>=sysdate
1431: AND enabled_flag = 'Y'
1432: AND meaning like (p_location_code)
1433: ORDER BY Upper (lookup_code);
1434: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id
1435: END get_locationcode_lov;
1436:
1437: /* Direct Shipping */
1438:

Line 1550: fnd_lookup_values_vl flv

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
1554: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1614: fnd_lookup_values_vl flv

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
1618: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1704: fnd_lookup_values_vl flv ,

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

Line 1763: fnd_lookup_values_vl flv ,

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 ,
1767: po_line_locations_trx_v poll -- CLM project, bug 9403291

Line 1826: fnd_lookup_values_vl flv ,

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 ,
1830: po_line_locations_trx_v poll -- CLM project, bug 9403291

Line 1894: fnd_lookup_values_vl flv

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
1898: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1962: fnd_lookup_values_vl flv

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
1966: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2025: FROM fnd_lookup_values_vl flv,

2021: NULL FIELD12,
2022: NULL FIELD13,
2023: lookup_code FIELD14 ,
2024: to_char(oel.org_id) FIELD15
2025: FROM fnd_lookup_values_vl flv,
2026: OE_ORDER_LINES_all OEL,
2027: OE_ORDER_HEADERS_all OEH,
2028: --OE_LINE_TYPES_V OLT, --bug3173013
2029: OE_TRANSACTION_TYPES_TL OTT_TL,

Line 2093: FROM fnd_lookup_values_vl flv,

2089: sh.waybill_airbill_num FIELD12,
2090: sh.freight_carrier_code FIELD13,
2091: lookup_code FIELD14,
2092: NULL FIELD15 --
2093: FROM fnd_lookup_values_vl flv,
2094: rcv_shipment_headers sh,
2095: rcv_shipment_lines sl
2096: WHERE flv.lookup_code = 'INTSHIP'
2097: AND flv.lookup_type = 'DOC_TYPE'

Line 2141: FROM fnd_lookup_values_vl flv,

2137: sh.waybill_airbill_num FIELD12,
2138: sh.freight_carrier_code FIELD13,
2139: lookup_code FIELD14,
2140: NULL FIELD15 --
2141: FROM fnd_lookup_values_vl flv,
2142: rcv_shipment_headers sh,
2143: rcv_shipment_lines sl
2144: WHERE flv.lookup_code = 'ASN'
2145: AND flv.lookup_type = 'DOC_TYPE'

Line 2184: FROM fnd_lookup_values_vl flv,

2180: sh.waybill_airbill_num FIELD12,
2181: sh.freight_carrier_code FIELD13,
2182: lookup_code FIELD14,
2183: NULL FIELD15 --
2184: FROM fnd_lookup_values_vl flv,
2185: rcv_shipment_headers sh,
2186: rcv_shipment_lines sl
2187: WHERE flv.lookup_code = 'ASN'
2188: AND flv.lookup_type = 'DOC_TYPE'

Line 2228: FROM fnd_lookup_values_vl flv,

2224: sh.waybill_airbill_num FIELD12,
2225: sh.freight_carrier_code FIELD13,
2226: lookup_code FIELD14 ,
2227: NULL FIELD15 --
2228: FROM fnd_lookup_values_vl flv,
2229: rcv_shipment_headers sh,
2230: rcv_shipment_lines sl
2231: WHERE flv.lookup_code = 'ASN'
2232: AND flv.lookup_type = 'DOC_TYPE'

Line 2272: FROM fnd_lookup_values_vl flv,

2268: sh.waybill_airbill_num FIELD12,
2269: sh.freight_carrier_code FIELD13,
2270: lookup_code FIELD14,
2271: NULL FIELD15 --
2272: FROM fnd_lookup_values_vl flv,
2273: rcv_shipment_headers sh,
2274: rcv_shipment_lines sl
2275: WHERE flv.lookup_code = 'LCM'
2276: AND flv.lookup_type = 'DOC_TYPE'

Line 2315: FROM fnd_lookup_values_vl flv,

2311: sh.waybill_airbill_num FIELD12,
2312: sh.freight_carrier_code FIELD13,
2313: lookup_code FIELD14,
2314: NULL FIELD15 --
2315: FROM fnd_lookup_values_vl flv,
2316: rcv_shipment_headers sh,
2317: rcv_shipment_lines sl
2318: WHERE flv.lookup_code = 'LCM'
2319: AND flv.lookup_type = 'DOC_TYPE'

Line 2359: FROM fnd_lookup_values_vl flv,

2355: sh.waybill_airbill_num FIELD12,
2356: sh.freight_carrier_code FIELD13,
2357: lookup_code FIELD14 ,
2358: NULL FIELD15 --
2359: FROM fnd_lookup_values_vl flv,
2360: rcv_shipment_headers sh,
2361: rcv_shipment_lines sl
2362: WHERE flv.lookup_code = 'LCM'
2363: AND flv.lookup_type = 'DOC_TYPE'

Line 2401: FROM fnd_lookup_values_vl flv,

2397: NULL FIELD12,
2398: NULL FIELD13,
2399: lookup_code FIELD14 ,
2400: to_char(prh.org_id) FIELD15 --
2401: FROM fnd_lookup_values_vl flv,
2402: po_req_headers_trx_v prh, -- CLM project, bug 9403291
2403: po_req_lines_trx_v prl -- CLM project, bug 9403291
2404: WHERE flv.lookup_code = 'REQ'
2405: AND flv.lookup_type = 'DOC_TYPE'

Line 2450: fnd_lookup_values_vl flv

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
2454: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2515: fnd_lookup_values_vl flv

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
2519: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2597: fnd_lookup_values_vl flv

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
2601: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2664: FROM fnd_lookup_values_vl flv,

2660: NULL FIELD12,
2661: NULL FIELD13,
2662: lookup_code FIELD14 ,
2663: to_char(oel.org_id) FIELD15 --
2664: FROM fnd_lookup_values_vl flv,
2665: OE_ORDER_LINES_all OEL,
2666: OE_ORDER_HEADERS_all OEH,
2667: --OE_LINE_TYPES_V OLT, --bug3173013
2668: OE_TRANSACTION_TYPES_TL OTT_TL,

Line 2731: FROM fnd_lookup_values_vl flv,

2727: sh.waybill_airbill_num FIELD12,
2728: sh.freight_carrier_code FIELD13,
2729: lookup_code FIELD14,
2730: NULL FIELD15 --
2731: FROM fnd_lookup_values_vl flv,
2732: rcv_shipment_headers sh,
2733: rcv_shipment_lines sl
2734: WHERE flv.lookup_code = 'INTSHIP'
2735: AND flv.lookup_type = 'DOC_TYPE'

Line 2776: FROM fnd_lookup_values_vl flv,

2772: sh.waybill_airbill_num FIELD12,
2773: sh.freight_carrier_code FIELD13,
2774: lookup_code FIELD14,
2775: NULL FIELD15 --
2776: FROM fnd_lookup_values_vl flv,
2777: rcv_shipment_headers sh,
2778: rcv_shipment_lines sl
2779: WHERE flv.lookup_code = 'ASN'
2780: AND flv.lookup_type = 'DOC_TYPE'

Line 2830: FROM fnd_lookup_values_vl flv,

2826: sh.waybill_airbill_num FIELD12,
2827: sh.freight_carrier_code FIELD13,
2828: lookup_code FIELD14,
2829: NULL FIELD15 --
2830: FROM fnd_lookup_values_vl flv,
2831: rcv_shipment_headers sh,
2832: rcv_shipment_lines sl
2833: WHERE flv.lookup_code = 'LCM'
2834: AND flv.lookup_type = 'DOC_TYPE'

Line 2883: FROM fnd_lookup_values_vl flv,

2879: NULL FIELD12,
2880: NULL FIELD13,
2881: lookup_code FIELD14 ,
2882: to_char(prh.org_id) FIELD15 --
2883: FROM fnd_lookup_values_vl flv,
2884: po_req_headers_trx_v prh, -- CLM project, bug 9403291
2885: po_req_lines_trx_v prl -- CLM project, bug 9403291
2886: WHERE flv.lookup_code = 'REQ'
2887: AND flv.lookup_type = 'DOC_TYPE'