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_BILLING_CONTROLLER_PVT dependencies on OKL_XTL_SELL_INVS_B

Line 839: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented

835: FROM okc_k_headers_b khr
836: WHERE id in (
837: SELECT TAI.khr_id -- rmunjulu R12 fixes - changed to TAI
838: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented
839: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented
840: --okl_txd_ar_ln_dtls_b tld,-- rmunjulu R12 fixes - commented
841: --okl_txl_ar_inv_lns_b til,-- rmunjulu R12 fixes - commented
842: okl_trx_ar_invoices_b tai,
843: okc_k_headers_b chr-- rmunjulu R12 fixes - commented

Line 866: okl_xtl_sell_invs_b xls,

862: FROM okc_k_headers_b khr
863: WHERE id in (
864: SELECT chr.id
865: FROM okl_ext_sell_invs_b xsi,
866: okl_xtl_sell_invs_b xls,
867: okl_txl_ar_inv_lns_b til,
868: okl_trx_ar_invoices_b tai,
869: okc_k_headers_b chr
870: WHERE XSI.TRX_STATUS_CODE = 'WORKING'

Line 1014: --OKL_XTL_SELL_INVS_B XLS, -- rmunjulu R12 fixes - commented

1010: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1011: COUNT(*) LINE_COUNT
1012: FROM
1013: --OKL_EXT_SELL_INVS_B XSI, -- rmunjulu R12 fixes - commented
1014: --OKL_XTL_SELL_INVS_B XLS, -- rmunjulu R12 fixes - commented
1015: --OKL_TXD_AR_LN_DTLS_B TLD, -- rmunjulu R12 fixes - commented
1016: --OKL_TXL_AR_INV_LNS_B TIL, -- rmunjulu R12 fixes - commented
1017: OKL_TRX_AR_INVOICES_B TAI,
1018: OKC_K_HEADERS_B KHR,

Line 2939: update okl_xtl_sell_invs_b

2935: PRINT_TO_LOG('Performing bulk update for xls, record count is '||g_xls_tbl.COUNT );
2936: BEGIN
2937: savepoint U2;
2938: for s in g_xls_tbl.first..g_xls_tbl.last loop
2939: update okl_xtl_sell_invs_b
2940: set lsm_id = g_xls_tbl(s).lsm_id,
2941: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
2942: last_update_date = sysdate,
2943: last_updated_by = fnd_global.user_id,

Line 2949: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U2');

2945: where id = g_xls_tbl(s).id;
2946: end loop;
2947: EXCEPTION
2948: WHEN OTHERS THEN
2949: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U2');
2950: rollback to U2;
2951: RAISE;
2952: END;
2953: commit;

Line 3784: okl_xtl_sell_invs_b xls,

3780: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3781: FROM
3782: okl_ext_sell_invs_b xsib,
3783: okl_ext_sell_invs_tl xsit,
3784: okl_xtl_sell_invs_b xls,
3785: okl_txd_ar_ln_dtls_b tld,
3786: okl_txl_ar_inv_lns_b til,
3787: okl_trx_ar_invoices_b tai,
3788: okc_k_headers_b chr,

Line 3848: okl_xtl_sell_invs_b xls,

3844: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3845: FROM
3846: okl_ext_sell_invs_b xsib,
3847: okl_ext_sell_invs_tl xsit,
3848: okl_xtl_sell_invs_b xls,
3849: okl_txd_ar_ln_dtls_b tld,
3850: okl_txl_ar_inv_lns_b til,
3851: okl_trx_ar_invoices_b tai,
3852: okc_k_headers_b chr,

Line 4577: update okl_xtl_sell_invs_b

4573: PRINT_TO_LOG('Performing final bulk update for xls, record count is '||g_xls_tbl.COUNT );
4574: BEGIN
4575: savepoint U6;
4576: for s in g_xls_tbl.first..g_xls_tbl.last loop
4577: update okl_xtl_sell_invs_b
4578: set lsm_id = g_xls_tbl(s).lsm_id,
4579: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4580: last_update_date = sysdate,
4581: last_updated_by = fnd_global.user_id,

Line 4591: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');

4587: g_xls_tbl.delete;
4588: g_xls_counter := 0;
4589: EXCEPTION
4590: WHEN OTHERS THEN
4591: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');
4592: rollback to U6;
4593: RAISE;
4594: END;
4595: end if;

Line 5082: update okl_xtl_sell_invs_b

5078: PRINT_TO_LOG('Performing final bulk update for xls, record count is '||g_xls_tbl.COUNT );
5079: BEGIN
5080: savepoint U6;
5081: for s in g_xls_tbl.first..g_xls_tbl.last loop
5082: update okl_xtl_sell_invs_b
5083: set lsm_id = g_xls_tbl(s).lsm_id,
5084: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5085: last_update_date = sysdate,
5086: last_updated_by = fnd_global.user_id,

Line 5096: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');

5092: g_xls_tbl.delete;
5093: g_xls_counter := 0;
5094: EXCEPTION
5095: WHEN OTHERS THEN
5096: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');
5097: rollback to U6;
5098: RAISE;
5099: END;
5100: end if;