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.PO_CONTERMS_UTL_GRP dependencies on FND_CURRENCIES_VL

Line 2127: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;

2123: --parameters involved in calculating the functional and trancastion amounts
2124: --from the SQL query below.
2125: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
2126: l_poh_rate PO_HEADERS.rate%type ;
2127: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2128: l_cu_precision FND_CURRENCIES_VL.precision%type;
2129: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2130: l_cuf_precision FND_CURRENCIES_VL.precision%type;
2131: l_po_total_amount NUMBER;

Line 2128: l_cu_precision FND_CURRENCIES_VL.precision%type;

2124: --from the SQL query below.
2125: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
2126: l_poh_rate PO_HEADERS.rate%type ;
2127: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2128: l_cu_precision FND_CURRENCIES_VL.precision%type;
2129: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2130: l_cuf_precision FND_CURRENCIES_VL.precision%type;
2131: l_po_total_amount NUMBER;
2132: --BUG#3809298 End of variable declarations.

Line 2129: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;

2125: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
2126: l_poh_rate PO_HEADERS.rate%type ;
2127: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2128: l_cu_precision FND_CURRENCIES_VL.precision%type;
2129: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2130: l_cuf_precision FND_CURRENCIES_VL.precision%type;
2131: l_po_total_amount NUMBER;
2132: --BUG#3809298 End of variable declarations.
2133:

Line 2130: l_cuf_precision FND_CURRENCIES_VL.precision%type;

2126: l_poh_rate PO_HEADERS.rate%type ;
2127: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2128: l_cu_precision FND_CURRENCIES_VL.precision%type;
2129: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
2130: l_cuf_precision FND_CURRENCIES_VL.precision%type;
2131: l_po_total_amount NUMBER;
2132: --BUG#3809298 End of variable declarations.
2133:
2134: -- Bug 3250745. l_dummy_value will be returned for all the variables which neither

Line 2513: ,FND_CURRENCIES_VL CU

2509:
2510: FROM
2511: po_headers_all poh
2512: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2513: ,FND_CURRENCIES_VL CU
2514: ,GL_SETS_OF_BOOKS gsb
2515: ,FND_CURRENCIES_VL cuf
2516: ,po_vendor_sites_all pvs
2517: WHERE

Line 2515: ,FND_CURRENCIES_VL cuf

2511: po_headers_all poh
2512: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2513: ,FND_CURRENCIES_VL CU
2514: ,GL_SETS_OF_BOOKS gsb
2515: ,FND_CURRENCIES_VL cuf
2516: ,po_vendor_sites_all pvs
2517: WHERE
2518: poh.po_header_id = p_doc_id
2519: AND poh.vendor_site_id = pvs.vendor_site_id(+)

Line 2647: ,FND_CURRENCIES_VL CU

2643:
2644: FROM
2645: po_headers_draft_all poh
2646: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2647: ,FND_CURRENCIES_VL CU
2648: ,GL_SETS_OF_BOOKS gsb
2649: ,FND_CURRENCIES_VL cuf
2650: ,po_vendor_sites_all pvs
2651: WHERE

Line 2649: ,FND_CURRENCIES_VL cuf

2645: po_headers_draft_all poh
2646: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2647: ,FND_CURRENCIES_VL CU
2648: ,GL_SETS_OF_BOOKS gsb
2649: ,FND_CURRENCIES_VL cuf
2650: ,po_vendor_sites_all pvs
2651: WHERE
2652: poh.draft_id = p_doc_id
2653: AND poh.vendor_site_id = pvs.vendor_site_id(+)