DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_PRODUCTS

Line 4741: okl_products pdt,

4737: glv.concatenated_segments
4738: FROM okl_ae_tmpt_lnes aetl,
4739: okl_ae_templates aet,
4740: okl_ae_tmpt_sets aes,
4741: okl_products pdt,
4742: okl_trx_types_b trx,
4743: gl_code_combinations_kfv glv
4744: WHERE aetl.avl_id = aet.id
4745: AND aet.aes_id = aes.id

Line 4788: l_pdt_id okl_products.id%TYPE;

4784: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
4785: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
4786: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
4787: l_auth_org_id okc_k_headers_all_b.authoring_org_id%TYPE;
4788: l_pdt_id okl_products.id%TYPE;
4789: l_aes_id okl_products.aes_id%TYPE;
4790: l_chart_of_accounts_id NUMBER;
4791: l_instr_assignment_id NUMBER;
4792: l_ext_receipt_method_name okx_receipt_methods_v.name%TYPE;

Line 4789: l_aes_id okl_products.aes_id%TYPE;

4785: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
4786: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
4787: l_auth_org_id okc_k_headers_all_b.authoring_org_id%TYPE;
4788: l_pdt_id okl_products.id%TYPE;
4789: l_aes_id okl_products.aes_id%TYPE;
4790: l_chart_of_accounts_id NUMBER;
4791: l_instr_assignment_id NUMBER;
4792: l_ext_receipt_method_name okx_receipt_methods_v.name%TYPE;
4793: l_ext_line_receipt_method_name okx_receipt_methods_v.name%TYPE;