2 Replies Latest reply on Dec 5, 2016 9:01 AM by Beauty_and_dBest

    EBS R12.1.3 Create Accounting Issues

    Beauty_and_dBest

        Hi ALL,

       

      EBS R12.1.3

      11gR2

      OL6

       

      Our functional consultant is running "Create Accounting" concurrent program.

      We have 200,000+ record for  just 1 period to process.

      She used setting  like parallel processing spawning 10 subprocesses to speedup the process.

      But when I monitored the locks, it seems only one  runs and the other and waiting?

      Is  parallel processing supported in create accounting? Or some setup was messing or erroneously done?

       

      Everytime this create accounting runs, everything in the server hangs.

      Even if I login as apps/pwd and run select * from tab;   this simple command froze.

       

      Please help how to fix the issue

       

      Kind regards,

       

      This is the lock query script I run:

      SELECT

          O.OBJECT_NAME,

          S.SID,

          S.SERIAL#,

          P.SPID,

          S.PROGRAM,

          SQ.SQL_FULLTEXT,

          S.LOGON_TIME

      FROM

          V$LOCKED_OBJECT L,

          DBA_OBJECTS O,

          V$SESSION S,

          V$PROCESS P,

          V$SQL SQ

      WHERE

          L.OBJECT_ID = O.OBJECT_ID

          AND L.SESSION_ID = S.SID

          AND S.PADDR = P.ADDR

          AND S.SQL_ADDRESS = SQ.ADDRESS;

      jc

       

       

      OBJECT_NAMESIDSERIAL#SPIDPROGRAMSQL_FULLTEXT
      XLA_DISTRIBUTION_LINKS15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_ACCOUNTING_ERRORS15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS_GT15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_DISTRIBUTION_LINKS15932424FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_AE_LINE_ACS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_HEADER_ACS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_DISTRIBUTION_LINKS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_LINES310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_HEADERS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_EVENTS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_SEGMENT_VALUES310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_ACCOUNTING_ERRORS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_EVENTS_GT310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_EVENTS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_DISTRIBUTION_LINKS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_LINES_GT310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_LINES310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_HEADERS_GT310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      XLA_AE_HEADERS310152433FPPCCREATEACCT@ebizapps.com.ph (TNS V1INSERT INTO XLA_AE_LINES_GT ( AE_HEADER_ID , TEMP_LINE_NUM , EXTRACT_LINE_NUM , EVENT_ID , REF_AE_HEADER_ID , ACCOUNTING_DATE , ACCOUNTING_CLASS_CODE , ROUNDING_CLASS_CODE , EVENT_CLASS_CODE , EVENT_TYPE_CODE , LINE_DEFINITION_OWNER_CODE , LINE_DEFINITION_CODE , ACCOUNTING_LINE_TYPE_CODE , ACCOUNTING_LINE_CODE , DOCUMENT_ROUNDING_LEVEL , GAIN_OR_LOSS_REF , CALCULATE_ACCTD_AMTS_FLAG , CALCULATE_G_L_AMTS_FLAG , GAIN_OR_LOSS_FLAG , CODE_COMBINATION_STATUS_CODE , CODE_COMBINATION_ID , SL_COA_MAPPING_NAME , SL_COA_MAPPING_ID , DYNAMIC_INSERT_FLAG , SOURCE_COA_ID , CCID_COA_ID , SEGMENT1 , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , SEGMENT11 , SEGMENT12 , SEGMENT13 , SEGMENT14 , SEGMENT15 , SEGMENT16 , SEGMENT17 , SEGMENT18 , SEGMENT19 , SEGMENT20 , SEGMENT21 , SEGMENT22 , SEGMENT23 , SEGMENT24 , SEGMENT25 , SEGMENT26 , SEGMENT27 , SEGMENT28 , SEGMENT29 , SEGMENT30 , ALT_CCID_STATUS_CODE , ALT_CODE_COMBINATION_ID , ALT_SEGMENT1 , ALT_SEGMENT2 , ALT_SEGMENT3 , ALT_SEGMENT4 , ALT_SEGMENT5 , ALT_SEGMENT6 , ALT_SEGMENT7 , ALT_SEGMENT8 , ALT_SEGMENT9 , ALT_SEGMENT10 , ALT_SEGMENT11 , ALT_SEGMENT12 , ALT_SEGMENT13 , ALT_SEGMENT14 , ALT_SEGMENT15 , ALT_SEGMENT16 , ALT_SEGMENT17 , ALT_SEGMENT18 , ALT_SEGMENT19 , ALT_SEGMENT20 , ALT_SEGMENT21 , ALT_SEGMENT22 , ALT_SEGMENT23 , ALT_SEGMENT24 , ALT_SEGMENT25 , ALT_SEGMENT26 , ALT_SEGMENT27 , ALT_SEGMENT28 , ALT_SEGMENT29 , ALT_SEGMENT30 , DESCRIPTION , GL_TRANSFER_MODE_CODE , MERGE_DUPLICATE_CODE , SWITCH_SIDE_FLAG , ENTERED_AMOUNT , LEDGER_AMOUNT , UNROUNDED_ENTERED_DR , UNROUNDED_ENTERED_CR , UNROUNDED_ACCOUNTED_DR , UNROUNDED_ACCOUNTED_CR , ENTERED_CURRENCY_MAU , CURRENCY_CODE , CURRENCY_CONVERSION_DATE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , STATISTICAL_AMOUNT , PARTY_ID , PARTY_SITE_ID , PARTY_TYPE_CODE , USSGL_TRANSACTION_CODE , JGZZ_RECON_REF , SOURCE_DISTRIBUTION_ID_CHAR_1 , SOURCE_DISTRIBUTION_ID_CHAR_2 , SOURCE_DISTRIBUTION_ID_CHAR_3 , SOURCE_DISTRIBUTION_ID_CHAR_4 , SOURCE_DISTRIBUTION_ID_CHAR_5 , SOURCE_DISTRIBUTION_ID_NUM_1 , SOURCE_DISTRIBUTION_ID_NUM_2 , SOURCE_DISTRIBUTION_ID_NUM_3 , SOURCE_DISTRIBUTION_ID_NUM_4 , SOURCE_DISTRIBUTION_ID_NUM_5 , SOURCE_DISTRIBUTION_TYPE , REVERSE_DIST_ID_CHAR_1 , REVERSE_DIST_ID_CHAR_2 , REVERSE_DIST_ID_CHAR_3 , REVERSE_DIST_ID_CHAR_4 , REVERSE_DIST_ID_CHAR_5 , REVERSE_DIST_ID_NUM_1 , REVERSE_DIST_ID_NUM_2 , REVERSE_DIST_ID_NUM_3 , REVERSE_DIST_ID_NUM_4 , REVERSE_DIST_ID_NUM_5 , REVERSE_DISTRIBUTION_TYPE , TAX_LINE_REF_ID , TAX_SUMMARY_LINE_REF_ID , TAX_REC_NREC_DIST_REF_ID , HEADER_NUM , MPA_ACCRUAL_ENTRY_FLAG , MULTIPERIOD_OPTION_FLAG , MULTIPERIOD_START_DATE , MULTIPERIOD_END_DATE , ANALYTICAL_BALANCE_FLAG , ANC_ID_1 , ANC_ID_2 , ANC_ID_3 , ANC_ID_4 , ANC_ID_5 , ANC_ID_6 , ANC_ID_7 , ANC_ID_8 , ANC_ID_9 , ANC_ID_10 , ANC_ID_11 , ANC_ID_12 , ANC_ID_13 , ANC_ID_14 , ANC_ID_15 , ANC_ID_16 , ANC_ID_17 , ANC_ID_18 , ANC_ID_19 , ANC_ID_20 , ANC_ID_21 , ANC_ID_22 , ANC_ID_23 , ANC_ID_24 , ANC_ID_25 , ANC_ID_26 , ANC_ID_27 , ANC_ID_28 , ANC_ID_29 , ANC_ID_30 , ANC_ID_31 , ANC_ID_32 , ANC_ID_33 , ANC_ID_34 , ANC_ID_35 , ANC_ID_36 , ANC_ID_37 , ANC_ID_38 , ANC_ID_39 , ANC_ID_40 , ANC_ID_41 , ANC_ID_42 , ANC_ID_43 , ANC_ID_44 , ANC_ID_45 , ANC_ID_46 , ANC_ID_47 , ANC_ID_48 , ANC_ID_49 , ANC_ID_50 , ANC_ID_51 , ANC_ID_52 , ANC_ID_53 , ANC_ID_54 , ANC_ID_55 , ANC_ID_56 , ANC_ID_57 , ANC_ID_58 , ANC_ID_59 , ANC_ID_60 , ANC_ID_61 , ANC_ID_62 , ANC_ID_63 , ANC_ID_64 , ANC_ID_65 , ANC_ID_66 , ANC_ID_67 , ANC_ID_68 , ANC_ID_69 , ANC_ID_70 , ANC_ID_71 , ANC_ID_72 , ANC_ID_73 , ANC_ID_74 , ANC_ID_75 , ANC_ID_76 , ANC_ID_77 , ANC_ID_78 , ANC_ID_79 , ANC_ID_80 , ANC_ID_81 , ANC_ID_82 , ANC_ID_83 , ANC_ID_84 , ANC_ID_85 , ANC_ID_86 , ANC_ID_87 , ANC_ID_88 , ANC_ID_89 , ANC_ID_90 , ANC_ID_91 , ANC_ID_92 , ANC_ID_93 , ANC_ID_94 , ANC_ID_95 , ANC_ID_96 , ANC_ID_97 , ANC_ID_98 , ANC_ID_99 , ANC_ID_100 , BALANCE_TYPE_CODE , LEDGER_ID , EVENT_NUMBER , ENTITY_ID , REVERSAL_CODE , ENCUMBRANCE_TYPE_ID ,
      MO_GLOB_ORG_ACCESS_TMP2115714419STANDARD@ebizapps.com.ph (TNS V1-V3)INSERT INTO MO_GLOB_ORG_ACCESS_TMP (ORGANIZATION_ID , ORGANIZATION_NAME) VALUES (:B1 , :B2 )
      MGMT_DB_FILE_GTT1147314248perl@ebizdb.com.ph (TNS V1-V3)insert into mgmt_db_file_gtt select   f.tablespace_name, (f.bytes)/1048576 meg, (f.maxbytes)/1048576 maxmeg, f.file_name, f.file_id,     ts.ts#, ts.blocksize,     0 from     sys.ts$ ts, sys.dba_data_files f  where    ts.contents$ = 0  and f.tablespace_name = ts.name
      XLA_DISTRIBUTION_LINKS6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_ACCOUNTING_ERRORS6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS_GT6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVENTS6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_DISTRIBUTION_LINKS6833472431FPPCCREATEACCT@ebizapps.com.ph (TNS V1DELETE /*+ index(xdl,XLA_DISTRIBUTION_LINKS_N3) */ FROM XLA_DISTRIBUTION_LINKS XDL WHERE AE_HEADER_ID IN (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ XH.AE_HEADER_ID FROM XLA_EVENTS_GT XE, XLA_AE_HEADERS XH WHERE XE.PROCESS_STATUS_CODE IN ('D','E','R','I') AND XH.APPLICATION_ID = XE.APPLICATION_ID AND XH.EVENT_ID = XE.EVENT_ID ) AND APPLICATION_ID = :B1
      XLA_EVT_CLASS_ORDERS_GT37040352395JDBC Thin ClientDeclare
      l_flag Boolean;
      BEGIN
      l_flag := XLA_CREATE_ACCT_RPT_PVT.BeforeReport ;
      if (l_flag) then
      :XDO_OUT_PARAMETER := 1;
      end if;
      end;
      MO_GLOB_ORG_ACCESS_TMP121218115717WSCMTM@ebizapps.com.ph (TNS V1-V3)INSERT INTO MO_GLOB_ORG_ACCESS_TMP (ORGANIZATION_ID , ORGANIZATION_NAME) VALUES (:B1 , :B2 )
      MO_GLOB_ORG_ACCESS_TMP226201316181CMCTCM@ebizapps.com.ph (TNS V1-V3)INSERT INTO MO_GLOB_ORG_ACCESS_TMP (ORGANIZATION_ID , ORGANIZATION_NAME) VALUES (:B1 , :B2 )