DBA Data[Home] [Help]

APPS.FII_AP_INV_LINES_F_C dependencies on XLA_AE_LINES

Line 592: xla_ae_lines xal,

588: NVL(sum(NVL(xal.accounted_dr, xal.entered_dr)), 0)
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

Line 1047: xla_ae_lines xal,

1043: FROM ap_invoice_distributions_all aid,
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

Line 1124: xla_ae_lines xal,

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,
1126: accounting_class ac
1127: where xte.entity_code='AP_INVOICES'
1128: and xah.entity_id=xte.entity_id