APPS.FV_GTAS_GL_PKG dependencies on FV_GTAS_HEADER_ID_GT

Line 500: INSERT INTO fv_gtas_header_id_gt

496: log(l_module_name,'Begin');
497:
498: --Insert into temp table all the je headers ids which need to be processed
499: --This is to help improve performance
500: INSERT INTO fv_gtas_header_id_gt
501: (je_header_id,set_of_books_id)
502: SELECT gjh.je_header_id, gjh.ledger_id
503: FROM
504: (SELECT period_num,period_name

Line 527: --Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_GTAS_HEADER_ID_GT');

523: log(l_module_name,'Inserted ' || SQL%ROWCOUNT);
524:
525: --This commit is to gather table stats
526: --COMMIT;
527: --Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_GTAS_HEADER_ID_GT');
528:
529: SELECT factsI_journal_attribute
530: INTO gbl_jrnl_attribute
531: FROM fv_system_parameters;

Line 574: FV_GTAS_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

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 ||
578: ' FROM fv_gtas_header_id_gt ftt,

Line 578: ' FROM fv_gtas_header_id_gt 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 ||
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

Line 2753: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_gtas_header_id_gt;

2749: log(l_module_name, 'Begin '||l_module_name);
2750:
2751: INSERT INTO fv_gtas_processed_je_hdrs
2752: (je_header_id,set_of_books_id)
2753: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_gtas_header_id_gt;
2754:
2755: log(l_module_name,'Inserted in fv_gtas_processed_je_hdrs: '||SQL%ROWCOUNT);
2756: log(l_module_name,'Updating GTAS run ' );
2757: