[Home] [Help]
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
1072: and aia.invoice_id = aida.invoice_id
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
1828: cracd.line_type NOT IN ('ITEM','ACCRUAL','IPV','ERV','NONREC_TAX') AND
1829: crac.rcv_transaction_id = l_par_rcv_txn AND
1834: cracd.invoice_distribution_id = aida.invoice_distribution_id AND
1835: aia.invoice_id = aida.invoice_id AND
1836: aia.org_id = aida.org_id AND
1837: NOT EXISTS (
1838: SELECT '1' FROM ap_invoice_distributions_all aida2
1839: WHERE aida2.related_id = aida.invoice_distribution_id
1840: AND aida2.line_type_lookup_code = 'IPV'
1841: );
1842: BEGIN
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
1927: crac.rcv_transaction_id = l_par_rcv_txn AND
1928: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
1960: NVL(AIDA.BASE_AMOUNT/NVL(AP_INV.EXCHANGE_RATE,1), 0)
1961: INTO
1962: l_correct_ipv_amount
1963: FROM
1964: AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
1965: AP_INVOICES_ALL AP_INV
1966: WHERE
1967: AIDA.CORRECTED_INVOICE_DIST_ID = c_ipv_rec.INVOICE_DISTRIBUTION_ID
1968: AND AIDA.LINE_TYPE_LOOKUP_CODE = 'IPV'
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
2051: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND
2052: crac.cost_group_id = i_ae_txn_rec.cost_group_id AND