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 309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;

305: SELECT khr.pdt_id
306: FROM okl_k_headers khr
307: WHERE khr.id = p_khr_id;
308:
309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;

Line 310: l_khr_id okc_k_headers_b.id%type;

306: FROM okl_k_headers khr
307: WHERE khr.id = p_khr_id;
308:
309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;

Line 311: l_currency_code okc_k_headers_b.currency_code%type;

307: WHERE khr.id = p_khr_id;
308:
309: -- SUBTYPE khr_id_type IS okc_k_headers_b.id%type;
310: l_khr_id okc_k_headers_b.id%type;
311: l_currency_code okc_k_headers_b.currency_code%type;
312: l_currency_conversion_type okl_k_headers.currency_conversion_type%type;
313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
315:

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

313: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%type;
314: l_currency_conversion_date okl_k_headers.currency_conversion_date%type;
315:
316: --Get currency conversion attributes for a contract
317: CURSOR l_curr_conv_csr(cp_khr_id IN okc_k_headers_b.id%TYPE) IS
318: SELECT currency_code
319: ,currency_conversion_type
320: ,currency_conversion_rate
321: ,currency_conversion_date

Line 789: okc_k_headers_b khr,

785: ppd.processing_fee_percent
786: --ppd.processing_fee_formula
787: FROM okl_party_payment_hdr pph,
788: okl_party_payment_dtls ppd,
789: okc_k_headers_b khr,
790: po_vendor_sites pvs
791: WHERE pph.id = cp_pph_id
792: AND pph.id = ppd.payment_hdr_id
793: AND pph.dnz_chr_id = khr.id

Line 1636: FROM okc_k_headers_b khr

1632: ,null payout_basis_formula
1633: ,khr.contract_number
1634: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
1635: ,tai.legal_entity_id
1636: FROM okc_k_headers_b khr
1637: ,okc_k_lines_b kle
1638: --added for evergreen change request 08_nov_2005
1639: ,okc_line_styles_b lse
1640: ,okl_bpd_ar_inv_lines_v arl

Line 1710: FROM okc_k_headers_b khr

1706: ,null payout_basis_formula
1707: ,khr.contract_number
1708: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1709: ,tai.legal_entity_id
1710: FROM okc_k_headers_b khr
1711: ,okc_k_lines_b kle
1712: ,okc_k_lines_b sub_kle
1713: --added for evergreen change request 08_nov_2005
1714: ,okc_line_styles_b lse

Line 1801: FROM okc_k_headers_b khr

1797: ,null payout_basis_formula
1798: ,khr.contract_number
1799: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1800: ,tai.legal_entity_id
1801: FROM okc_k_headers_b khr
1802: ,okc_k_lines_b kle
1803: --added for evergreen change request 08_nov_2005
1804: ,okc_line_styles_b lse
1805: ,okl_bpd_ar_inv_lines_v arl

Line 1881: FROM okc_k_headers_b khr

1877: ,null payout_basis_formula
1878: ,khr.contract_number
1879: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1880: ,tai.legal_entity_id
1881: FROM okc_k_headers_b khr
1882: ,okc_k_lines_b kle
1883: ,okc_k_lines_b sub_kle
1884: --added for evergreen change request 08_nov_2005
1885: ,okc_line_styles_b lse

Line 1974: FROM okc_k_headers_b khr

1970: ,null payout_basis_formula
1971: ,khr.contract_number
1972: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
1973: ,tai.legal_entity_id
1974: FROM okc_k_headers_b khr
1975: ,okc_k_lines_b kle
1976: --added for evergreen change request 08_nov_2005
1977: ,okc_line_styles_b lse
1978: ,okl_bpd_ar_inv_lines_v arl

Line 2052: FROM okc_k_headers_b khr

2048: ,null payout_basis_formula
2049: ,khr.contract_number
2050: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2051: ,tai.legal_entity_id
2052: FROM okc_k_headers_b khr
2053: ,okc_k_lines_b kle
2054: ,okc_k_lines_b sub_kle
2055: --added for evergreen change request 08_nov_2005
2056: ,okc_line_styles_b lse

Line 2145: okc_k_headers_b khr,

2141: khl.legal_entity_id
2142: FROM okl_strm_elements ste,
2143: okl_streams stm,
2144: okl_strm_type_v sty,
2145: okc_k_headers_b khr,
2146: okl_k_headers khl,
2147: hr_operating_units hou,
2148: okc_k_lines_b kle,
2149: --added for evergreen change request 08_nov_2005

Line 2218: okc_k_headers_b khr,

2214: khl.legal_entity_id
2215: FROM okl_strm_elements ste,
2216: okl_streams stm,
2217: okl_strm_type_v sty,
2218: okc_k_headers_b khr,
2219: okl_k_headers khl,
2220: hr_operating_units hou,
2221: okc_k_lines_b kle,
2222: okc_k_lines_b sub_kle,

Line 2300: okc_k_headers_b okch,

2296: okch.contract_number,
2297: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
2298: oklh.legal_entity_id
2299: FROM okl_k_headers oklh,
2300: okc_k_headers_b okch,
2301: hr_operating_units hou,
2302: okc_k_lines_b kle,
2303: --added for evergreen change request 08_nov_2005
2304: okc_line_styles_b lse,

Line 2671: OKC_K_HEADERS_B CN

2667: --OKL_CNSLD_AR_STRMS_B ST,
2668: okl_bpd_ar_inv_lines_v ST,
2669: --OKL_STRM_TYPE_TL SM,
2670: okl_strm_type_v SM,
2671: OKC_K_HEADERS_B CN
2672: WHERE
2673: PS.CLASS IN ('INV') AND
2674: ST.INVOICE_ID = PS.CUSTOMER_TRX_ID AND
2675: SM.ID = ST.STY_ID AND