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.

[Home] [Help]

APPS.FII_AP_INV_LINES_F_C dependencies on XLA_AE_HEADERS

Line 593: xla_ae_headers xah

589: FROM fii_ap_tmp_line_pk apk,
590: ap_invoice_payments_all aip,
591: -- ap_payment_history_all aph,
592: xla_ae_lines xal,
593: xla_ae_headers xah
594: WHERE apk.PRIMARY_KEY1 = aip.invoice_id
595: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
596: AND apk.PRIMARY_KEY2 = xal.Upg_Tax_Reference_ID2
597: AND xal.accounting_class_code = 'DISCOUNT'

Line 1048: xla_ae_headers xah

1044: ap_invoices_all ai,
1045: ap_invoice_payments_all aip,
1046: -- ap_payment_history_all aph,
1047: xla_ae_lines xal,
1048: xla_ae_headers xah
1049: WHERE aid.invoice_id = ai.invoice_id
1050: AND aid.invoice_id = aip.invoice_id
1051: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
1052: AND aid.old_dist_line_number = xal.Upg_Tax_Reference_ID2

Line 1121: from xla_ae_headers xah,

1117: AND XAD.Program_Code = XACA.Program_Code
1118: AND XAD.Assignment_Code = XACA.Assignment_Code)
1119: select /*+ parallel(fstg) parallel(xah) parallel(xte) parallel(xal) parallel(xdl) */ xal.code_combination_id,
1120: inv_line_pk
1121: from xla_ae_headers xah,
1122: xla_transaction_entities xte,
1123: xla_distribution_links xdl,
1124: xla_ae_lines xal,
1125: fii_ap_inv_lines_fstg fstg,