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_TXL_AP_INV_LNS_ALL_B

Line 2527: okl_txl_ap_inv_lns_all_b tpl

2523: -- Occurance date of the Transaction, not the Transaction Effective Date
2524: ,tap.transaction_date trx_occ_date
2525: ,'Payables' source
2526: FROM
2527: okl_txl_ap_inv_lns_all_b tpl
2528: ,okl_trx_ap_invs_all_b tap
2529: ,okc_k_headers_all_b chr
2530: ,okl_k_headers khr
2531: ,okl_products pdt

Line 2644: okl_txl_ap_inv_lns_all_b tpl

2640: -- Occurance date of the Transaction, not the Transaction Effective Date
2641: ,tap.transaction_date trx_occ_date
2642: ,'Payables' source
2643: FROM
2644: okl_txl_ap_inv_lns_all_b tpl
2645: ,okl_trx_ap_invs_all_b tap
2646: ,okc_k_headers_all_b chr
2647: ,okl_k_headers khr
2648: ,okl_products pdt

Line 2701: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

2697: AND invdist.line_type_lookup_code = 'ITEM' -- Need to verify
2698: AND invdist.invoice_id = lin.invoice_id
2699: AND invdist.invoice_line_number = lin.line_number
2700: AND lin.application_id = 540
2701: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
2702: AND lin.reference_key1 = tpl.id
2703: AND lin.invoice_id = inv.invoice_id
2704: -- AP to XLA Relations
2705: AND invdist.accounting_event_id = xe.event_id

Line 2778: okl_txl_ap_inv_lns_all_b tpl

2774: -- Occurance date of the Transaction, not the Transaction Effective Date
2775: ,tap.transaction_date trx_occ_date
2776: ,'Payables' source
2777: FROM
2778: okl_txl_ap_inv_lns_all_b tpl
2779: ,okl_trx_ap_invs_all_b tap
2780: ,okc_k_headers_all_b chr
2781: ,okl_k_headers khr
2782: ,okl_products pdt

Line 2838: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

2834: AND invdist.line_type_lookup_code = 'ITEM' -- Need to verify
2835: AND invdist.invoice_id = lin.invoice_id
2836: AND invdist.invoice_line_number = lin.line_number
2837: AND lin.application_id = 540
2838: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
2839: AND lin.reference_key1 = tpl.id
2840: AND lin.invoice_id = inv.invoice_id
2841: -- AP to XLA Relations
2842: AND invdist.accounting_event_id = xe.event_id

Line 2939: okl_txl_ap_inv_lns_all_b tpl

2935: -- Occurance date of the Transaction, not the Transaction Effective Date
2936: ,tap.transaction_date trx_occ_date
2937: ,'Payables' source
2938: FROM
2939: okl_txl_ap_inv_lns_all_b tpl
2940: ,okl_trx_ap_invs_all_b tap
2941: ,okc_k_headers_all_b chr
2942: ,okl_k_headers khr
2943: ,okl_products pdt

Line 3003: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

2999: AND invdist.line_type_lookup_code = 'ITEM' -- Need to verify
3000: AND invdist.invoice_id = lin.invoice_id
3001: AND invdist.invoice_line_number = lin.line_number
3002: AND lin.application_id = 540
3003: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
3004: AND lin.reference_key1 = tpl.id
3005: AND lin.invoice_id = inv.invoice_id
3006: -- AP to XLA Relations
3007: AND invdist.accounting_event_id = xe.event_id

Line 4685: ,okl_txl_ap_inv_lns_all_b tpl

4681: ,ap_invoice_distributions_all invdist
4682: ,ap_invoice_lines_all lin
4683: ,ap_invoices_all inv
4684: -- OLM Tables
4685: ,okl_txl_ap_inv_lns_all_b tpl
4686: ,okl_trx_ap_invs_all_b tap
4687: ,okc_k_headers_all_b chr
4688: ,okl_k_headers khr
4689: ,okl_products pdt

Line 4734: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

4730: AND invdist.invoice_id = lin.invoice_id
4731: AND lin.invoice_id = inv.invoice_id
4732: -- OKL to AP Predicates
4733: AND lin.application_id = 540
4734: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
4735: AND lin.reference_key1 = tpl.id
4736: -- OKL Predicates
4737: AND tap.id = tpl.tap_id
4738: AND tap.try_id = try.id