APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_HEADER_ID_GT

Line 537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');

533: l_module_name := g_module_name || 'PROCESS_GL_LINES';
534: FV_UTILITY.LOG_MESG('In '||l_module_name);
535:
536:
537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
538:
539: if gbl_called_from_main = 'N' then
540:
541: INSERT INTO fv_facts1_header_id_gt(je_header_id,set_of_books_id)

Line 541: INSERT INTO fv_facts1_header_id_gt(je_header_id,set_of_books_id)

537: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
538:
539: if gbl_called_from_main = 'N' then
540:
541: INSERT INTO fv_facts1_header_id_gt(je_header_id,set_of_books_id)
542: select gjh.je_header_id , gjh.ledger_id
543: from
544: (SELECT period_num, period_name
545: FROM gl_period_statuses

Line 563: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');

559:
560: FV_UTILITY.LOG_MESG('Inserted ' || SQL%ROWCOUNT);
561:
562: COMMIT;
563: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');
564:
565: End if;
566:
567: l_select_stmt :=

Line 639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

635: else
636:
637:
638: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh

Line 642: ' FROM fv_facts1_header_id_gt ftt

638: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh
644: , gl_je_lines gjl
645: , (SELECT period_num
646: , period_name

Line 929: INSERT INTO fv_facts1_header_id_gt

925: end if;
926: end loop;
927:
928: FORALL i IN je_header_id_list_new.first .. je_header_id_list_new.last
929: INSERT INTO fv_facts1_header_id_gt
930: ( je_header_id,
931: set_of_books_id)
932: VALUES
933: (je_header_id_list_new(i),

Line 1678: ' FROM fv_facts1_header_id_gt f ,

1674: substr(rpad(h.je_category, 15, '' ''),1,15) || '' '' ||
1675: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||
1676: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1677: to_char( amount,''99,999,999,999,999,999.99'') ' ||
1678: ' FROM fv_facts1_header_id_gt f ,
1679: gl_je_headers h,
1680: fv_facts1_line_balances l,
1681: gl_je_batches b
1682: where h.je_header_id = f.je_header_id

Line 1773: FROM fv_facts1_header_id_gt;

1769:
1770: IF gbl_called_from_main = 'Y' THEN
1771: INSERT INTO fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1772: SELECT DISTINCT je_header_id,set_of_books_id
1773: FROM fv_facts1_header_id_gt;
1774:
1775: ELSE
1776: Insert into fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1777: select je_header_id,set_of_books_id

Line 1778: from fv_facts1_header_id_gt;

1774:
1775: ELSE
1776: Insert into fv_facts1_processed_je_hdrs(je_header_id,set_of_books_id)
1777: select je_header_id,set_of_books_id
1778: from fv_facts1_header_id_gt;
1779:
1780: END IF;
1781:
1782: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);