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_GL_PKG dependencies on GL_JE_HEADERS

Line 400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;

396: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
397: TYPE account_number_t IS TABLE OF fv_gtas_activity_balances.account_number%TYPE;
398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;
399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;
400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;

Line 402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;

398: TYPE amount_t IS TABLE OF fv_gtas_activity_balances.amount%TYPE;
399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;
400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;

Line 403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;

399: TYPE d_c_indicator_t IS TABLE OF fv_gtas_activity_balances.d_c_indicator%TYPE;
400: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
401: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
402: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
403: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
404: TYPE reference_t IS TABLE OF gl_je_lines.reference_1%TYPE;
405: TYPE je_attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
406: TYPE fund_value_t IS TABLE OF fv_fund_parameters.fund_value%TYPE;
407: TYPE gl_period_t IS TABLE OF gl_je_lines.period_name%TYPE;

Line 417: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;

413: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
414: TYPE record_category_t IS TABLE OF fv_gtas_activity_balances.record_category%TYPE;
415: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
416: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
417: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;
418: TYPE authority_type_flag_t IS TABLE OF VARCHAR2(1);
419: TYPE fed_nonfed_flag_list_t IS TABLE OF VARCHAR2(1);
420: TYPE budget_impact_ind_flag_list_t IS TABLE OF VARCHAR2(1);
421: TYPE trading_partner_flag_list_t IS TABLE OF VARCHAR2(1);

Line 511: gl_je_headers gjh

507: AND ledger_id = gbl_sob_id
508: AND period_num BETWEEN gbl_period_num_low AND gbl_period_num_high
509: AND period_year = gbl_period_year
510: ) gps,
511: gl_je_headers gjh
512: WHERE gjh.period_name = gps.period_name
513: AND gjh.ledger_id = gbl_sob_id
514: AND gjh.status = 'P'
515: AND gjh.actual_flag = 'A'

Line 573: 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt

569: fgf.sgl_account_number
570: ';
571:
572: l_select_stmt :=
573: 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
574: FV_GTAS_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
575: glcc GL_CODE_COMBINATIONS_U1,
576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||
577: l_select_stmt ||

Line 579: gl_je_headers gjh,

575: glcc GL_CODE_COMBINATIONS_U1,
576: fgf FV_GTAS_FED_ACCOUNTS_U1) */ ' ||
577: l_select_stmt ||
578: ' FROM fv_gtas_header_id_gt ftt,
579: gl_je_headers gjh,
580: gl_je_lines gjl,
581: (SELECT period_num, period_name
582: FROM gl_period_statuses ps
583: WHERE application_id = 101

Line 1549: FROM gl_je_headers

1545: END IF;
1546: --Get journal name as doc num
1547: SELECT SUBSTR(name,1,30)
1548: INTO p_party_info_tab(i).doc_num
1549: FROM gl_je_headers
1550: WHERE je_header_id = p_je_header_id;
1551:
1552: gbl_other_journal := 'Y';
1553:

Line 2046: gl_je_headers jh ,

2042:
2043: CURSOR projects_vendor_cur (p_ref1 IN VARCHAR2) IS
2044: SELECT e.vendor_id ven_id
2045: FROM gl_je_lines je ,
2046: gl_je_headers jh ,
2047: pa_cost_distribution_lines_all cdl,
2048: pa_expenditure_items_all ei ,
2049: pa_expenditures_all e
2050: WHERE je.je_header_id = jh.je_header_id

Line 2841: FROM gl_je_headers

2837: log(l_module_name, 'Deleting from fv_gtas_processed_je_hdrs');
2838: DELETE fv_gtas_processed_je_hdrs
2839: WHERE set_of_books_id = gbl_sob_id
2840: AND je_header_id IN (SELECT je_header_id
2841: FROM gl_je_headers
2842: WHERE ledger_id = gbl_sob_id
2843: AND period_name IN
2844: (SELECT period_name
2845: FROM gl_period_statuses