DBA Data[Home] [Help]

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_EXT_SELL_INVS_V

Line 1076: OKL_EXT_SELL_INVS_V XSI,

1072: SELECT
1073: KHR.CONTRACT_NUMBER CONTRACT_NUMBER,
1074: COUNT(*) LINE_COUNT
1075: FROM
1076: OKL_EXT_SELL_INVS_V XSI,
1077: OKL_XTL_SELL_INVS_V XLS,
1078: OKL_TXL_AR_INV_LNS_V TIL,
1079: OKL_TRX_AR_INVOICES_V TAI,
1080: OKC_K_HEADERS_B KHR,

Line 3976: okl_ext_sell_invs_v xsi,

3972: xls.amount c1_amount,
3973: xls.sel_id sel_id,
3974: xsi.legal_entity_id legal_entity_id -- for LE Uptake project 08-11-2006
3975: FROM
3976: okl_ext_sell_invs_v xsi,
3977: okl_xtl_sell_invs_v xls,
3978: okl_txl_ar_inv_lns_v til,
3979: okl_trx_ar_invoices_v tai,
3980: okc_k_headers_b chr,

Line 4097: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;

4093: -- Declare variables required by Termination Quote Billing
4094: ------------------------------------------------------------
4095: l_qte_id NUMBER := -1;
4096:
4097: l_qte_cust_id okl_ext_sell_invs_v.Customer_id%TYPE;
4098: ------------------------------------------------------------
4099: -- Declare variables required by Collections Billing
4100: ------------------------------------------------------------
4101: l_cpy_id NUMBER := -1;