803: -- Hardcode the Low and High Transaction dates if they are null.
804: IF G_REPORTING_LEVEL IS NOT NULL THEN
805: L_REPORTING_CONTEXT_VAL := ' '||TO_CHAR(G_REPORTING_CONTEXT)||' ';
806:
807: FND_MO_REPORTING_API.INITIALIZE (
808: p_reporting_level =>G_REPORTING_LEVEL,
809: p_reporting_entity_id => G_REPORTING_CONTEXT,
810: p_pred_type =>'AUTO');
811:
811:
812:
813: IF (g_level_procedure >= g_current_runtime_level ) THEN
814: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
815: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
816: END IF;
817:
818: -- Check with Kripa --skorrapa
819:
817:
818: -- Check with Kripa --skorrapa
819:
820:
821: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
822: IF (g_level_procedure >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
825: END IF;
820:
821: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
822: IF (g_level_procedure >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',
824: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
825: END IF;
826:
827: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'ORG_ID','INTERNAL_ORGANIZATION_ID');
828:
833:
834:
835: -- L_WHERE_REPORTING_CONTEXT_TRXH := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;
836: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
835: -- L_WHERE_REPORTING_CONTEXT_TRXH := 'AND ZX_DET.INTERNAL_ORGANIZATION_ID '||l_get_org_id;
836: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
837: -- FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
838: L_WHERE_REPORTING_CONTEXT_VAT :=
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
839: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
840: L_WHERE_REPORTING_CONTEXT_EX :=
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
841: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
842: L_WHERE_REPORTING_CONTEXT_TYP :=
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
843: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
844: L_WHERE_REPORTING_CONTEXT_BS :=
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
845: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
846: L_WHERE_REPORTING_CONTEXT_ADJ :=
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
852: END IF;
853:
847: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
848: L_WHERE_REPORTING_CONTEXT_CS :=
849: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
850: L_WHERE_REPORTING_CONTEXT_TH :=
851: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
852: END IF;
853:
854: IF (g_level_procedure >= g_current_runtime_level ) THEN
855: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_ACTG_EXTRACT_PKG.BUILD_SQL',