eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_EXTRACT_PKG dependencies on FND_MO_REPORTING_API

Line 858: FND_MO_REPORTING_API.INITIALIZE (

854: -- Hardcode the Low and High Transaction dates if they are null.
855: IF G_REPORTING_LEVEL IS NOT NULL THEN
856: L_REPORTING_CONTEXT_VAL := ' '||TO_CHAR(G_REPORTING_CONTEXT)||' ';
857:
858: FND_MO_REPORTING_API.INITIALIZE (
859: p_reporting_level =>G_REPORTING_LEVEL,
860: p_reporting_entity_id => G_REPORTING_CONTEXT,
861: p_pred_type =>'AUTO');
862:

Line 866: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');

862:
863:
864: IF (g_level_procedure >= g_current_runtime_level ) THEN
865: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
866: 'After FND_MO_REPORTING_API.INITIALIZE Call : ');
867: END IF;
868:
869: -- Check with Kripa --skorrapa
870:

Line 871: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);

867: END IF;
868:
869: -- Check with Kripa --skorrapa
870:
871: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
872: IF (g_level_procedure >= g_current_runtime_level ) THEN
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
874: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
875: END IF;

Line 874: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);

870:
871: l_fnd_mo_org_stg := FND_MO_REPORTING_API.GET_PREDICATE('ZX_DET',NULL,L_REPORTING_CONTEXT_VAL);
872: IF (g_level_procedure >= g_current_runtime_level ) THEN
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_AR_EXTRACT_PKG.build_sql',
874: 'After FND_MO_REPORTING_API.GET_PREDICATE Call = '||l_fnd_mo_org_stg);
875: END IF;
876:
877: IF instr(l_fnd_mo_org_stg,'ORG_ID') = 0 THEN
878: l_internal_org_stg:= REPLACE(l_fnd_mo_org_stg,'org_id','INTERNAL_ORGANIZATION_ID');

Line 893: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);

889:
890: IF G_REPORTING_LEVEL IN ('1000','3000') THEN
891: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
892: L_WHERE_REPORTING_CONTEXT_VAT :=
893: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
894: L_WHERE_REPORTING_CONTEXT_EX :=
895: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
896: L_WHERE_REPORTING_CONTEXT_TYP :=
897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);

Line 895: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);

891: L_WHERE_REPORTING_CONTEXT_TRXH := l_internal_org_stg;
892: L_WHERE_REPORTING_CONTEXT_VAT :=
893: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
894: L_WHERE_REPORTING_CONTEXT_EX :=
895: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
896: L_WHERE_REPORTING_CONTEXT_TYP :=
897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
898: L_WHERE_REPORTING_CONTEXT_BS :=
899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);

Line 897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);

893: FND_MO_REPORTING_API.GET_PREDICATE('VAT',NULL,L_REPORTING_CONTEXT_VAL);
894: L_WHERE_REPORTING_CONTEXT_EX :=
895: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
896: L_WHERE_REPORTING_CONTEXT_TYP :=
897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
898: L_WHERE_REPORTING_CONTEXT_BS :=
899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
900: L_WHERE_REPORTING_CONTEXT_ADJ :=
901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);

Line 899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);

895: FND_MO_REPORTING_API.GET_PREDICATE('EX',NULL,L_REPORTING_CONTEXT_VAL);
896: L_WHERE_REPORTING_CONTEXT_TYP :=
897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
898: L_WHERE_REPORTING_CONTEXT_BS :=
899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
900: L_WHERE_REPORTING_CONTEXT_ADJ :=
901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
902: L_WHERE_REPORTING_CONTEXT_CS :=
903: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);

Line 901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);

897: FND_MO_REPORTING_API.GET_PREDICATE('TYPES',NULL,L_REPORTING_CONTEXT_VAL);
898: L_WHERE_REPORTING_CONTEXT_BS :=
899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
900: L_WHERE_REPORTING_CONTEXT_ADJ :=
901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
902: L_WHERE_REPORTING_CONTEXT_CS :=
903: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
904: L_WHERE_REPORTING_CONTEXT_TH :=
905: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);

Line 903: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);

899: FND_MO_REPORTING_API.GET_PREDICATE('BS',NULL,L_REPORTING_CONTEXT_VAL);
900: L_WHERE_REPORTING_CONTEXT_ADJ :=
901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
902: L_WHERE_REPORTING_CONTEXT_CS :=
903: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
904: L_WHERE_REPORTING_CONTEXT_TH :=
905: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
906: ELSE
907: L_WHERE_REPORTING_CONTEXT_TRXH := ' AND NULL IS NULL';

Line 905: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);

901: FND_MO_REPORTING_API.GET_PREDICATE('ADJ',NULL,L_REPORTING_CONTEXT_VAL);
902: L_WHERE_REPORTING_CONTEXT_CS :=
903: FND_MO_REPORTING_API.GET_PREDICATE('ARCS',NULL,L_REPORTING_CONTEXT_VAL);
904: L_WHERE_REPORTING_CONTEXT_TH :=
905: FND_MO_REPORTING_API.GET_PREDICATE('TH',NULL,L_REPORTING_CONTEXT_VAL);
906: ELSE
907: L_WHERE_REPORTING_CONTEXT_TRXH := ' AND NULL IS NULL';
908: L_WHERE_REPORTING_CONTEXT_VAT := ' AND NULL IS NULL';
909: L_WHERE_REPORTING_CONTEXT_EX := ' AND NULL IS NULL';