APPS.GCS_INTERCO_DYN_BUILD_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 155

                          ''Intercompany- Inserting entry lines''
			   || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by company-Receivables side''
                          );

Line: 162

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
       , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID )
       SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
          INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
          INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
          INDEX (FB FEM_BALANCES_P)
          USE_NL(GCR FB)*/
          gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 309

                          ''Intercompany- Inserting entry lines''
			   || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by company - Payabales side''
                          );

Line: 315

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
       , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID )
       SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
          INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
          INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
          INDEX (FB FEM_BALANCES_P)
          USE_NL(GCR FB)*/
              gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 481

                          ''Intercompany- Inserting entry lines''
			   || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by Org-Receivables side''
                          );

Line: 497

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
        , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID)
       SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
          INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
          INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
          INDEX (FB FEM_BALANCES_P)
          USE_NL(GCR FB)*/
          gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 664

                          ''Intercompany- Inserting entry lines''
			   || '' into GCS_ENTRY_LINES''
                           || '' after matching by Org-Payables side''
                          );

Line: 680

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
       , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID)
       SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
          INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
          INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
          INDEX (FB FEM_BALANCES_P)
          USE_NL(GCR FB)*/
               gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 850

                          ''Intracompany- Inserting entry lines''
			   || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by company''
                          );

Line: 856

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
       , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID)
       SELECT /*+ ORDERED FULL(GIHG)
                INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
                INDEX(GIM GCS_INTERCO_MEMBERS_U1)
                INDEX (FB FEM_BALANCES_P)
                USE_NL(GIET FB)*/
           gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 943

        AND NOT EXISTS (SELECT 1
                FROM   GCS_INTERCO_ELM_TRX giet3,
                       GCS_INTERCO_MEMBERS gim2
                WHERE giet3.hierarchy_id = p_hierarchy_id
                AND   giet3.cal_period_id = p_cal_period_id
                AND   giet3.src_entity_id = giet3.target_entity_id
                AND   giet3.src_entity_id = giet.src_entity_id
                AND   giet3.line_item_id = giet.line_item_id
                AND   giet3.src_company_id = giet.src_company_id
                AND   giet3.target_company_id = giet.target_company_id
 ';

Line: 1056

                          ''Intracompany- Inserting entry lines''
			   || ''into GCS_ENTRY_LINES_GT''
                           || ''after matching by Org''
                          );

Line: 1072

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , LINE_ITEM_Id, INTERCOMPANY_ID, FINANCIAL_ELEM_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
       , DESCRIPTION , YTD_BALANCE_E,RECEIVABLES_ORG_ID,
         PAYABLES_ORG_ID )
       SELECT /*+ ORDERED FULL(GIHG)
                INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
                INDEX(GIM GCS_INTERCO_MEMBERS_U1)
                INDEX (FB FEM_BALANCES_P)
                USE_NL(GIET FB)*/
                gihg.entry_id, giet.company_cost_center_org_id
              , giet.line_item_id
              , giet.intercompany_id,
';

Line: 1159

        AND NOT EXISTS (SELECT 1
                FROM   GCS_INTERCO_ELM_TRX giet3,
                       GCS_INTERCO_MEMBERS gim2
                WHERE giet3.hierarchy_id = p_hierarchy_id
                AND   giet3.cal_period_id = p_cal_period_id
                AND     giet3.src_entity_id = giet3.target_entity_id
                AND     giet3.src_entity_id = giet.src_entity_id
                AND   giet3.line_item_id = giet.line_item_id
                 AND   giet3.company_cost_center_org_id =
                                      giet.company_cost_center_org_id
                AND   giet3.intercompany_id = giet.intercompany_id
';

Line: 1419

                          ''Intercompany- Inserting necessary suspense lines''
                           || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by company''
                          );

Line: 1436

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
       , DESCRIPTION, YTD_BALANCE_E)
       SELECT gihg1.entry_id
            , MAX(Receivables_org_id)
             , MAX(gihg1.sus_financial_elem_id), MAX(gihg1.sus_line_item_id)
            , MAX(payables_org_id),
';

Line: 1583

                          ''Intercompany- Inserting necessary suspense lines''
                           || '' into GCS_ENTRY_LINES_GT''
                           || '' after matching by org ''
                          );

Line: 1600

       INSERT INTO  GCS_ENTRY_LINES_GT
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
       , DESCRIPTION , YTD_BALANCE_E)
       SELECT gihg1.entry_id, MAX(Receivables_org_id),
              MAX(gihg1.sus_financial_elem_id),
              MAX(gihg1.sus_line_item_id), MAX(payables_org_id),
';

Line: 1725

                          ''Intercompany- Inserting ''
                           || '' into GCS_ENTRY_LINES''
                           || '' after processing''
                          );

Line: 1742

       INSERT INTO  GCS_ENTRY_LINES
       ( ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
       , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE
       , LAST_UPDATED_BY, LAST_UPDATE_LOGIN
       , DESCRIPTION, YTD_BALANCE_E)
';

Line: 1764

        SELECT    ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
       , SYSDATE, g_fnd_user_id
       , SYSDATE, g_fnd_user_id, g_fnd_login_id
       , DESCRIPTION, YTD_BALANCE_E
       FROM GCS_ENTRY_LINES_GT
       WHERE DESCRIPTION <> ''SUSPENSE_LINE''
';

Line: 1790

         SELECT    ENTRY_ID, COMPANY_COST_CENTER_ORG_ID
       , FINANCIAL_ELEM_ID, LINE_ITEM_Id, INTERCOMPANY_ID
       , PRODUCT_ID, NATURAL_ACCOUNT_ID, CHANNEL_ID
       , PROJECT_ID, CUSTOMER_ID, TASK_ID, USER_DIM1_ID
       , USER_DIM2_ID, USER_DIM3_ID, USER_DIM4_ID
       , USER_DIM5_ID, USER_DIM6_ID, USER_DIM7_ID
       , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
       , YTD_DEBIT_BALANCE_E , YTD_CREDIT_BALANCE_E
       , SYSDATE, g_fnd_user_id
       , SYSDATE, g_fnd_user_id, g_fnd_login_id
       , DESCRIPTION, YTD_BALANCE_E
       FROM GCS_ENTRY_LINES_GT
       WHERE (DESCRIPTION = ''SUSPENSE_LINE'' AND YTD_BALANCE_E <> 0);

Line: 1958

  PROCEDURE INSERT_INTERCO_TRX(p_entry_id In NUMBER,
                               p_stat_entry_id IN NUMBER,
                               p_hierarchy_id IN NUMBER,
                               p_period_end_date  IN  DATE,
                               x_errbuf OUT NOCOPY VARCHAR2,
                               x_retcode OUT NOCOPY VARCHAR2) IS

    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 1967

    l_api_name 		VARCHAR2(50) := ''INSERT_INTERCO_TRX'';

Line: 2037

	       SELECT  ghb.ie_by_org_code,
                       DECODE(gcb.specific_intercompany_id, NULL,
                                              ''N'', ''SPECIFIC_VALUE''),
                       gcb.specific_intercompany_id,
                       ghb.lob_reporting_enabled_flag,
                       ghb.lob_hierarchy_obj_id,
		       ghb.lob_dim_column_name
 	       INTO   x_match_rule_code,
                      x_intercompany_org_code,
                      x_specific_intercompany_id,
                      x_lob_reporting_enabled,
                      x_lob_hierarchy_obj_id,
		      x_lob_dim_column_name
 	       FROM GCS_HIERARCHIES_B ghb, gcs_categories_b gcb
	       WHERE ghb.hierarchy_id = p_hierarchy_id
               AND   gcb.category_code = ''INTRACOMPANY''
               AND   rownum = 1;

Line: 2116

        SELECT object_definition_id INTO l_valid_hierarchy_id
        FROM FEM_OBJECT_DEFINITION_B fod
        WHERE  fod.object_id = x_lob_hierarchy_obj_id
        AND    (p_period_end_date
                BETWEEN NVL(fod.effective_start_date,
                      TO_DATE(''01/01/1950'',''MM/DD/YYYY''))
	               AND NVL(fod.effective_end_date,
                         TO_DATE(''12/31/9999'',''MM/DD/YYYY'')));

Line: 2173

	             ''Inserting intercompany transactions for matching by''
	            || '' organization into GCS_INTERCO_ELM_TRX''
                    || '' - LOB REPORTING ENABLED '');

Line: 2177

	   Insert INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code,  line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login, elim_lob_id)
';

Line: 2204

	   SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
	          geo1.entity_id, NULL, NULL, gel.intercompany_id,
                  NULL,NULL, geo.entity_id, geh.currency_code,
	          gel.line_item_id,
';

Line: 2301

                        SELECT fcch1.parent_id
                        FROM  fem_user_dim1_hier fcch1,
                              fem_user_dim1_hier fcch2
                        WHERE  fcch1.child_id =
                                            fcoa2.dim_attribute_numeric_member
                        AND    fcch1.hierarchy_obj_def_id =
                                     l_valid_hierarchy_id
                        AND    fcch1.parent_id <> fcch1.child_id
                                          -- *** To eliminte self rows
                        AND    fcch2.child_id =
                                        fcoa3.dim_attribute_numeric_member
                        AND    fcch2.hierarchy_obj_def_id =
                                                l_valid_hierarchy_id
                        AND    fcch2.parent_id <> fcch2.child_id
                                            -- *** To eliminte self rows
                        AND    fcch1.parent_id = fcch2.parent_id
                        AND    fcch1.parent_depth_num =
                               (SELECT MAX(fcch3.parent_depth_num)
                                FROM  fem_user_dim1_hier fcch3,
                                      fem_user_dim1_hier fcch4
                                WHERE fcch3.child_id =
                                       fcoa2.dim_attribute_numeric_member
                                AND    fcch3.hierarchy_obj_def_id =
                                                       l_valid_hierarchy_id
                                AND    fcch3.parent_id <> fcch3.child_id
                                          -- *** To eliminte self rows
                                AND    fcch4.child_id =
                                           fcoa3.dim_attribute_numeric_member
                                AND    fcch4.hierarchy_obj_def_id =
                                                    l_valid_hierarchy_id
                                AND    fcch4.parent_id <> fcch4.child_id
                                            -- *** To eliminte self rows
                                AND    fcch3.parent_id = fcch4.parent_id
                                                                   ))
';

Line: 2346

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.intercompany_id = gel.intercompany_id
  ';

Line: 2408

	             ''Inserting intercompany transactions for matching by''
	            || '' organization into GCS_INTERCO_ELM_TRX''
                    || '' - LOB REPORTING ENABLED '');

Line: 2412

	   Insert INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code,  line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login, elim_lob_id)
';

Line: 2439

	   SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
	          geo1.entity_id, NULL, NULL, gel.intercompany_id,
                  NULL,NULL, geo.entity_id, geh.currency_code,
	          gel.line_item_id,
';

Line: 2536

                        SELECT fcch1.parent_id
                        FROM  fem_user_dim1_hier fcch1,
                              fem_user_dim1_hier fcch2
                        WHERE  fcch1.child_id =
                                            fcoa2.dim_attribute_numeric_member
                        AND    fcch1.hierarchy_obj_def_id =
                                     l_valid_hierarchy_id
                        AND    fcch1.parent_id <> fcch1.child_id
                                          -- *** To eliminte self rows
                        AND    fcch2.child_id =
                                        fcoa3.dim_attribute_numeric_member
                        AND    fcch2.hierarchy_obj_def_id =
                                                l_valid_hierarchy_id
                        AND    fcch2.parent_id <> fcch2.child_id
                                            -- *** To eliminte self rows
                        AND    fcch1.parent_id = fcch2.parent_id
                        AND    fcch1.parent_depth_num =
                               (SELECT MAX(fcch3.parent_depth_num)
                                FROM  fem_user_dim1_hier fcch3,
                                      fem_user_dim1_hier fcch4
                                WHERE fcch3.child_id =
                                       fcoa2.dim_attribute_numeric_member
                                AND    fcch3.hierarchy_obj_def_id =
                                                       l_valid_hierarchy_id
                                AND    fcch3.parent_id <> fcch3.child_id
                                          -- *** To eliminte self rows
                                AND    fcch4.child_id =
                                           fcoa3.dim_attribute_numeric_member
                                AND    fcch4.hierarchy_obj_def_id =
                                                    l_valid_hierarchy_id
                                AND    fcch4.parent_id <> fcch4.child_id
                                            -- *** To eliminte self rows
                                AND    fcch3.parent_id = fcch4.parent_id
                                                                   ))
';

Line: 2581

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.intercompany_id = gel.intercompany_id
  ';

Line: 2646

	             ''Inserting intercompany transactions for matching by''
	            || '' organization into GCS_INTERCO_ELM_TRX''
                    || '' - LOB REPORTING Disabled'');

Line: 2663

	   Insert INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code,  line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login)
';

Line: 2690

	   SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
	          geo1.entity_id, NULL, NULL, gel.intercompany_id,
                  NULL,NULL, geo.entity_id, geh.currency_code,
	          gel.line_item_id,
';

Line: 2757

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.intercompany_id = gel.intercompany_id
  ';

Line: 2803

	             ''Inserting intercompany transactions for matching by''
	            || '' organization into GCS_INTERCO_ELM_TRX''
                    || '' - LOB REPORTING Disabled'');

Line: 2820

	   Insert INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code,  line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login)
';

Line: 2847

	   SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
	          geo1.entity_id, NULL, NULL, gel.intercompany_id,
                  NULL,NULL, geo.entity_id, geh.currency_code,
	          gel.line_item_id,
';

Line: 2914

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.intercompany_id = gel.intercompany_id
  ';

Line: 2978

	          ||'' Inserting intercompany transactions for matching by''
	          ||'' company intercompany into GCS_INTERCO_ELM_TRX'');

Line: 2995

	   Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
                  INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code, line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login)
';

Line: 3023

           SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
                  geo1.entity_id,fcoa2.dim_attribute_numeric_member, NULL,
                  gel.intercompany_id,
                  fcoa3.dim_attribute_numeric_member, NULL, geo.entity_id,
                  geh.currency_code, gel.line_item_id,

';

Line: 3118

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_company_id =
                                fcoa2.dim_attribute_numeric_member
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.target_company_id =
                                fcoa3.dim_attribute_numeric_member
                 AND    giet1.intercompany_id = gel.intercompany_id
';

Line: 3187

	          ||''Inserting intercompany transactions for matching by''
	          ||'' company intercompany into GCS_INTERCO_ELM_TRX'');

Line: 3204

	   Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
                  INTO gcs_interco_elm_trx
	         (hierarchy_id, cal_period_id,  company_cost_center_org_id,
                  src_entity_id, src_company_id, src_cost_center_id,
                  intercompany_id, target_company_id,
	          target_cost_center_id, target_entity_id,
                  currency_code, line_item_id, financial_elem_id,
                  product_id, natural_account_id, channel_id,
                  project_id, customer_id, task_id,
	          user_dim1_id, user_dim2_id, user_dim3_id,
                  user_dim4_id, user_dim5_id, user_dim6_id,
	          user_dim7_id, user_dim8_id, user_dim9_id,
                  user_dim10_id,creation_date,
	          created_by, last_update_date, last_updated_by,
                  last_update_login)
';

Line: 3232

           SELECT DISTINCT geh.hierarchy_id, geh.start_cal_period_id,
                  gel.company_cost_center_org_id,
                  geo1.entity_id,fcoa2.dim_attribute_numeric_member, NULL,
                  gel.intercompany_id,
                  fcoa3.dim_attribute_numeric_member, NULL, geo.entity_id,
                  geh.currency_code, gel.line_item_id,

';

Line: 3328

                 AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
                 WHERE  giet1.hierarchy_id = geh.hierarchy_id
                 AND    giet1.cal_period_id = geh.start_cal_period_id
                 AND    giet1.company_cost_center_org_id =
                                       gel.company_cost_center_org_id
                 AND    giet1.src_company_id =
                                fcoa2.dim_attribute_numeric_member
                 AND    giet1.src_entity_id = geo1.entity_id
                 AND    giet1.target_entity_id = geo.entity_id
                 AND    giet1.target_company_id =
                                fcoa3.dim_attribute_numeric_member
                 AND    giet1.intercompany_id = gel.intercompany_id
';

Line: 3520

 END INSERT_INTERCO_TRX;