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.AP_WEB_CREDIT_CARD_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 7: have a column in ap_credit_card_trxns_all table which

3:
4: /* Function introduced in OIE.J
5: It returns 'Y' if a transaction has level2 data
6: and expense tpye as 'HOTEL'. Ideally, we should
7: have a column in ap_credit_card_trxns_all table which
8: should get populated during loading the transaction if
9: level2 transaction is present.
10: */
11: FUNCTION HAS_DETAILED_TRXN (p_trx_id IN VARCHAR2)

Line 17: from ap_credit_card_trxns_all

13: IS
14: has_detailed_trxn VARCHAR2(1) := 'N';
15: BEGIN
16: select 'Y' into has_detailed_trxn
17: from ap_credit_card_trxns_all
18: where (HOTEL_TELEPHONE_AMOUNT > 0 OR
19: HOTEL_BAR_AMOUNT > 0 OR
20: HOTEL_MOVIE_AMOUNT > 0 OR
21: HOTEL_GIFT_SHOP_AMOUNT > 0 OR

Line 177: ap_credit_card_trxns_all ctx,

173: into l_card_reference_id
174: from ap_invoices_all inv,
175: iby_docs_payable_all iby,
176: ap_expense_report_headers_all erh,
177: ap_credit_card_trxns_all ctx,
178: ap_cards_all crd
179: where iby.document_payable_id = p_document_payable_id
180: and iby.calling_app_doc_unique_ref2 = inv.invoice_id
181: and inv.invoice_id = erh.vouchno