DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 898: ap_invoice_distributions_all aida ,

894: AND ct.transaction_type_id = 105 -- rec in to project
895: UNION
896: SELECT pda.variance_account_id
897: FROM po_distributions_all pda,
898: ap_invoice_distributions_all aida ,
899: csi_transactions ct
900: WHERE pda.po_distribution_id = aida.po_distribution_id
901: AND aida.invoice_distribution_id = ct.source_dist_ref_id2
902: AND ct.transaction_id = c_transaction_id

Line 2870: ap_invoice_distributions_all aida

2866: FROM xla_transaction_entities xlte,
2867: xla_ae_headers xlaeh,
2868: xla_ae_lines xlael,
2869: xla_distribution_links xdl,
2870: ap_invoice_distributions_all aida
2871: WHERE xlte.application_id = l_application_id
2872: AND xlte.entity_code = l_entity_code
2873: AND xlte.source_id_int_1 = p_invoice_id
2874: AND xlaeh.ledger_id = l_ledger_id