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 850: FROM --okl_ext_sell_invs_b xsi, -- rmunjulu R12 fixes - commented

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

Line 877: FROM okl_ext_sell_invs_b xsi,

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

Line 900: FROM OKL_EXT_SELL_INVS_B ext

896: -- rmunjulu R12 Fixes -- comment out Consolidation
897: /*
898: UNION
899: SELECT to_char(CUSTOMER_ID), null khr_id
900: FROM OKL_EXT_SELL_INVS_B ext
901: WHERE ext.TRX_STATUS_CODE = 'SUBMITTED'
902: AND p_source = 'CONSOLIDATION'
903: AND NOT EXISTS
904: (SELECT '1'

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

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

Line 1102: OKL_EXT_SELL_INVS_B EXT,

1098: SELECT
1099: TO_CHAR(CUSTOMER_ID) CONTRACT_NUMBER,
1100: COUNT(*)
1101: FROM
1102: OKL_EXT_SELL_INVS_B EXT,
1103: OKL_PARALLEL_PROCESSES OPP
1104: WHERE
1105: EXT.TRX_STATUS_CODE = 'SUBMITTED' AND
1106: OPP.OBJECT_VALUE = EXT.CUSTOMER_ID AND

Line 2978: update okl_ext_sell_invs_b

2974: BEGIN
2975: savepoint U1;
2976: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
2977: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
2978: update okl_ext_sell_invs_b
2979: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
2980: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
2981: last_update_date = sysdate,
2982: last_updated_by = fnd_global.user_id,

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

2984: where id = g_xsi_tbl(indx).id;
2985: end loop;
2986: EXCEPTION
2987: WHEN OTHERS THEN
2988: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U1');
2989: rollback to U1;
2990: RAISE;
2991: END;
2992: commit;

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 3910: okl_ext_sell_invs_b xsib,

3906: xls.amount c_amount,
3907: xls.sel_id sel_id,
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,

Line 4615: update okl_ext_sell_invs_b

4611: BEGIN
4612: savepoint U5;
4613: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
4614: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
4615: update okl_ext_sell_invs_b
4616: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
4617: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
4618: last_update_date = sysdate,
4619: last_updated_by = fnd_global.user_id,

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

4625: g_xsi_tbl.delete;
4626: g_xsi_counter := 0;
4627: EXCEPTION
4628: WHEN OTHERS THEN
4629: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');
4630: rollback to U5;
4631: RAISE;
4632: END;
4633: end if;

Line 5119: update okl_ext_sell_invs_b

5115: BEGIN
5116: savepoint U5;
5117: for indx in g_xsi_tbl.first..g_xsi_tbl.last loop
5118: -- rseela BUG#4733028 removed the updation of xtrx_invoice_pull_yn
5119: update okl_ext_sell_invs_b
5120: set trx_status_code = g_xsi_tbl(indx).trx_status_code,
5121: -- xtrx_invoice_pull_yn = g_xsi_tbl(indx).xtrx_invoice_pull_yn,
5122: last_update_date = sysdate,
5123: last_updated_by = fnd_global.user_id,

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

5129: g_xsi_tbl.delete;
5130: g_xsi_counter := 0;
5131: EXCEPTION
5132: WHEN OTHERS THEN
5133: PRINT_TO_LOG('Error during Update of okl_ext_sell_invs_b, rollback to U5');
5134: rollback to U5;
5135: RAISE;
5136: END;
5137: end if;