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_FACTS1_GL_PKG dependencies on GL_JE_LINES

Line 354: -- Select all journal lines from gl_je_lines from the beginning of the year upto

350: WHEN OTHERS THEN
351: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
352: END log;
353: --------------------------------------------------------------------------------
354: -- Select all journal lines from gl_je_lines from the beginning of the year upto
355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
356: -- all journal lines not existing in fv_facts1_line_balances.
357: -- Retreives party info like party type, eliminations dept, etc and insert into
358: -- fv_facts1_line_balances.

Line 380: TABLE OF gl_je_lines.je_line_num%TYPE;

376: IS
377: TABLE OF gl_je_headers.je_source%TYPE;
378: TYPE je_line_num_t
379: IS
380: TABLE OF gl_je_lines.je_line_num%TYPE;
381: TYPE sob_id_t
382: IS
383: TABLE OF gl_je_lines.ledger_id%TYPE;
384: TYPE ccid_t

Line 383: TABLE OF gl_je_lines.ledger_id%TYPE;

379: IS
380: TABLE OF gl_je_lines.je_line_num%TYPE;
381: TYPE sob_id_t
382: IS
383: TABLE OF gl_je_lines.ledger_id%TYPE;
384: TYPE ccid_t
385: IS
386: TABLE OF gl_je_lines.code_combination_id%TYPE;
387: TYPE attribute_val_t

Line 386: TABLE OF gl_je_lines.code_combination_id%TYPE;

382: IS
383: TABLE OF gl_je_lines.ledger_id%TYPE;
384: TYPE ccid_t
385: IS
386: TABLE OF gl_je_lines.code_combination_id%TYPE;
387: TYPE attribute_val_t
388: IS
389: TABLE OF gl_je_lines.attribute1%TYPE;
390: TYPE amount_t

Line 389: TABLE OF gl_je_lines.attribute1%TYPE;

385: IS
386: TABLE OF gl_je_lines.code_combination_id%TYPE;
387: TYPE attribute_val_t
388: IS
389: TABLE OF gl_je_lines.attribute1%TYPE;
390: TYPE amount_t
391: IS
392: TABLE OF fv_facts1_line_balances.amount%TYPE;
393: TYPE d_c_indicator_t

Line 398: TABLE OF gl_je_lines.period_name%TYPE;

394: IS
395: TABLE OF fv_facts1_line_balances.d_c_indicator%TYPE;
396: TYPE gl_period_t
397: IS
398: TABLE OF gl_je_lines.period_name%TYPE;
399: TYPE party_id_t
400: IS
401: TABLE OF fv_facts1_line_balances.party_id%TYPE;
402: TYPE party_type_t

Line 416: TABLE OF gl_je_lines.reference_1%TYPE;

412: IS
413: TABLE OF fv_facts1_line_balances.eliminations_dept%TYPE;
414: TYPE reference_t
415: IS
416: TABLE OF gl_je_lines.reference_1%TYPE;
417: TYPE fund_value_t
418: IS
419: TABLE OF fv_fund_parameters.fund_value%TYPE;
420: TYPE account_number_t

Line 576: gl_je_lines gjl,

572: WHERE application_id = 101
573: AND ledger_id = :gbl_sob_id
574: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
575: AND period_year = :gbl_period_year ) gps,
576: gl_je_lines gjl,
577: gl_je_headers gjh
578: WHERE fff.jc_flag = ''N''
579: AND fff.set_of_books_id = :gbl_sob_id
580: AND fff.fiscal_year = :gbl_period_year

Line 605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

601: fv_utility.log_mesg('Running in full mode');
602: fv_utility.log_mesg(l_select_stmt);
603: ELSE
604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt
609: , gl_je_headers gjh

Line 610: , gl_je_lines gjl

606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt
609: , gl_je_headers gjh
610: , gl_je_lines gjl
611: , (SELECT period_num
612: , period_name
613: FROM gl_period_statuses ps
614: WHERE application_id = 101

Line 1002: FROM gl_je_lines je ,

998: p_ref IN VARCHAR2
999: )
1000: IS
1001: SELECT e.vendor_id ven_id
1002: FROM gl_je_lines je ,
1003: gl_je_headers jh ,
1004: pa_cost_distribution_lines_all cdl,
1005: pa_expenditure_items_all ei ,
1006: pa_expenditures_all e

Line 1018: --l_reference_2 gl_je_lines.reference_1%TYPE;

1014: -- Variables for Dynamic Cursor
1015: l_recipient_name po_vendors.vendor_name%type ;
1016: l_elim_dept VARCHAR2(7);
1017: l_govt_non_govt_ind VARCHAR2(1);
1018: --l_reference_2 gl_je_lines.reference_1%TYPE;
1019: --l_reference_5 gl_je_lines.reference_1%TYPE;
1020: --l_reference_7 gl_je_lines.reference_1%TYPE;
1021: l_be_trx_id NUMBER;
1022: party_info_tab party_info_table;

Line 1019: --l_reference_5 gl_je_lines.reference_1%TYPE;

1015: l_recipient_name po_vendors.vendor_name%type ;
1016: l_elim_dept VARCHAR2(7);
1017: l_govt_non_govt_ind VARCHAR2(1);
1018: --l_reference_2 gl_je_lines.reference_1%TYPE;
1019: --l_reference_5 gl_je_lines.reference_1%TYPE;
1020: --l_reference_7 gl_je_lines.reference_1%TYPE;
1021: l_be_trx_id NUMBER;
1022: party_info_tab party_info_table;
1023: l_cust_vend_type VARCHAR2(1);

Line 1020: --l_reference_7 gl_je_lines.reference_1%TYPE;

1016: l_elim_dept VARCHAR2(7);
1017: l_govt_non_govt_ind VARCHAR2(1);
1018: --l_reference_2 gl_je_lines.reference_1%TYPE;
1019: --l_reference_5 gl_je_lines.reference_1%TYPE;
1020: --l_reference_7 gl_je_lines.reference_1%TYPE;
1021: l_be_trx_id NUMBER;
1022: party_info_tab party_info_table;
1023: l_cust_vend_type VARCHAR2(1);
1024: BEGIN

Line 1760: FROM gl_je_lines je ,

1756: CURSOR project_source_cur
1757: IS
1758: SELECT pc.customer_id party_id,
1759: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount
1760: FROM gl_je_lines je ,
1761: gl_import_references gir ,
1762: xla_ae_lines ael ,
1763: xla_ae_headers aeh ,
1764: pa_draft_revenues_all pdr,