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.POA_DBI_CUT_PKG dependencies on FND_GLOBAL

Line 909: l_sel_clause := l_sel_clause || fnd_global.newline ||'

905: oset.POA_MEASURE8 POA_MEASURE8, --Total Non-Contract Purchases Rate
906: oset.POA_MEASURE9 POA_MEASURE9, --Total Change';
907:
908: if(p_view_by_dim = 'FII_COMPANIES+FII_COMPANIES' or p_view_by_dim = 'ORGANIZATION+HRI_CL_ORGCC') then
909: l_sel_clause := l_sel_clause || fnd_global.newline ||'
910: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE4,
911: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE5,';
912: else
913: l_sel_clause := l_sel_clause || fnd_global.newline ||

Line 913: l_sel_clause := l_sel_clause || fnd_global.newline ||

909: l_sel_clause := l_sel_clause || fnd_global.newline ||'
910: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE4,
911: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE5,';
912: else
913: l_sel_clause := l_sel_clause || fnd_global.newline ||
914: 'null POA_ATTRIBUTE4,'||fnd_global.newline||
915: 'null POA_ATTRIBUTE5,'||fnd_global.newline;
916: end if;
917:

Line 914: 'null POA_ATTRIBUTE4,'||fnd_global.newline||

910: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE4,
911: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE5,';
912: else
913: l_sel_clause := l_sel_clause || fnd_global.newline ||
914: 'null POA_ATTRIBUTE4,'||fnd_global.newline||
915: 'null POA_ATTRIBUTE5,'||fnd_global.newline;
916: end if;
917:
918: if (p_sec_context = 'COMP') then

Line 915: 'null POA_ATTRIBUTE5,'||fnd_global.newline;

911: decode(v.summary_flag,''Y'',''pFunctionName=POA_DBI_CC_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'',null) POA_ATTRIBUTE5,';
912: else
913: l_sel_clause := l_sel_clause || fnd_global.newline ||
914: 'null POA_ATTRIBUTE4,'||fnd_global.newline||
915: 'null POA_ATTRIBUTE5,'||fnd_global.newline;
916: end if;
917:
918: if (p_sec_context = 'COMP') then
919: l_sel_clause := l_sel_clause ||'

Line 928: l_sel_clause := l_sel_clause || fnd_global.newline || 'from

924: ''pFunctionName=POA_DBI_CUT_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+POA_ITEMS&pParamIds=Y'' POA_ATTRIBUTE6,
925: ''pFunctionName=POA_DBI_CUD_NCP_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7 ';
926: end if;
927:
928: l_sel_clause := l_sel_clause || fnd_global.newline || 'from
929: (select (rank() over
930: ( &ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;
931:
932: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 1469: l_sel_clause := 'select cal.name VIEWBY,'||fnd_global.newline;

1465: is
1466: l_sel_clause varchar2(4000);
1467: begin
1468: if (p_type = 'trend') then
1469: l_sel_clause := 'select cal.name VIEWBY,'||fnd_global.newline;
1470: else
1471: l_sel_clause := 'select cal_name VIEWBY,'||fnd_global.newline;
1472: end if;
1473: l_sel_clause := l_sel_clause ||

Line 1471: l_sel_clause := 'select cal_name VIEWBY,'||fnd_global.newline;

1467: begin
1468: if (p_type = 'trend') then
1469: l_sel_clause := 'select cal.name VIEWBY,'||fnd_global.newline;
1470: else
1471: l_sel_clause := 'select cal_name VIEWBY,'||fnd_global.newline;
1472: end if;
1473: l_sel_clause := l_sel_clause ||
1474: 'nvl(c_purchase_amt,0) POA_MEASURE1,
1475: p_purchase_amt POA_MEASURE2,

Line 1665: null POA_MEASURE4 -- (Obsoleted)Change '||fnd_global.newline;

1661: ' || poa_dbi_util_pkg.change_clause(poa_dbi_util_pkg.rate_clause('c_contract_amt','c_purchase_amt'),poa_dbi_util_pkg.rate_clause('p_contract_amt','p_purchase_amt'),'P') || ' POA_MEASURE2,
1662: ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt','c_purchase_amt') || ' POA_PERCENT2,
1663: ' || poa_dbi_util_pkg.change_clause(poa_dbi_util_pkg.rate_clause('c_n_contract_amt','c_purchase_amt'),poa_dbi_util_pkg.rate_clause('p_n_contract_amt','p_purchase_amt'),'P') || ' POA_MEASURE3,
1664: null POA_PERCENT3, -- (Obsoleted)Contract Leakage Rate
1665: null POA_MEASURE4 -- (Obsoleted)Change '||fnd_global.newline;
1666: return l_sel_clause;
1667: END;
1668:
1669: