DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_TRX_TYPES_B

Line 46: ,okl_trx_types_b try

42: SELECT bkg_trx.khr_id contract_id
43: ,min(bkg_trx.transaction_date) bkg_transaction_date
44: FROM okl_trx_contracts_all bkg_trx
45: ,okl_k_headers khr
46: ,okl_trx_types_b try
47: ,okl_rep_products_gt pdt_gt
48: WHERE bkg_trx.tcn_type = 'BKG'
49: AND bkg_trx.try_id = try.id
50: AND try.trx_type_class = 'BOOKING'

Line 6022: okl_trx_types_b trx

6018: CURSOR C_STREAM_TYPES_NOT_SPECIFIED
6019: IS
6020: SELECT param.STY_ID
6021: FROM okl_report_trx_params param,
6022: okl_trx_types_b trx
6023: WHERE report_id = p_report_id
6024: AND trx.id = param.try_id
6025: AND trx.AEP_CODE = 'ACCRUAL'
6026: MINUS