eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 44: FROM okl_trx_contracts_all bkg_trx

40: FROM
41: (
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'

Line 77: FROM okl_trx_contracts_all term_trx

73: -- after the Report Start Date
74: -- Contract should not have occurbe before the Report Start Date
75: AND p_start_date <=
76: nvl( ( SELECT max(transaction_date) last_trm_trx_date
77: FROM okl_trx_contracts_all term_trx
78: WHERE term_trx.khr_id = a.contract_id
79: AND term_trx.tcn_type ='TMT'
80: AND trn_code = 'EXP'
81: ),

Line 641: FROM okl_trx_contracts_all trx

637: -- Occurance date of the Transaction, not the Transaction Effective Date
638: ,trx.transaction_date trx_occ_date
639: ,trx.date_accrual accrual_date
640: ,'Lease' source
641: FROM okl_trx_contracts_all trx
642: ,okl_txl_cntrct_lns_all txl
643: ,okl_trns_acc_dstrs_all dist
644: ,okl_trx_types_v try
645: ,okl_strm_type_v sty

Line 753: FROM okl_trx_contracts_all trx

749: -- Occurance date of the Transaction, not the Transaction Effective Date
750: ,trx.transaction_date trx_occ_date
751: ,trx.date_accrual accrual_date
752: ,'Lease' source
753: FROM okl_trx_contracts_all trx
754: ,okl_txl_cntrct_lns_all txl
755: ,okl_trns_acc_dstrs_all dist
756: ,okl_trx_types_v try
757: ,okl_strm_type_v sty

Line 873: FROM okl_trx_contracts_all trx

869: -- Occurance date of the Transaction, not the Transaction Effective Date
870: ,trx.transaction_date trx_occ_date
871: ,trx.date_accrual accrual_date
872: ,'Lease' source
873: FROM okl_trx_contracts_all trx
874: ,okl_txl_cntrct_lns_all txl
875: ,okl_trns_acc_dstrs_all dist
876: ,okl_trx_types_v try
877: ,okl_strm_type_v sty

Line 1016: FROM okl_trx_contracts_all trx

1012: -- Occurance date of the Transaction, not the Transaction Effective Date
1013: ,trx.transaction_date trx_occ_date
1014: ,trx.date_accrual accrual_date
1015: ,'Lease' source
1016: FROM okl_trx_contracts_all trx
1017: ,okl_txl_cntrct_lns_all txl
1018: ,okl_trns_acc_dstrs_all dist
1019: ,okl_trx_types_v try
1020: ,okl_strm_type_v sty

Line 4018: ,okl_trx_contracts_all trx

4014: ,xla_event_types_vl xvl
4015: -- OLM Entities
4016: ,okl_trns_acc_dstrs_all dist
4017: ,okl_txl_cntrct_lns_all txl
4018: ,okl_trx_contracts_all trx
4019: ,okl_trx_types_v try
4020: ,okl_strm_type_v sty
4021: ,okc_k_headers_all_b chr
4022: ,okl_k_headers khr

Line 6254: FROM OKL_TRX_CONTRACTS_ALL TCN,

6250: FROM gl_ledgers gl
6251: WHERE ledger_id = p_ledger_id)
6252: ) TRANSACTION_PERIOD,
6253: NULL REVERSAL_PERIOD
6254: FROM OKL_TRX_CONTRACTS_ALL TCN,
6255: OKL_TXL_CNTRCT_LNS_ALL TCL,
6256: OKL_TRX_TYPES_V TTY,
6257: OKL_STRM_TYPE_V STY,
6258: HR_OPERATING_UNITS OU,

Line 6272: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX

6268: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)
6269: AND TCN.ACCRUAL_ACTIVITY <> 'REVERSAL'
6270: AND OU.ORGANIZATION_ID = TCN.ORG_ID
6271: AND NVL(TCN.SOURCE_TRX_ID,-1) NOT IN (SELECT ID
6272: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX
6273: WHERE RBK_TRX.KHR_ID = TCN.KHR_ID
6274: AND RBK_TRX.ID = TCN.SOURCE_TRX_ID
6275: AND TCN_TYPE in('TRBK','ALT'))
6276:

Line 6325: FROM OKL_TRX_CONTRACTS_ALL TCN,

6321: AND period_type = (SELECT gl.accounted_period_type
6322: FROM gl_ledgers gl
6323: WHERE ledger_id = p_ledger_id)
6324: ) REVERSAL_PERIOD
6325: FROM OKL_TRX_CONTRACTS_ALL TCN,
6326: OKL_TXL_CNTRCT_LNS_ALL TCL,
6327: OKL_TRX_TYPES_V TTY,
6328: OKL_STRM_TYPE_V STY,
6329: HR_OPERATING_UNITS OU,

Line 6343: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX

6339: AND TTY.ID IN (SELECT TRY_ID FROM OKL_REPORT_TRX_PARAMS where report_id = p_report_id)
6340: AND TCN.ACCRUAL_ACTIVITY = 'REVERSAL'
6341: AND OU.ORGANIZATION_ID = TCN.ORG_ID
6342: AND NVL(TCN.SOURCE_TRX_ID,-1) NOT IN (SELECT ID
6343: FROM OKL_TRX_CONTRACTS_ALL RBK_TRX
6344: WHERE RBK_TRX.KHR_ID = TCN.KHR_ID
6345: AND RBK_TRX.ID = TCN.SOURCE_TRX_ID
6346: AND TCN_TYPE in ('TRBK','ALT'))
6347: )

Line 6387: okl_trx_contracts_all rbk_trx,

6383: Okc_k_lines_v kle,
6384: hr_operating_units ou,
6385: okl_products prod,
6386: okl_k_headers chr,
6387: okl_trx_contracts_all rbk_trx,
6388: okl_trx_contracts_all acc_trx,
6389: okl_rep_products_gt pdt_gt,
6390: OKL_TRX_TYPES_V TTY
6391: WHERE c.Link_Hist_Stream_Id = p.Id

Line 6388: okl_trx_contracts_all acc_trx,

6384: hr_operating_units ou,
6385: okl_products prod,
6386: okl_k_headers chr,
6387: okl_trx_contracts_all rbk_trx,
6388: okl_trx_contracts_all acc_trx,
6389: okl_rep_products_gt pdt_gt,
6390: OKL_TRX_TYPES_V TTY
6391: WHERE c.Link_Hist_Stream_Id = p.Id
6392: AND c.Sty_Id = st.Id

Line 7211: ,okl_trx_contracts_all trx

7207: ,xla_event_types_vl xvl
7208: -- OLM Entities
7209: ,okl_trns_acc_dstrs_all dist
7210: ,okl_txl_cntrct_lns_all txl
7211: ,okl_trx_contracts_all trx
7212: ,okl_trx_types_v try
7213: ,okl_strm_type_v sty
7214: ,okc_k_headers_all_b chr
7215: ,okl_k_headers khr