APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_EXT_SELL_INVS_V

Line 1039: OKL_EXT_SELL_INVS_V XSI,

1035: SELECT
1036: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1037: COUNT(*) LINE_COUNT
1038: FROM
1039: OKL_EXT_SELL_INVS_V XSI,
1040: OKL_XTL_SELL_INVS_V XLS,
1041: OKL_TXL_AR_INV_LNS_V TIL,
1042: OKL_TRX_AR_INVOICES_V TAI,
1043: OKC_K_HEADERS_B KHR,

Line 3912: okl_ext_sell_invs_v xsi,

3908: xls.amount c1_amount,
3909: xls.sel_id sel_id,
3910: xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3911: FROM
3912: okl_ext_sell_invs_v xsi,
3913: okl_xtl_sell_invs_v xls,
3914: okl_txl_ar_inv_lns_v til,
3915: okl_trx_ar_invoices_v tai,
3916: okc_k_headers_b chr,

Line 4033: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;

4029: -- Declare variables required by Termination Quote Billing
4030: ------------------------------------------------------------
4031: l_qte_id NUMBER := -1;
4032:
4033: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;
4034: ------------------------------------------------------------
4035: -- Declare variables required by Collections Billing
4036: ------------------------------------------------------------
4037: l_cpy_id NUMBER := -1;