DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKL_RCPT_CONSINV_BALANCES_UV

Line 168: FROM okl_rcpt_consinv_balances_uv

164: cp_org_id NUMBER,
165: cp_customer_num VARCHAR2,
166: cp_currency_code VARCHAR2) IS
167: SELECT CURRENCY_CODE
168: FROM okl_rcpt_consinv_balances_uv
169: WHERE consolidated_invoice_number = cp_cons_invoice_number
170: --commented for bug 5391874
171: -- AND customer_account_number = cp_customer_num
172: AND org_id = cp_org_id

Line 181: -- FROM okl_rcpt_consinv_balances_uv -- incorrect view .. bug 7018894

177: cp_org_id NUMBER,
178: cp_customer_num VARCHAR2,
179: cp_currency_code VARCHAR2) IS
180: SELECT CURRENCY_CODE
181: -- FROM okl_rcpt_consinv_balances_uv -- incorrect view .. bug 7018894
182: FROM okl_rcpt_cust_cont_balances_uv
183: WHERE contract_number = cp_contract_number
184: --commented for bug 5391874
185: -- AND customer_account_number = cp_customer_num