APPS.OKL_ACCOUNTING_PROCESS_PVT dependencies on OKL_TRX_TYPES_V

Line 180: OKL_TRX_TYPES_V try

176: SELECT tcn.trx_number,
177: try.trx_type_class
178: FROM OKL_TXL_CNTRCT_LNS tcl,
179: OKL_TRX_CONTRACTS tcn,
180: OKL_TRX_TYPES_V try
181: WHERE tcl.id = v_source_id
182: AND tcl.tcn_id = tcn.id
183: AND tcn.try_id = try.id;
184:

Line 190: OKL_TRX_TYPES_V try

186: SELECT tas.trans_number,
187: try.trx_type_class
188: FROM OKL_TXL_ASSETS_B tal,
189: OKL_TRX_ASSETS tas,
190: OKL_TRX_TYPES_V try
191: WHERE tal.id = v_source_id
192: AND tal.tas_id = tas.id
193: AND tas.try_id = try.id;
194:

Line 223: l_trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE;

219:
220: l_event_type_code OKL_ACCOUNTING_EVENTS.EVENT_TYPE_CODE%TYPE;
221: l_event_rec_in AETV_REC_TYPE;
222: l_event_rec_out AETV_REC_TYPE;
223: l_trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE;
224: l_try_id NUMBER;
225: l_gl_date DATE;
226: l_tab_count NUMBER := 0;
227:

Line 535: l_trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE;

531:
532: TYPE ref_cursor IS REF CURSOR;
533: trx_csr ref_cursor;
534:
535: l_trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE;
536: l_ae_category OKL_AE_HEADERS.AE_CATEGORY%TYPE;
537: l_template_id NUMBER;
538: l_try_id NUMBER;
539: l_trx_number OKL_TRX_CONTRACTS.TRX_NUMBER%TYPE := p_trx_number;

Line 1070: okl_trx_types_v try,

1066: aeh.ae_category ae_category,
1067: ael.currency_code
1068: FROM okl_Ae_headers aeh,
1069: okl_ae_lines ael,
1070: okl_trx_types_v try,
1071: okl_txl_cntrct_lns tcl,
1072: okl_trx_contracts tcn
1073: WHERE aeh.ae_header_id=ael.ae_header_id
1074: AND aeh.accounting_error_code IS NULL

Line 1093: okl_trx_types_v try,

1089: aeh.ae_category ae_category,
1090: ael.currency_code
1091: FROM okl_Ae_headers aeh,
1092: okl_ae_lines ael,
1093: okl_trx_types_v try,
1094: okl_trx_assets tas,
1095: okl_txl_assets_b tal
1096: WHERE aeh.ae_header_id=ael.ae_header_id
1097: AND aeh.accounting_error_code IS NULL

Line 1149: okl_trx_types_v try

1145: ael.currency_code
1146: FROM
1147: okl_Ae_headers aeh,
1148: okl_ae_lines ael,
1149: okl_trx_types_v try
1150: WHERE
1151: aeh.request_id = p_request_id AND
1152: aeh.accounting_error_code IS NULL AND
1153: aeh.ae_header_id=ael.ae_header_id AND

Line 1175: okl_trx_types_v try,

1171: tcn.date_transaction_occurred transaction_date
1172: FROM
1173: okl_txl_cntrct_lns tcl,
1174: okl_trx_contracts tcn,
1175: okl_trx_types_v try,
1176: okc_k_headers_b khr
1177: WHERE
1178: tcl.id = p_source_id AND
1179: tcl.tcn_id = tcn.id AND

Line 1195: okl_trx_types_v try,

1191: tas.date_trans_occurred transaction_date
1192: FROM
1193: okl_txl_assets_b tal,
1194: okl_trx_assets tas,
1195: okl_trx_types_v try,
1196: okc_k_headers_b khr
1197: WHERE
1198: tal.id = p_source_id AND
1199: tal.tas_id = tas.id AND