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.OKS_OCINT_PUB dependencies on OKS_K_LINES_B

Line 854: ,oks_k_lines_b slines

850: SELECT
851: SUM(NVL(slines.tax_amount,0)) tax_amount
852: FROM
853: okc_k_lines_b clines
854: ,oks_k_lines_b slines
855: WHERE
856: clines.dnz_chr_id = p_chr_id
857: and clines.cle_id = p_line_id
858: and clines.id = slines.cle_id;

Line 867: ,oks_k_lines_b slines

863: SELECT
864: SUM(NVL(slines.tax_amount,0)) tax_amount
865: FROM
866: okc_k_lines_b clines
867: ,oks_k_lines_b slines
868: WHERE
869: clines.dnz_chr_id = p_chr_id
870: AND clines.lse_id IN (1, 19)
871: AND clines.id = slines.cle_id;

Line 2025: UPDATE oks_k_lines_b

2021: FETCH c_extwar_line_amount INTO l_line_tax_amount;
2022: CLOSE c_extwar_line_amount;
2023:
2024: -- Update the topline with the tax amount
2025: UPDATE oks_k_lines_b
2026: SET tax_amount = l_line_tax_amount
2027: WHERE cle_id = l_lineid;
2028:
2029: -- Rollup the topline tax amount to header

Line 2328: -- UPDATE oks_k_lines_b

2324: -- FETCH c_extwar_line_amount INTO l_line_tax_amount;
2325: -- CLOSE c_extwar_line_amount;
2326: --
2327: -- -- Update the topline with the tax amount
2328: -- UPDATE oks_k_lines_b
2329: -- SET tax_amount = l_line_tax_amount
2330: -- WHERE cle_id = l_lineid;
2331: --
2332: -- -- Rollup the topline tax amount to header