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_BILLING_PUB dependencies on OKS_BSD_PR

Line 678: oks_bsd_pr bsd

674: rline.dnz_chr_id
675: FROM
676: oks_k_lines_b rline,
677: oks_bsl_pr bsl,
678: oks_bsd_pr bsd
679: WHERE bsl.bcl_id = p_bcl_id
680: AND bsl.id = bsd.bsl_id
681: AND rline.cle_id = bsl.cle_id
682: AND p_prv = 2;

Line 1501: Delete from OKS_BSD_PR

1497: (select level_coverage_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1498:
1499: Else
1500:
1501: Delete from OKS_BSD_PR
1502: where bsl_id in
1503: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1504:
1505: Delete from OKS_BSL_PR

Line 3699: oks_bsd_pr bsd

3695: rline.dnz_chr_id
3696: FROM
3697: oks_k_lines_b rline,
3698: oks_bsl_pr bsl,
3699: oks_bsd_pr bsd
3700: WHERE bsl.bcl_id = p_bcl_id
3701: AND bsl.id = bsd.bsl_id
3702: AND rline.cle_id = bsl.cle_id
3703: AND p_prv = 2;