DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on FND_CURRENCIES_VL

Line 1939: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;

1935: --parameters involved in calculating the functional and trancastion amounts
1936: --from the SQL query below.
1937: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
1938: l_poh_rate PO_HEADERS.rate%type ;
1939: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1940: l_cu_precision FND_CURRENCIES_VL.precision%type;
1941: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1942: l_cuf_precision FND_CURRENCIES_VL.precision%type;
1943: l_po_total_amount NUMBER;

Line 1940: l_cu_precision FND_CURRENCIES_VL.precision%type;

1936: --from the SQL query below.
1937: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
1938: l_poh_rate PO_HEADERS.rate%type ;
1939: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1940: l_cu_precision FND_CURRENCIES_VL.precision%type;
1941: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1942: l_cuf_precision FND_CURRENCIES_VL.precision%type;
1943: l_po_total_amount NUMBER;
1944: --BUG#3809298 End of variable declarations.

Line 1941: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;

1937: l_poh_type_lookup_code PO_HEADERS.type_lookup_code%type;
1938: l_poh_rate PO_HEADERS.rate%type ;
1939: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1940: l_cu_precision FND_CURRENCIES_VL.precision%type;
1941: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1942: l_cuf_precision FND_CURRENCIES_VL.precision%type;
1943: l_po_total_amount NUMBER;
1944: --BUG#3809298 End of variable declarations.
1945:

Line 1942: l_cuf_precision FND_CURRENCIES_VL.precision%type;

1938: l_poh_rate PO_HEADERS.rate%type ;
1939: l_cu_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1940: l_cu_precision FND_CURRENCIES_VL.precision%type;
1941: l_cuf_MINIMUM_ACCOUNTABLE_UNIT FND_CURRENCIES_VL.minimum_accountable_unit%type;
1942: l_cuf_precision FND_CURRENCIES_VL.precision%type;
1943: l_po_total_amount NUMBER;
1944: --BUG#3809298 End of variable declarations.
1945:
1946: -- Bug 3250745. l_dummy_value will be returned for all the variables which neither

Line 2314: ,FND_CURRENCIES_VL CU

2310:
2311: FROM
2312: po_headers_all poh
2313: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2314: ,FND_CURRENCIES_VL CU
2315: ,GL_SETS_OF_BOOKS gsb
2316: ,FND_CURRENCIES_VL cuf
2317: ,po_vendor_sites_all pvs
2318: WHERE

Line 2316: ,FND_CURRENCIES_VL cuf

2312: po_headers_all poh
2313: ,FINANCIALS_SYSTEM_PARAMS_ALL FP
2314: ,FND_CURRENCIES_VL CU
2315: ,GL_SETS_OF_BOOKS gsb
2316: ,FND_CURRENCIES_VL cuf
2317: ,po_vendor_sites_all pvs
2318: WHERE
2319: poh.po_header_id = p_doc_id
2320: AND poh.vendor_site_id = pvs.vendor_site_id(+)