[Home] [Help]
1061: -- Bug # 1054868
1062: -------------------------------------------------
1063:
1064: -------------------------------------------------
1065: -- Joining with ap_invoices_all in order to get the
1066: -- exchange rate. This is a result of AP's Invoice
1067: -- Lines Project
1068: -------------------------------------------------
1069:
1078: l_acq_cost_ent_inv
1079: from
1080: cst_rcv_acq_cost_details cracd,
1081: ap_invoice_distributions_all aida,
1082: ap_invoices_all aia
1083: where
1084: aida.invoice_distribution_id = cracd.invoice_distribution_id
1085: and aia.invoice_id = aida.invoice_id
1086: and aia.org_id = aida.org_id
1833: -- that is specified at the time of invoice creation
1834: ---------------------------------------------------------------
1835:
1836: -------------------------------------------------
1837: -- Joining with ap_invoices_all in order to get the
1838: -- exchange rate. Also, the code needs to check for
1839: -- more than just ITEM when looking at the lookup code
1840: -- This is a result of AP's Invoice Lines Project
1841: -------------------------------------------------
1867: xla_distribution_links xdl,
1868: xla_ae_lines xal,
1869: xla_ae_headers xae,
1870: ap_invoice_distributions_all aida ,
1871: ap_invoices_all aia
1872: WHERE
1873: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
1874: crac.rcv_transaction_id = l_par_rcv_txn AND
1875: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1910: FROM
1911: cst_rcv_acq_cost_details cracd,
1912: cst_rcv_acq_costs crac,
1913: ap_invoice_distributions_all aida,
1914: ap_invoices_all aia
1915: WHERE
1916: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
1917: crac.rcv_transaction_id = l_par_rcv_txn AND
1918: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
2049: xla_distribution_links xdl,
2050: xla_ae_lines xal,
2051: xla_ae_headers xae,
2052: ap_invoice_distributions_all aida,
2053: ap_invoices_all aia
2054: WHERE
2055: crac.rcv_transaction_id = l_par_rcv_txn AND
2056: crac.cost_type_id =i_ae_txn_rec.cost_type_id AND
2057: crac.cost_group_id = i_ae_txn_rec.cost_group_id AND
2091: FROM
2092: cst_rcv_acq_cost_details cracd,
2093: cst_rcv_acq_costs crac,
2094: ap_invoice_distributions_all aida,
2095: ap_invoices_all aia
2096: WHERE
2097: crac.rcv_transaction_id = l_par_rcv_txn AND
2098: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
2099: crac.cost_group_id = i_ae_txn_rec.cost_group_id AND
2163: INTO
2164: l_correct_ipv_amount
2165: FROM
2166: AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
2167: AP_INVOICES_ALL AP_INV
2168: WHERE
2169: AIDA.CORRECTED_INVOICE_DIST_ID = c_ipv_rec.INVOICE_DISTRIBUTION_ID
2170: AND AIDA.LINE_TYPE_LOOKUP_CODE = 'IPV'
2171: AND AIDA.INVOICE_ID = AP_INV.INVOICE_ID