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_EXT_SELL_INVS_B

Line 838: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented

834: SELECT khr.contract_number contract_number, khr.id khr_id
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,

Line 865: FROM okl_ext_sell_invs_b xsi,

861: SELECT khr.contract_number contract_number, khr.id khr_id
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

Line 888: FROM OKL_EXT_SELL_INVS_B ext

884: -- rmunjulu R12 Fixes -- comment out Consolidation
885: /*
886: UNION
887: SELECT to_char(CUSTOMER_ID), null khr_id
888: FROM OKL_EXT_SELL_INVS_B ext
889: WHERE ext.TRX_STATUS_CODE = 'SUBMITTED'
890: AND p_source = 'CONSOLIDATION'
891: AND NOT EXISTS
892: (SELECT '1'

Line 1013: --OKL_EXT_SELL_INVS_B XSI, -- rmunjulu R12 fixes - commented

1009: SELECT
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,

Line 1065: OKL_EXT_SELL_INVS_B EXT,

1061: SELECT
1062: TO_CHAR(CUSTOMER_ID) CONTRACT_NUMBER,
1063: COUNT(*)
1064: FROM
1065: OKL_EXT_SELL_INVS_B EXT,
1066: OKL_PARALLEL_PROCESSES OPP
1067: WHERE
1068: EXT.TRX_STATUS_CODE = 'SUBMITTED' AND
1069: OPP.OBJECT_VALUE = EXT.CUSTOMER_ID AND

Line 2914: update okl_ext_sell_invs_b

2910: BEGIN
2911: savepoint U1;
2912: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
2913: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
2914: update okl_ext_sell_invs_b
2915: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2916: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2917: last_update_date = sysdate,
2918: last_updated_by = fnd_global.user_id,

Line 2924: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U1');

2920: where id = g_xsi_tbl(indx).id;
2921: end loop;
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U1');
2925: rollback to U1;
2926: RAISE;
2927: END;
2928: commit;

Line 3782: okl_ext_sell_invs_b xsib,

3778: xls.amount c_amount,
3779: xls.sel_id sel_id,
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,

Line 3846: okl_ext_sell_invs_b xsib,

3842: xls.amount c_amount,
3843: xls.sel_id sel_id,
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,

Line 4551: update okl_ext_sell_invs_b

4547: BEGIN
4548: savepoint U5;
4549: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
4550: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
4551: update okl_ext_sell_invs_b
4552: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4553: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4554: last_update_date = sysdate,
4555: last_updated_by = fnd_global.user_id,

Line 4565: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');

4561: g_xsi_tbl.delete;
4562: g_xsi_counter := 0;
4563: EXCEPTION
4564: WHEN OTHERS THEN
4565: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');
4566: rollback to U5;
4567: RAISE;
4568: END;
4569: end if;

Line 5055: update okl_ext_sell_invs_b

5051: BEGIN
5052: savepoint U5;
5053: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
5054: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
5055: update okl_ext_sell_invs_b
5056: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5057: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5058: last_update_date = sysdate,
5059: last_updated_by = fnd_global.user_id,

Line 5069: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');

5065: g_xsi_tbl.delete;
5066: g_xsi_counter := 0;
5067: EXCEPTION
5068: WHEN OTHERS THEN
5069: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');
5070: rollback to U5;
5071: RAISE;
5072: END;
5073: end if;