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.OKL_PAY_INVOICES_DISB_PVT dependencies on OKC_K_HEADERS_B

Line 264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;

260: SELECT khr.pdt_id
261: FROM okl_k_headers khr
262: WHERE khr.id = p_khr_id;
263:
264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;

Line 265: l_khr_id okc_k_headers_b.id%type;

261: FROM okl_k_headers khr
262: WHERE khr.id = p_khr_id;
263:
264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;

Line 266: l_currency_code okc_k_headers_b.currency_code%type;

262: WHERE khr.id = p_khr_id;
263:
264: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
265: l_khr_id okc_k_headers_b.id%type;
266: l_currency_code okc_k_headers_b.currency_code%type;
267: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
270:

Line 272: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS

268: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
269: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
270:
271: --Get currency conversion attributes for a contract
272: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS
273: SELECT currency_code
274: ,currency_conversion_type
275: ,currency_conversion_rate
276: ,currency_conversion_date

Line 744: okc_k_headers_b khr,

740: ppd.processing_fee_percent
741: --ppd.processing_fee_formula
742: FROM okl_party_payment_hdr pph,
743: okl_party_payment_dtls ppd,
744: okc_k_headers_b khr,
745: po_vendor_sites pvs
746: WHERE pph.id = cp_pph_id
747: AND pph.id = ppd.payment_hdr_id
748: AND pph.dnz_chr_id = khr.id

Line 1586: FROM okc_k_headers_b khr

1582: ,null payout_basis_formula
1583: ,khr.contract_number
1584: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
1585: ,tai.legal_entity_id
1586: FROM okc_k_headers_b khr
1587: ,okc_k_lines_b kle
1588: --added for evergreen change request 08_nov_2005
1589: ,okc_line_styles_b lse
1590: ,okl_bpd_ar_inv_lines_v arl

Line 1660: FROM okc_k_headers_b khr

1656: ,null payout_basis_formula
1657: ,khr.contract_number
1658: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1659: ,tai.legal_entity_id
1660: FROM okc_k_headers_b khr
1661: ,okc_k_lines_b kle
1662: ,okc_k_lines_b sub_kle
1663: --added for evergreen change request 08_nov_2005
1664: ,okc_line_styles_b lse

Line 1750: FROM okc_k_headers_b khr

1746: ,null payout_basis_formula
1747: ,khr.contract_number
1748: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1749: ,tai.legal_entity_id
1750: FROM okc_k_headers_b khr
1751: ,okc_k_lines_b kle
1752: --added for evergreen change request 08_nov_2005
1753: ,okc_line_styles_b lse
1754: ,okl_bpd_ar_inv_lines_v arl

Line 1828: FROM okc_k_headers_b khr

1824: ,null payout_basis_formula
1825: ,khr.contract_number
1826: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1827: ,tai.legal_entity_id
1828: FROM okc_k_headers_b khr
1829: ,okc_k_lines_b kle
1830: ,okc_k_lines_b sub_kle
1831: --added for evergreen change request 08_nov_2005
1832: ,okc_line_styles_b lse

Line 1921: FROM okc_k_headers_b khr

1917: ,null payout_basis_formula
1918: ,khr.contract_number
1919: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1920: ,tai.legal_entity_id
1921: FROM okc_k_headers_b khr
1922: ,okc_k_lines_b kle
1923: --added for evergreen change request 08_nov_2005
1924: ,okc_line_styles_b lse
1925: ,okl_bpd_ar_inv_lines_v arl

Line 1999: FROM okc_k_headers_b khr

1995: ,null payout_basis_formula
1996: ,khr.contract_number
1997: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1998: ,tai.legal_entity_id
1999: FROM okc_k_headers_b khr
2000: ,okc_k_lines_b kle
2001: ,okc_k_lines_b sub_kle
2002: --added for evergreen change request 08_nov_2005
2003: ,okc_line_styles_b lse

Line 2092: okc_k_headers_b khr,

2088: khl.legal_entity_id
2089: FROM okl_strm_elements ste,
2090: okl_streams stm,
2091: okl_strm_type_v sty,
2092: okc_k_headers_b khr,
2093: okl_k_headers khl,
2094: hr_operating_units hou,
2095: okc_k_lines_b kle,
2096: --added for evergreen change request 08_nov_2005

Line 2165: okc_k_headers_b khr,

2161: khl.legal_entity_id
2162: FROM okl_strm_elements ste,
2163: okl_streams stm,
2164: okl_strm_type_v sty,
2165: okc_k_headers_b khr,
2166: okl_k_headers khl,
2167: hr_operating_units hou,
2168: okc_k_lines_b kle,
2169: okc_k_lines_b sub_kle,

Line 2247: okc_k_headers_b okch,

2243: okch.contract_number,
2244: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2245: oklh.legal_entity_id
2246: FROM okl_k_headers oklh,
2247: okc_k_headers_b okch,
2248: hr_operating_units hou,
2249: okc_k_lines_b kle,
2250: --added for evergreen change request 08_nov_2005
2251: okc_line_styles_b lse,

Line 2618: OKC_K_HEADERS_B CN

2614: --OKL_CNSLD_AR_STRMS_B ST,
2615: okl_bpd_ar_inv_lines_v ST,
2616: --OKL_STRM_TYPE_TL SM,
2617: okl_strm_type_v SM,
2618: OKC_K_HEADERS_B CN
2619: WHERE
2620: PS.CLASS IN ('INV') AND
2621: ST.INVOICE_ID = PS.CUSTOMER_TRX_ID AND
2622: SM.ID = ST.STY_ID AND