eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPAPPR dependencies on AP_INVOICES_ALL

Line 1055: -- Joining with ap_invoices_all in order to get the

1051: -- Bug # 1054868
1052: -------------------------------------------------
1053:
1054: -------------------------------------------------
1055: -- Joining with ap_invoices_all in order to get the
1056: -- exchange rate. This is a result of AP's Invoice
1057: -- Lines Project
1058: -------------------------------------------------
1059:

Line 1069: ap_invoices_all aia

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
1073: and aia.org_id = aida.org_id

Line 1807: -- Joining with ap_invoices_all in order to get the

1803: -- that is specified at the time of invoice creation
1804: ---------------------------------------------------------------
1805:
1806: -------------------------------------------------
1807: -- Joining with ap_invoices_all in order to get the
1808: -- exchange rate. Also, the code needs to check for
1809: -- more than just ITEM when looking at the lookup code
1810: -- This is a result of AP's Invoice Lines Project
1811: -------------------------------------------------

Line 1826: ap_invoices_all aia

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
1830: crac.cost_type_id = i_ae_txn_rec.cost_type_id AND

Line 1925: ap_invoices_all aia

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
1929: crac.cost_group_id = i_ae_txn_rec.cost_group_id AND

Line 1965: AP_INVOICES_ALL AP_INV

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'
1969: AND AIDA.INVOICE_ID = AP_INV.INVOICE_ID