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 851: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented

847: FROM okc_k_headers_b khr
848: WHERE id in (
849: SELECT TAI.khr_id -- rmunjulu R12 fixes - changed to TAI
850: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented
851: --okl_xtl_sell_invs_b xls, -- rmunjulu R12 fixes - commented
852: --okl_txd_ar_ln_dtls_b tld,-- rmunjulu R12 fixes - commented
853: --okl_txl_ar_inv_lns_b til,-- rmunjulu R12 fixes - commented
854: okl_trx_ar_invoices_b tai,
855: okc_k_headers_b chr-- rmunjulu R12 fixes - commented

Line 878: okl_xtl_sell_invs_b xls,

874: FROM okc_k_headers_b khr
875: WHERE id in (
876: SELECT chr.id
877: FROM okl_ext_sell_invs_b xsi,
878: okl_xtl_sell_invs_b xls,
879: okl_txl_ar_inv_lns_b til,
880: okl_trx_ar_invoices_b tai,
881: okc_k_headers_b chr
882: WHERE XSI.TRX_STATUS_CODE = 'WORKING'

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

1047: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1048: COUNT(*) LINE_COUNT
1049: FROM
1050: --OKL_EXT_SELL_INVS_B XSI, -- rmunjulu R12 fixes - commented
1051: --OKL_XTL_SELL_INVS_B XLS, -- rmunjulu R12 fixes - commented
1052: --OKL_TXD_AR_LN_DTLS_B TLD, -- rmunjulu R12 fixes - commented
1053: --OKL_TXL_AR_INV_LNS_B TIL, -- rmunjulu R12 fixes - commented
1054: OKL_TRX_AR_INVOICES_B TAI,
1055: OKC_K_HEADERS_B KHR,

Line 3003: update okl_xtl_sell_invs_b

2999: PRINT_TO_LOG('Performing bulk update for xls, record count is '||g_xls_tbl.COUNT );
3000: BEGIN
3001: savepoint U2;
3002: for s in g_xls_tbl.first..g_xls_tbl.last loop
3003: update okl_xtl_sell_invs_b
3004: set lsm_id = g_xls_tbl(s).lsm_id,
3005: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
3006: last_update_date = sysdate,
3007: last_updated_by = fnd_global.user_id,

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

3009: where id = g_xls_tbl(s).id;
3010: end loop;
3011: EXCEPTION
3012: WHEN OTHERS THEN
3013: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U2');
3014: rollback to U2;
3015: RAISE;
3016: END;
3017: commit;

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 3912: okl_xtl_sell_invs_b xls,

3908: xsib.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3909: FROM
3910: okl_ext_sell_invs_b xsib,
3911: okl_ext_sell_invs_tl xsit,
3912: okl_xtl_sell_invs_b xls,
3913: okl_txd_ar_ln_dtls_b tld,
3914: okl_txl_ar_inv_lns_b til,
3915: okl_trx_ar_invoices_b tai,
3916: okc_k_headers_b chr,

Line 4641: update okl_xtl_sell_invs_b

4637: PRINT_TO_LOG('Performing final bulk update for xls, record count is '||g_xls_tbl.COUNT );
4638: BEGIN
4639: savepoint U6;
4640: for s in g_xls_tbl.first..g_xls_tbl.last loop
4641: update okl_xtl_sell_invs_b
4642: set lsm_id = g_xls_tbl(s).lsm_id,
4643: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
4644: last_update_date = sysdate,
4645: last_updated_by = fnd_global.user_id,

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

4651: g_xls_tbl.delete;
4652: g_xls_counter := 0;
4653: EXCEPTION
4654: WHEN OTHERS THEN
4655: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');
4656: rollback to U6;
4657: RAISE;
4658: END;
4659: end if;

Line 5146: update okl_xtl_sell_invs_b

5142: PRINT_TO_LOG('Performing final bulk update for xls, record count is '||g_xls_tbl.COUNT );
5143: BEGIN
5144: savepoint U6;
5145: for s in g_xls_tbl.first..g_xls_tbl.last loop
5146: update okl_xtl_sell_invs_b
5147: set lsm_id = g_xls_tbl(s).lsm_id,
5148: xtrx_cons_stream_id = g_xls_tbl(s).lsm_id,
5149: last_update_date = sysdate,
5150: last_updated_by = fnd_global.user_id,

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

5156: g_xls_tbl.delete;
5157: g_xls_counter := 0;
5158: EXCEPTION
5159: WHEN OTHERS THEN
5160: PRINT_TO_LOG('Error during Update of okl_xtl_sell_invs_b, rollback to U6');
5161: rollback to U6;
5162: RAISE;
5163: END;
5164: end if;