1063: sum(cracd.amount/NVL(aia.exchange_rate,1))
1064: into
1065: l_acq_cost_ent_inv
1066: from
1067: cst_rcv_acq_cost_details cracd,
1068: ap_invoice_distributions_all aida,
1069: ap_invoices_all aia
1070: where
1071: aida.invoice_distribution_id = cracd.invoice_distribution_id
1087: 'R',rt.currency_conversion_rate))
1088: into
1089: l_acq_cost_ent_po
1090: from
1091: cst_rcv_acq_cost_details cracd,
1092: po_line_locations_all poll,
1093: rcv_transactions rt
1094: where
1095: poll.line_location_id = cracd.po_line_location_id
1819: aia.exchange_date "EXCHANGE_DATE",
1820: aia.exchange_rate_type "EXCHANGE_RATE_TYPE",
1821: aida.dist_code_combination_id "CODE_COMBINATION_ID"
1822: FROM
1823: cst_rcv_acq_cost_details cracd,
1824: cst_rcv_acq_costs crac,
1825: ap_invoice_distributions_all aida,
1826: ap_invoices_all aia
1827: WHERE
1918: -- Retroactive Pricing Enhancements
1919: -- Need Invoice Distribution to find correction invoices
1920: aida.related_id "INVOICE_DISTRIBUTION_ID"
1921: FROM
1922: cst_rcv_acq_cost_details cracd,
1923: cst_rcv_acq_costs crac,
1924: ap_invoice_distributions_all aida,
1925: ap_invoices_all aia
1926: WHERE
2042: SELECT
2043: aida.amount "EXCHANGE_RATE_VARIANCE",
2044: aida.dist_code_combination_id "CODE_COMBINATION_ID"
2045: FROM
2046: cst_rcv_acq_cost_details cracd,
2047: cst_rcv_acq_costs crac,
2048: ap_invoice_distributions_all aida
2049: WHERE
2050: crac.rcv_transaction_id = l_par_rcv_txn AND