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.FV_GTAS_TRX_REGISTER dependencies on FV_BE_TRX_HDRS

Line 3095: FROM fv_be_trx_hdrs h,

3091: DECLARE
3092: --Modified for bug 7256357
3093: CURSOR dept_cur IS
3094: SELECT h.doc_number, SUBSTR(d.dept_id,1,3), d.main_account
3095: FROM fv_be_trx_hdrs h,
3096: fv_be_trx_dtls d
3097: WHERE d.transaction_id = to_number(l_reference_1)
3098: AND h.doc_id = d.doc_id;
3099: --SELECT dept_id||main_account

Line 3102: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;

3098: AND h.doc_id = d.doc_id;
3099: --SELECT dept_id||main_account
3100: --FROM fv_be_trx_dtls
3101: --WHERE transaction_id = to_number(l_reference_1);
3102: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
3103: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
3104: BEGIN
3105:
3106: log(l_module,'BUDGETARY TRANSACTION');

Line 3476: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h

3472:
3473: CURSOR Budget_Transac IS
3474: SELECT h.doc_number, d.gl_date, d.creation_date,
3475: d.created_by
3476: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h
3477: WHERE d.transaction_id = to_number(p_reference1)
3478: AND h.doc_id = d.doc_id;
3479:
3480: CURSOR Manual IS

Line 5809: FROM fv_be_trx_dtls bd, fv_be_trx_hdrs bh, fv_budget_levels bl

5805: log(l_module,'l_be_trx_id: '||l_be_trx_id);
5806: BEGIN
5807: SELECT bd.TRANSACTION_TYPE_ID, bd.SUB_TYPE
5808: INTO l_trx_type_id, l_sub_type
5809: FROM fv_be_trx_dtls bd, fv_be_trx_hdrs bh, fv_budget_levels bl
5810: WHERE bd.transaction_id = l_be_trx_id
5811: AND bd.doc_id = bh.doc_id
5812: AND bd.set_of_books_id = bh.set_of_books_id
5813: AND bl.budget_level_id = bh.budget_level_id