DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_PRODUCTS

Line 4742: okl_products pdt,

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

Line 4789: l_pdt_id okl_products.id%TYPE;

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

Line 4790: l_aes_id okl_products.aes_id%TYPE;

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