DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on OKL_TRX_TYPES_V

Line 644: ,okl_trx_types_v try

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
646: ,okc_k_headers_all_b chr
647: ,okl_k_headers khr
648: ,okl_products pdt

Line 756: ,okl_trx_types_v try

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
758: ,okc_k_headers_all_b chr
759: ,okl_k_headers khr
760: ,okl_products pdt

Line 876: ,okl_trx_types_v try

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
878: ,okc_k_headers_all_b chr
879: ,okl_k_headers khr
880: ,okl_products pdt

Line 1019: ,okl_trx_types_v try

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
1021: ,okc_k_headers_all_b chr
1022: ,okl_k_headers khr
1023: ,okl_products pdt

Line 1266: ,okl_trx_types_v try

1262: ,okl_k_headers khr
1263: ,okl_products pdt
1264: ,okl_ae_tmpt_sets_all aes
1265: ,okl_st_gen_tmpt_sets_all gts
1266: ,okl_trx_types_v try
1267: ,okl_strm_type_v sty
1268: -- OLM Reconciliation Report Entities
1269: ,okl_reports_b rep
1270: ,okl_report_trx_params rtryp

Line 1386: ,okl_trx_types_v try

1382: ,okl_k_headers khr
1383: ,okl_products pdt
1384: ,okl_ae_tmpt_sets_all aes
1385: ,okl_st_gen_tmpt_sets_all gts
1386: ,okl_trx_types_v try
1387: ,okl_strm_type_v sty
1388: -- AR Tables
1389: ,ra_customer_trx_lines_all rcl
1390: ,ra_customer_trx_all rct

Line 1510: ,okl_trx_types_v try

1506: ,okl_k_headers khr
1507: ,okl_products pdt
1508: ,okl_ae_tmpt_sets_all aes
1509: ,okl_st_gen_tmpt_sets_all gts
1510: ,okl_trx_types_v try
1511: ,okl_strm_type_v sty
1512: -- AR Tables
1513: ,ra_customer_trx_lines_all rcl
1514: ,ra_customer_trx_all rct

Line 1661: ,okl_trx_types_v try

1657: ,okl_k_headers khr
1658: ,okl_products pdt
1659: ,okl_ae_tmpt_sets_all aes
1660: ,okl_st_gen_tmpt_sets_all gts
1661: ,okl_trx_types_v try
1662: ,okl_strm_type_v sty
1663: -- AR Tables
1664: ,ra_customer_trx_lines_all rcl
1665: ,ra_customer_trx_all rct

Line 1917: ,okl_trx_types_v try

1913: ,okl_k_headers khr
1914: ,okl_products pdt
1915: ,okl_ae_tmpt_sets_all aes
1916: ,okl_st_gen_tmpt_sets_all gts
1917: ,okl_trx_types_v try
1918: ,okl_strm_type_v sty
1919: -- OLM Reconciliation Report Entities
1920: ,okl_reports_b rep
1921: ,okl_report_trx_params rtryp

Line 2018: ,okl_trx_types_v try

2014: ,okl_k_headers khr
2015: ,okl_products pdt
2016: ,okl_ae_tmpt_sets_all aes
2017: ,okl_st_gen_tmpt_sets_all gts
2018: ,okl_trx_types_v try
2019: ,okl_strm_type_v sty
2020: -- AR Tables
2021: ,ar_adjustments_all radj
2022: -- XLA Tables

Line 2138: ,okl_trx_types_v try

2134: ,okl_k_headers khr
2135: ,okl_products pdt
2136: ,okl_ae_tmpt_sets_all aes
2137: ,okl_st_gen_tmpt_sets_all gts
2138: ,okl_trx_types_v try
2139: ,okl_strm_type_v sty
2140: -- AR Tables
2141: ,ar_adjustments_all radj
2142: ,ar_distributions_all rdist

Line 2288: ,okl_trx_types_v try

2284: ,okl_k_headers khr
2285: ,okl_products pdt
2286: ,okl_ae_tmpt_sets_all aes
2287: ,okl_st_gen_tmpt_sets_all gts
2288: ,okl_trx_types_v try
2289: ,okl_strm_type_v sty
2290: -- AR Tables
2291: ,ar_adjustments_all radj
2292: ,ar_distributions_all rdist

Line 2534: ,okl_trx_types_v try

2530: ,okl_k_headers khr
2531: ,okl_products pdt
2532: ,okl_ae_tmpt_sets_all aes
2533: ,okl_st_gen_tmpt_sets_all gts
2534: ,okl_trx_types_v try
2535: ,okl_strm_type_v sty
2536: -- OLM Reconciliation Report Entities
2537: ,okl_reports_b rep
2538: ,okl_report_trx_params rtryp

Line 2651: ,okl_trx_types_v try

2647: ,okl_k_headers khr
2648: ,okl_products pdt
2649: ,okl_ae_tmpt_sets_all aes
2650: ,okl_st_gen_tmpt_sets_all gts
2651: ,okl_trx_types_v try
2652: ,okl_strm_type_v sty
2653: -- AP Tables
2654: ,ap_invoices_all inv
2655: ,ap_invoice_lines_all lin

Line 2785: ,okl_trx_types_v try

2781: ,okl_k_headers khr
2782: ,okl_products pdt
2783: ,okl_ae_tmpt_sets_all aes
2784: ,okl_st_gen_tmpt_sets_all gts
2785: ,okl_trx_types_v try
2786: ,okl_strm_type_v sty
2787: -- AP Tables
2788: ,ap_invoices_all inv
2789: ,ap_invoice_lines_all lin

Line 2946: ,okl_trx_types_v try

2942: ,okl_k_headers khr
2943: ,okl_products pdt
2944: ,okl_ae_tmpt_sets_all aes
2945: ,okl_st_gen_tmpt_sets_all gts
2946: ,okl_trx_types_v try
2947: ,okl_strm_type_v sty
2948: -- AP Tables
2949: ,ap_invoices_all inv
2950: ,ap_invoice_lines_all lin

Line 4019: ,okl_trx_types_v try

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
4023: ,okl_products pdt

Line 4247: ,okl_trx_types_v try

4243: ,okl_k_headers khr
4244: ,okl_products pdt
4245: ,okl_ae_tmpt_sets_all aes
4246: ,okl_st_gen_tmpt_sets_all gts
4247: ,okl_trx_types_v try
4248: ,okl_strm_type_v sty
4249: -- To fetch Names
4250: ,hr_operating_units ou
4251: ,gl_ledgers ledger

Line 4470: ,okl_trx_types_v try

4466: ,okl_k_headers khr
4467: ,okl_products pdt
4468: ,okl_ae_tmpt_sets_all aes
4469: ,okl_st_gen_tmpt_sets_all gts
4470: ,okl_trx_types_v try
4471: ,okl_strm_type_v sty
4472: -- To fetch Names
4473: ,hr_operating_units ou
4474: ,gl_ledgers ledger

Line 4692: ,okl_trx_types_v try

4688: ,okl_k_headers khr
4689: ,okl_products pdt
4690: ,okl_ae_tmpt_sets_all aes
4691: ,okl_st_gen_tmpt_sets_all gts
4692: ,okl_trx_types_v try
4693: ,okl_strm_type_v sty
4694: -- To fetch Names
4695: ,hr_operating_units ou
4696: ,gl_ledgers ledger

Line 6256: OKL_TRX_TYPES_V TTY,

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,
6259: OKC_K_LINES_V CLE
6260: WHERE TCN.ID = TCL.TCN_ID

Line 6327: OKL_TRX_TYPES_V TTY,

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,
6330: OKC_K_LINES_V CLE
6331: WHERE TCN.ID = TCL.TCN_ID

Line 6390: OKL_TRX_TYPES_V TTY

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
6393: AND c.Date_Current >= p.Date_Current
6394: AND c.kle_Id = p.kle_Id

Line 7212: ,okl_trx_types_v try

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
7216: ,okl_products pdt