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_CONS_BILL dependencies on OKL_EXT_SELL_INVS_V

Line 997: l_legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

993:
994: l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE;
995: l_cnr_amount okl_cnsld_ar_hdrs_v.amount%TYPE;
996: l_lln_amount okl_cnsld_ar_lines_v.amount%TYPE;
997: l_legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
998:
999: l_update_tbl update_tbl_type;
1000:
1001: l_kle_id NUMBER;

Line 1581: okl_ext_sell_invs_v xsi,

1577: --vthiruva added for bug#4438971 fix..24-JUN-2005
1578: ,xsi.inf_id inf_id
1579: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1580: FROM
1581: okl_ext_sell_invs_v xsi,
1582: okl_xtl_sell_invs_v xls,
1583: okl_txd_ar_ln_dtls_v tld,
1584: okl_txl_ar_inv_lns_v til,
1585: okl_trx_ar_invoices_v tai,

Line 1635: okl_ext_sell_invs_v xsi,

1631: --vthiruva added for bug#4438971 fix..24-JUN-2005
1632: ,xsi.inf_id inf_id
1633: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1634: FROM
1635: okl_ext_sell_invs_v xsi,
1636: okl_xtl_sell_invs_v xls,
1637: okl_txl_ar_inv_lns_v til,
1638: okl_trx_ar_invoices_v tai,
1639: okc_k_headers_b chr,

Line 1684: okl_ext_sell_invs_v xsi,

1680: --vthiruva added for bug#4438971 fix..24-JUN-2005
1681: ,xsi.inf_id inf_id
1682: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1683: FROM
1684: okl_ext_sell_invs_v xsi,
1685: okl_xtl_sell_invs_v xls,
1686: okl_txl_ar_inv_lns_v til,
1687: okl_trx_ar_invoices_v tai,
1688: okc_k_headers_b chr,

Line 1727: FROM okl_ext_sell_invs_v xsi,

1723: xls.id xls_id,
1724: xls.amount cm2_amount,
1725: xls.sel_id sel_id,
1726: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1727: FROM okl_ext_sell_invs_v xsi,
1728: okl_xtl_sell_invs_b xls,
1729: okl_txl_ar_inv_lns_b til,
1730: okl_trx_ar_invoices_b tai,
1731: okc_k_headers_all_b CHR,

Line 1767: FROM okl_ext_sell_invs_v xsi,

1763: xls.id xls_id,
1764: xls.amount cm2_amount,
1765: xls.sel_id sel_id,
1766: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1767: FROM okl_ext_sell_invs_v xsi,
1768: okl_ext_sell_invs_v xsir,
1769: okl_xtl_sell_invs_b xls,
1770: okl_xtl_sell_invs_b xlsr,
1771: okl_txl_ar_inv_lns_b til,

Line 1768: okl_ext_sell_invs_v xsir,

1764: xls.amount cm2_amount,
1765: xls.sel_id sel_id,
1766: xsi.legal_entity_id legal_entity_id --FOR le uptake project 8 -11 -2006
1767: FROM okl_ext_sell_invs_v xsi,
1768: okl_ext_sell_invs_v xsir,
1769: okl_xtl_sell_invs_b xls,
1770: okl_xtl_sell_invs_b xlsr,
1771: okl_txl_ar_inv_lns_b til,
1772: okl_trx_ar_invoices_b tai,

Line 1814: okl_ext_sell_invs_v xsi,

1810: xls.amount cm3_amount,
1811: xls.sel_id sel_id
1812: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1813: FROM
1814: okl_ext_sell_invs_v xsi,
1815: okl_xtl_sell_invs_v xls,
1816: okl_txd_ar_ln_dtls_v tld,
1817: okl_txl_ar_inv_lns_v til,
1818: okl_trx_ar_invoices_v tai,

Line 1859: okl_ext_sell_invs_v xsi,

1855: xls.amount cm3_amount,
1856: xls.sel_id sel_id
1857: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1858: FROM
1859: okl_ext_sell_invs_v xsi,
1860: okl_ext_sell_invs_v xsir,
1861: okl_xtl_sell_invs_v xls,
1862: okl_xtl_sell_invs_v xlsr,
1863: okl_txd_ar_ln_dtls_v tld,

Line 1860: okl_ext_sell_invs_v xsir,

1856: xls.sel_id sel_id
1857: ,xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
1858: FROM
1859: okl_ext_sell_invs_v xsi,
1860: okl_ext_sell_invs_v xsir,
1861: okl_xtl_sell_invs_v xls,
1862: okl_xtl_sell_invs_v xlsr,
1863: okl_txd_ar_ln_dtls_v tld,
1864: okl_txl_ar_inv_lns_v til,

Line 2006: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;

2002: -- Declare variables required by Termination Quote Billing
2003: ------------------------------------------------------------
2004: l_qte_id NUMBER := -1;
2005:
2006: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;
2007: ------------------------------------------------------------
2008: -- Declare variables required by Collections Billing
2009: ------------------------------------------------------------
2010: l_cpy_id NUMBER := -1;