APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_TRX_TYPES_V

Line 105: , okl_trx_types_v try

101: SELECT try.name try_name,
102: tpl.sty_id
103: FROM okl_txl_ap_inv_lns_b tpl
104: , okl_trx_ap_invoices_b tap
105: , okl_trx_types_v try
106: WHERE tpl.id = p_tpl_id
107: AND tpl.tap_id = tap.id
108: AND tap.try_id = try.id;
109:

Line 134: , okl_trx_types_v try

130: -- , try.name try_name -- cklee 06/19/2007
131: FROM OKC_K_LINES_B kle
132: , okl_txl_ap_inv_lns_b tpl
133: , okl_trx_ap_invoices_b tap
134: , okl_trx_types_v try
135: WHERE tpl.id = p_tpl_id
136: AND tpl.kle_id = kle.id
137: AND tpl.tap_id = tap.id
138: AND tap.try_id = try.id;

Line 246: l_try_name okl_trx_types_v.name%type;

242: l_install_location_type_code csi_item_instances.install_location_type_code%type; -- 07-May-2008 cklee -- Fixed bug:7015970
243: l_customer_id NUMBER;
244: l_sts_code okc_k_headers_all_b.sts_code%type; -- 07-May-2008 cklee -- Fixed bug:7015970
245: l_ship_to NUMBER;
246: l_try_name okl_trx_types_v.name%type;
247:
248: --Get the inventory for a financial asset line or service line.
249: --A line can either be a fin asset or service line
250: CURSOR get_inv_item_id ( p_cle_id NUMBER ) IS