DBA Data[Home] [Help]

APPS.CSTPAPBR dependencies on CST_RCV_ACQ_COST_DETAILS

Line 841: cst_rcv_acq_cost_details cracd,

837: SUM(cracd.amount/NVL(aida.exchange_rate,1))
838: INTO
839: l_acq_cost_ent_inv
840: FROM
841: cst_rcv_acq_cost_details cracd,
842: ap_invoice_distributions_all aida
843: WHERE aida.invoice_distribution_id = cracd.invoice_distribution_id
844: AND cracd.header_id = (SELECT header_id
845: FROM cst_rcv_acq_costs crac

Line 856: cst_rcv_acq_cost_details cracd,

852: sum(cracd.amount/NVL(aia.exchange_rate,1))
853: into
854: l_acq_cost_ent_inv
855: from
856: cst_rcv_acq_cost_details cracd,
857: ap_invoice_distributions_all aida,
858: ap_invoices_all aia
859: where
860: aida.invoice_distribution_id = cracd.invoice_distribution_id

Line 883: cst_rcv_acq_cost_details cracd,

879: 'R',rt.currency_conversion_rate))
880: INTO
881: l_acq_cost_ent_po
882: FROM
883: cst_rcv_acq_cost_details cracd,
884: po_line_locations_all poll,
885: rcv_transactions rt
886: WHERE
887: poll.line_location_id = cracd.po_line_location_id