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 1402: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id

1398: AND nvl(end_date_active,sysdate)>=sysdate
1399: AND enabled_flag = 'Y'
1400: AND meaning like (p_location_code)
1401: ORDER BY Upper (lookup_code);
1402: --Bug 2961355:Changed the query to query from ar_lookups as fnd_lookup_values_vl had duplicate entries based on application id
1403: END get_locationcode_lov;
1404:
1405: /* Direct Shipping */
1406:

Line 1515: fnd_lookup_values_vl flv

1511: NULL FIELD12 ,
1512: lookup_code FIELD13 ,
1513: to_char(poh.org_id) FIELD14 --
1514: FROM po_headers poh,
1515: fnd_lookup_values_vl flv
1516: WHERE flv.lookup_code = 'PO'
1517: AND flv.lookup_type = 'DOC_TYPE'
1518: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1519: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1578: fnd_lookup_values_vl flv

1574: NULL FIELD12 ,
1575: lookup_code FIELD13 ,
1576: to_char(poh.org_id) FIELD14 --
1577: FROM po_headers poh,
1578: fnd_lookup_values_vl flv
1579: WHERE flv.lookup_code = 'PO'
1580: AND flv.lookup_type = 'DOC_TYPE'
1581: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1582: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1667: fnd_lookup_values_vl flv ,

1663: NULL FIELD12,
1664: lookup_code FIELD13,
1665: to_char(poh.org_id) FIELD14 --
1666: FROM po_headers poh,
1667: fnd_lookup_values_vl flv ,
1668: po_lines_all pl,
1669: po_line_locations_all poll
1670: -- For Bug 7440217 Added MTL_PARAMETERS and RCV_PRAMETERS to find out if the organization is LCM enabled or not
1671: , mtl_parameters mp,

Line 1725: fnd_lookup_values_vl flv ,

1721: NULL FIELD12 ,
1722: lookup_code FIELD13,
1723: to_char(poh.org_id) FIELD14 --
1724: FROM po_headers poh,
1725: fnd_lookup_values_vl flv ,
1726: po_lines_all pl ,
1727: mtl_related_items mri ,
1728: mtl_system_items_kfv msi ,
1729: po_line_locations_all poll

Line 1787: fnd_lookup_values_vl flv ,

1783: NULL FIELD12 ,
1784: lookup_code FIELD13,
1785: to_char(poh.org_id) FIELD14 --
1786: FROM po_headers poh,
1787: fnd_lookup_values_vl flv ,
1788: po_lines_all pl ,
1789: mtl_related_items mri ,
1790: mtl_system_items_kfv msi ,
1791: po_line_locations_all poll

Line 1854: fnd_lookup_values_vl flv

1850: NULL FIELD12 ,
1851: lookup_code FIELD13 ,
1852: to_char(poh.org_id) FIELD14 --
1853: FROM po_headers poh,
1854: fnd_lookup_values_vl flv
1855: WHERE flv.lookup_code = 'PO'
1856: AND flv.lookup_type = 'DOC_TYPE'
1857: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1858: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1921: fnd_lookup_values_vl flv

1917: NULL FIELD12 ,
1918: lookup_code FIELD13 ,
1919: to_char(poh.org_id) FIELD14 --
1920: FROM po_headers poh,
1921: fnd_lookup_values_vl flv
1922: WHERE flv.lookup_code = 'PO'
1923: AND flv.lookup_type = 'DOC_TYPE'
1924: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
1925: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 1983: FROM fnd_lookup_values_vl flv,

1979: NULL FIELD11,
1980: NULL FIELD12,
1981: lookup_code FIELD13 ,
1982: to_char(oel.org_id) FIELD14
1983: FROM fnd_lookup_values_vl flv,
1984: OE_ORDER_LINES_all OEL,
1985: OE_ORDER_HEADERS_all OEH,
1986: --OE_LINE_TYPES_V OLT, --bug3173013
1987: OE_TRANSACTION_TYPES_TL OTT_TL,

Line 2050: FROM fnd_lookup_values_vl flv,

2046: sh.waybill_airbill_num FIELD11,
2047: sh.freight_carrier_code FIELD12,
2048: lookup_code FIELD13,
2049: NULL FIELD14 --
2050: FROM fnd_lookup_values_vl flv,
2051: rcv_shipment_headers sh,
2052: rcv_shipment_lines sl
2053: WHERE flv.lookup_code = 'INTSHIP'
2054: AND flv.lookup_type = 'DOC_TYPE'

Line 2097: FROM fnd_lookup_values_vl flv,

2093: sh.waybill_airbill_num FIELD11,
2094: sh.freight_carrier_code FIELD12,
2095: lookup_code FIELD13,
2096: NULL FIELD14 --
2097: FROM fnd_lookup_values_vl flv,
2098: rcv_shipment_headers sh,
2099: rcv_shipment_lines sl
2100: WHERE flv.lookup_code = 'ASN'
2101: AND flv.lookup_type = 'DOC_TYPE'

Line 2139: FROM fnd_lookup_values_vl flv,

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

Line 2182: FROM fnd_lookup_values_vl flv,

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

Line 2225: FROM fnd_lookup_values_vl flv,

2221: sh.waybill_airbill_num FIELD11,
2222: sh.freight_carrier_code FIELD12,
2223: lookup_code FIELD13,
2224: NULL FIELD14 --
2225: FROM fnd_lookup_values_vl flv,
2226: rcv_shipment_headers sh,
2227: rcv_shipment_lines sl
2228: WHERE flv.lookup_code = 'LCM'
2229: AND flv.lookup_type = 'DOC_TYPE'

Line 2267: FROM fnd_lookup_values_vl flv,

2263: sh.waybill_airbill_num FIELD11,
2264: sh.freight_carrier_code FIELD12,
2265: lookup_code FIELD13,
2266: NULL FIELD14 --
2267: FROM fnd_lookup_values_vl flv,
2268: rcv_shipment_headers sh,
2269: rcv_shipment_lines sl
2270: WHERE flv.lookup_code = 'LCM'
2271: AND flv.lookup_type = 'DOC_TYPE'

Line 2310: FROM fnd_lookup_values_vl flv,

2306: sh.waybill_airbill_num FIELD11,
2307: sh.freight_carrier_code FIELD12,
2308: lookup_code FIELD13 ,
2309: NULL FIELD14 --
2310: FROM fnd_lookup_values_vl flv,
2311: rcv_shipment_headers sh,
2312: rcv_shipment_lines sl
2313: WHERE flv.lookup_code = 'LCM'
2314: AND flv.lookup_type = 'DOC_TYPE'

Line 2351: FROM fnd_lookup_values_vl flv,

2347: NULL FIELD11,
2348: NULL FIELD12,
2349: lookup_code FIELD13 ,
2350: to_char(prh.org_id) FIELD14 --
2351: FROM fnd_lookup_values_vl flv,
2352: po_requisition_headers prh,
2353: po_requisition_lines prl
2354: WHERE flv.lookup_code = 'REQ'
2355: AND flv.lookup_type = 'DOC_TYPE'

Line 2399: fnd_lookup_values_vl flv

2395: NULL FIELD12 ,
2396: lookup_code FIELD13 ,
2397: to_char(poh.org_id) FIELD14 --
2398: FROM po_headers poh,
2399: fnd_lookup_values_vl flv
2400: WHERE flv.lookup_code = 'PO'
2401: AND flv.lookup_type = 'DOC_TYPE'
2402: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2403: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2463: fnd_lookup_values_vl flv

2459: NULL FIELD12 ,
2460: lookup_code FIELD13 ,
2461: to_char(poh.org_id) FIELD14 --
2462: FROM po_headers poh,
2463: fnd_lookup_values_vl flv
2464: WHERE flv.lookup_code = 'PO'
2465: AND flv.lookup_type = 'DOC_TYPE'
2466: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2467: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2544: fnd_lookup_values_vl flv

2540: NULL FIELD12 ,
2541: lookup_code FIELD13 ,
2542: to_char(poh.org_id) FIELD14 --
2543: FROM po_headers poh,
2544: fnd_lookup_values_vl flv
2545: WHERE flv.lookup_code = 'PO'
2546: AND flv.lookup_type = 'DOC_TYPE'
2547: AND nvl(flv.start_date_active, SYSDATE) <= SYSDATE
2548: AND nvl(flv.end_date_active,sysdate) >= SYSDATE

Line 2610: FROM fnd_lookup_values_vl flv,

2606: NULL FIELD11,
2607: NULL FIELD12,
2608: lookup_code FIELD13 ,
2609: to_char(oel.org_id) FIELD14 --
2610: FROM fnd_lookup_values_vl flv,
2611: OE_ORDER_LINES_all OEL,
2612: OE_ORDER_HEADERS_all OEH,
2613: --OE_LINE_TYPES_V OLT, --bug3173013
2614: OE_TRANSACTION_TYPES_TL OTT_TL,

Line 2676: FROM fnd_lookup_values_vl flv,

2672: sh.waybill_airbill_num FIELD11,
2673: sh.freight_carrier_code FIELD12,
2674: lookup_code FIELD13,
2675: NULL FIELD14 --
2676: FROM fnd_lookup_values_vl flv,
2677: rcv_shipment_headers sh,
2678: rcv_shipment_lines sl
2679: WHERE flv.lookup_code = 'INTSHIP'
2680: AND flv.lookup_type = 'DOC_TYPE'

Line 2720: FROM fnd_lookup_values_vl flv,

2716: sh.waybill_airbill_num FIELD11,
2717: sh.freight_carrier_code FIELD12,
2718: lookup_code FIELD13,
2719: NULL FIELD14 --
2720: FROM fnd_lookup_values_vl flv,
2721: rcv_shipment_headers sh,
2722: rcv_shipment_lines sl
2723: WHERE flv.lookup_code = 'ASN'
2724: AND flv.lookup_type = 'DOC_TYPE'

Line 2773: FROM fnd_lookup_values_vl flv,

2769: sh.waybill_airbill_num FIELD11,
2770: sh.freight_carrier_code FIELD12,
2771: lookup_code FIELD13,
2772: NULL FIELD14 --
2773: FROM fnd_lookup_values_vl flv,
2774: rcv_shipment_headers sh,
2775: rcv_shipment_lines sl
2776: WHERE flv.lookup_code = 'LCM'
2777: AND flv.lookup_type = 'DOC_TYPE'

Line 2825: FROM fnd_lookup_values_vl flv,

2821: NULL FIELD11,
2822: NULL FIELD12,
2823: lookup_code FIELD13 ,
2824: to_char(prh.org_id) FIELD14 --
2825: FROM fnd_lookup_values_vl flv,
2826: po_requisition_headers prh,
2827: po_requisition_lines prl
2828: WHERE flv.lookup_code = 'REQ'
2829: AND flv.lookup_type = 'DOC_TYPE'