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_FR_PKG dependencies on FND_GLOBAL

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

142: ,'PO'
143: ,'7.1');
144: if(p_view_by_dim = 'ITEM+POA_ITEMS')
145: then
146: l_sel_clause := l_sel_clause || fnd_global.newline ||
147: 'v.description POA_ATTRIBUTE3, --Description
148: v2.description POA_ATTRIBUTE4, --UOM
149: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
150: else

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

147: 'v.description POA_ATTRIBUTE3, --Description
148: v2.description POA_ATTRIBUTE4, --UOM
149: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
150: else
151: l_sel_clause := l_sel_clause || fnd_global.newline ||
152: 'null POA_ATTRIBUTE3, --Description
153: null POA_ATTRIBUTE4, --UOM
154: null POA_ATTRIBUTE5, --Quantity';
155: end if;

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

153: null POA_ATTRIBUTE4, --UOM
154: null POA_ATTRIBUTE5, --Quantity';
155: end if;
156:
157: l_sel_clause := l_sel_clause || fnd_global.newline ||
158: 'oset.POA_MEASURE1 POA_MEASURE1, --Fulfilled Lines
159: oset.POA_MEASURE10 POA_MEASURE10, --Fulfilled Lines Prior
160: oset.POA_PERCENT1 POA_PERCENT1, --Fulf Lines Change
161: oset.POA_MEASURE2 POA_MEASURE2, --Manual Lines

Line 185: oset.POA_MEASURE15 POA_MEASURE15, --Grand Total for Average Age (Days) Prior '||fnd_global.newline;

181: oset.POA_MEASURE8 POA_MEASURE8, --Grand Total for Fulfilled Amount
182: oset.POA_MEASURE14 POA_MEASURE14, --Grand Total for Fulfilled Amount Prior
183: oset.POA_PERCENT10 POA_PERCENT10, --Grand Total for fulf amt Change
184: oset.POA_MEASURE9 POA_MEASURE9, --Grand Total for Average Age (Days)
185: oset.POA_MEASURE15 POA_MEASURE15, --Grand Total for Average Age (Days) Prior '||fnd_global.newline;
186:
187: l_sel_clause := l_sel_clause ||
188: '''pFunctionName=POA_DBI_FR_SUM_RPT&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE6,
189: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE7,

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

190: ''pFunctionName=POA_DBI_FR_SUM_RPT&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&pCustomView=POA_DBI_FR_SUM_RPT_CV2'' POA_ATTRIBUTE8,
191: ''pFunctionName=POA_DBI_FR_AMT_RPT&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE9,
192: ''pFunctionName=POA_DBI_FR_AGE_RPT&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE10';
193:
194: l_sel_clause := l_sel_clause|| fnd_global.newline||'from
195: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,'
196: ||fnd_global.newline|| ' ' || p_view_by_col;
197:
198: if(p_view_by_dim = 'ITEM+POA_ITEMS')

Line 196: ||fnd_global.newline|| ' ' || p_view_by_col;

192: ''pFunctionName=POA_DBI_FR_AGE_RPT&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE10';
193:
194: l_sel_clause := l_sel_clause|| fnd_global.newline||'from
195: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,'
196: ||fnd_global.newline|| ' ' || p_view_by_col;
197:
198: if(p_view_by_dim = 'ITEM+POA_ITEMS')
199: then
200: l_sel_clause := l_sel_clause ||',

Line 256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||

252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||
258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,

Line 257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||

253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||
258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,

Line 271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||

267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';

Line 272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||

268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';
276:

Line 273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||

269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';
276:
277: return l_sel_clause;

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

416: ,'PO'
417: ,'7.1');
418: if(p_view_by_dim = 'ITEM+POA_ITEMS')
419: then
420: l_sel_clause := l_sel_clause || fnd_global.newline ||
421: 'v.description POA_ATTRIBUTE3, --Description
422: v2.description POA_ATTRIBUTE4, --UOM
423: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
424: else

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

421: 'v.description POA_ATTRIBUTE3, --Description
422: v2.description POA_ATTRIBUTE4, --UOM
423: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
424: else
425: l_sel_clause := l_sel_clause || fnd_global.newline ||
426: 'null POA_ATTRIBUTE3, --Description
427: null POA_ATTRIBUTE4, --UOM
428: null POA_ATTRIBUTE5, -- Quantity';
429: end if;

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

427: null POA_ATTRIBUTE4, --UOM
428: null POA_ATTRIBUTE5, -- Quantity';
429: end if;
430:
431: l_sel_clause := l_sel_clause || fnd_global.newline ||
432: 'oset.POA_MEASURE1 POA_MEASURE1, --Fulfilled Lines
433: oset.POA_PERCENT1 POA_PERCENT1, --fulf lines Change
434: oset.POA_MEASURE2 POA_MEASURE2, --Manual Lines
435: oset.POA_PERCENT2 POA_PERCENT2, --Manual Lines Rate

Line 448: oset.POA_MEASURE7 POA_MEASURE7, --Grand Total for Percent Past Expected Date'||fnd_global.newline;

444: oset.POA_MEASURE6 POA_MEASURE6, --Grand Total for Manual Lines
445: oset.POA_PERCENT6 POA_PERCENT6, --Grand Total for Manual Lines Rate
446: oset.POA_PERCENT7 POA_PERCENT7, --Grand Tot man lines rate Change
447: oset.POA_PERCENT8 POA_PERCENT8, --Grand Total for Past Expected Date
448: oset.POA_MEASURE7 POA_MEASURE7, --Grand Total for Percent Past Expected Date'||fnd_global.newline;
449:
450: l_sel_clause := l_sel_clause ||
451: '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE6,
452: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE7,

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

451: '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE6,
452: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE7,
453: ''pFunctionName=POA_DBI_FR_PED_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=3'' POA_ATTRIBUTE8';
454:
455: l_sel_clause := l_sel_clause||fnd_global.newline||'from
456: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,'
457: ||fnd_global.newline|| ' ' || p_view_by_col;
458:
459: if(p_view_by_dim = 'ITEM+POA_ITEMS')

Line 457: ||fnd_global.newline|| ' ' || p_view_by_col;

453: ''pFunctionName=POA_DBI_FR_PED_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=3'' POA_ATTRIBUTE8';
454:
455: l_sel_clause := l_sel_clause||fnd_global.newline||'from
456: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,'
457: ||fnd_global.newline|| ' ' || p_view_by_col;
458:
459: if(p_view_by_dim = 'ITEM+POA_ITEMS')
460: then
461: l_sel_clause := l_sel_clause ||',

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

651: ,'PO'
652: ,'7.1');
653: if(p_view_by_dim = 'ITEM+POA_ITEMS')
654: then
655: l_sel_clause := l_sel_clause || fnd_global.newline ||
656: 'v.description POA_ATTRIBUTE3, --Description
657: v2.description POA_ATTRIBUTE4, --UOM
658: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
659: else

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

656: 'v.description POA_ATTRIBUTE3, --Description
657: v2.description POA_ATTRIBUTE4, --UOM
658: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
659: else
660: l_sel_clause := l_sel_clause || fnd_global.newline ||
661: 'null POA_ATTRIBUTE3, --Description
662: null POA_ATTRIBUTE4, --UOM
663: null POA_ATTRIBUTE5, --Quantity';
664: end if;

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

661: 'null POA_ATTRIBUTE3, --Description
662: null POA_ATTRIBUTE4, --UOM
663: null POA_ATTRIBUTE5, --Quantity';
664: end if;
665: l_sel_clause := l_sel_clause || fnd_global.newline ||
666: 'oset.POA_MEASURE1 POA_MEASURE1, --Fulfilled Amount
667: oset.POA_PERCENT1 POA_PERCENT1, --fulf amt Change
668: oset.POA_MEASURE2 POA_MEASURE2, --Manual Amount
669: oset.POA_PERCENT2 POA_PERCENT2, --Manual Amount Rate

Line 670: oset.POA_PERCENT3 POA_PERCENT3 --Man Amt Rate Change ' || fnd_global.newline

666: 'oset.POA_MEASURE1 POA_MEASURE1, --Fulfilled Amount
667: oset.POA_PERCENT1 POA_PERCENT1, --fulf amt Change
668: oset.POA_MEASURE2 POA_MEASURE2, --Manual Amount
669: oset.POA_PERCENT2 POA_PERCENT2, --Manual Amount Rate
670: oset.POA_PERCENT3 POA_PERCENT3 --Man Amt Rate Change ' || fnd_global.newline
671: || poa_dbi_util_pkg.get_bucket_outer_query(
672: p_bucket_rec
673: , p_col_name => 'oset.POA_PERCENT4'
674: , p_alias_name => 'POA_PERCENT4'

Line 683: || fnd_global.newline ||

679: oset.POA_PERCENT5 POA_PERCENT5, --Grand Total for fulf amt Change
680: oset.POA_MEASURE4 POA_MEASURE4, --Grand Total for Manual Amount
681: oset.POA_PERCENT6 POA_PERCENT6, --Grand Total for Manual Amount Rate
682: oset.POA_PERCENT7 POA_PERCENT7 --Grand tot for man amt rate change '
683: || fnd_global.newline ||
684: poa_dbi_util_pkg.get_bucket_outer_query(
685: p_bucket_rec
686: , p_col_name => 'oset.POA_PERCENT8'
687: , p_alias_name => 'POA_PERCENT8'

Line 690: , p_total_flag => 'N') || fnd_global.newline;

686: , p_col_name => 'oset.POA_PERCENT8'
687: , p_alias_name => 'POA_PERCENT8'
688: , p_prefix => ''
689: , p_suffix => ''
690: , p_total_flag => 'N') || fnd_global.newline;
691:
692: l_sel_clause := l_sel_clause ||
693: poa_dbi_util_pkg.get_bucket_drill_url(
694: p_bucket_rec

Line 698: , p_add_bucket_num => 'Y') || ' ,'|| fnd_global.newline ;

694: p_bucket_rec
695: , 'POA_ATTRIBUTE6'
696: , '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='
697: , ''''
698: , p_add_bucket_num => 'Y') || ' ,'|| fnd_global.newline ;
699:
700: l_sel_clause := l_sel_clause ||
701: '''pFunctionName=POA_DBI_FR_DTL&POA_ATTRIBUTE10=1&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
702: ''pFunctionName=POA_DBI_FR_MAN_DTL&POA_ATTRIBUTE10=2&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE8';

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

700: l_sel_clause := l_sel_clause ||
701: '''pFunctionName=POA_DBI_FR_DTL&POA_ATTRIBUTE10=1&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
702: ''pFunctionName=POA_DBI_FR_MAN_DTL&POA_ATTRIBUTE10=2&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE8';
703:
704: l_sel_clause := l_sel_clause||fnd_global.newline||'from
705: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;
706:
707: if(p_view_by_dim = 'ITEM+POA_ITEMS')
708: then

Line 705: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;

701: '''pFunctionName=POA_DBI_FR_DTL&POA_ATTRIBUTE10=1&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
702: ''pFunctionName=POA_DBI_FR_MAN_DTL&POA_ATTRIBUTE10=2&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE8';
703:
704: l_sel_clause := l_sel_clause||fnd_global.newline||'from
705: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;
706:
707: if(p_view_by_dim = 'ITEM+POA_ITEMS')
708: then
709: l_sel_clause := l_sel_clause ||',

Line 839: || fnd_global.newline

835: then
836: l_bucket_where := 'and (&RANGE_LOW is null or '
837: || 'greatest(0,(fact.req_fulfilled_date-fact.req_approved_date))'
838: || ' >= &RANGE_LOW)'
839: || fnd_global.newline
840: || 'and (&RANGE_HIGH is null or '
841: || 'greatest(0,(fact.req_fulfilled_date-fact.req_approved_date))'
842: || ' < &RANGE_HIGH)';
843:

Line 854: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.req_fulfilled_date is not null ';

850: else
851: l_bucket_where := '';
852: end if;
853:
854: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.req_fulfilled_date is not null ';
855: if (l_option = 2) then --manual reqs
856: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.po_creation_method = ''M'' ';
857: elsif (l_option = 3) then --past-expected-date reqs
858: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.expected_date < fact.req_fulfilled_date ';

Line 856: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.po_creation_method = ''M'' ';

852: end if;
853:
854: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.req_fulfilled_date is not null ';
855: if (l_option = 2) then --manual reqs
856: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.po_creation_method = ''M'' ';
857: elsif (l_option = 3) then --past-expected-date reqs
858: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.expected_date < fact.req_fulfilled_date ';
859: end if;
860:

Line 858: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.expected_date < fact.req_fulfilled_date ';

854: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.req_fulfilled_date is not null ';
855: if (l_option = 2) then --manual reqs
856: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.po_creation_method = ''M'' ';
857: elsif (l_option = 3) then --past-expected-date reqs
858: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.expected_date < fact.req_fulfilled_date ';
859: end if;
860:
861: ---Begin MOAC changes
862: ---Following block is removed from custom_sql as l_where_clause is already

Line 926: || fnd_global.newline || l_where_clause

922: from
923: poa_dbi_req_f fact
924: where fact.req_fulfilled_date between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_EFFECTIVE_END_DATE + (86399/86400)
925: and fact.include_in_ufr = ''Y'' '
926: || fnd_global.newline || l_where_clause
927: || fnd_global.newline || l_bucket_where
928: || fnd_global.newline ||
929: ')
930: ) i,

Line 927: || fnd_global.newline || l_bucket_where

923: poa_dbi_req_f fact
924: where fact.req_fulfilled_date between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_EFFECTIVE_END_DATE + (86399/86400)
925: and fact.include_in_ufr = ''Y'' '
926: || fnd_global.newline || l_where_clause
927: || fnd_global.newline || l_bucket_where
928: || fnd_global.newline ||
929: ')
930: ) i,
931: po_requisition_headers_all prh,

Line 928: || fnd_global.newline ||

924: where fact.req_fulfilled_date between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_EFFECTIVE_END_DATE + (86399/86400)
925: and fact.include_in_ufr = ''Y'' '
926: || fnd_global.newline || l_where_clause
927: || fnd_global.newline || l_bucket_where
928: || fnd_global.newline ||
929: ')
930: ) i,
931: po_requisition_headers_all prh,
932: po_requisition_lines_all prl,

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

1081: ,'PO'
1082: ,'7.1');
1083: if(p_view_by_dim = 'ITEM+POA_ITEMS')
1084: then
1085: l_sel_clause := l_sel_clause || fnd_global.newline ||
1086: 'v.description POA_ATTRIBUTE3, --Description
1087: v2.description POA_ATTRIBUTE4, --UOM
1088: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
1089: else

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

1086: 'v.description POA_ATTRIBUTE3, --Description
1087: v2.description POA_ATTRIBUTE4, --UOM
1088: oset.POA_ATTRIBUTE5 POA_ATTRIBUTE5, --Quantity';
1089: else
1090: l_sel_clause := l_sel_clause || fnd_global.newline ||
1091: 'null POA_ATTRIBUTE3, --Description
1092: null POA_ATTRIBUTE4, --UOM
1093: null POA_ATTRIBUTE5, --Quantity';
1094: end if;

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

1091: 'null POA_ATTRIBUTE3, --Description
1092: null POA_ATTRIBUTE4, --UOM
1093: null POA_ATTRIBUTE5, --Quantity';
1094: end if;
1095: l_sel_clause := l_sel_clause || fnd_global.newline ||
1096: 'oset.POA_MEASURE1 POA_MEASURE1, --Average Age (Days)
1097: oset.POA_PERCENT1 POA_PERCENT1, --Avg Age Change
1098: oset.POA_MEASURE2 POA_MEASURE2, --Fulfilled Lines
1099: oset.POA_PERCENT2 POA_PERCENT2, --Fulf Lines Change

Line 1103: || fnd_global.newline ||

1099: oset.POA_PERCENT2 POA_PERCENT2, --Fulf Lines Change
1100: oset.POA_PERCENT3 POA_PERCENT3, --Manual Lines
1101: oset.POA_PERCENT4 POA_PERCENT4, --Manual Lines Rate
1102: oset.POA_MEASURE3 POA_MEASURE3 --Manual Lines Rate Change '
1103: || fnd_global.newline ||
1104: poa_dbi_util_pkg.get_bucket_outer_query(
1105: p_bucket_rec
1106: , p_col_name => 'oset.POA_MEASURE4'
1107: , p_alias_name => 'POA_MEASURE4'

Line 1118: || fnd_global.newline ||

1114: oset.POA_PERCENT6 POA_PERCENT6, --Grand Total for fulf lines Change
1115: oset.POA_PERCENT7 POA_PERCENT7, --Grand Total for Manual Lines
1116: oset.POA_PERCENT8 POA_PERCENT8, --Grand Total for Manual Lines Rate
1117: oset.POA_MEASURE7 POA_MEASURE7 -- grand tot for man lines rate change'
1118: || fnd_global.newline ||
1119: poa_dbi_util_pkg.get_bucket_outer_query(
1120: p_bucket_rec
1121: , p_col_name => 'oset.POA_MEASURE8'
1122: , p_alias_name => 'POA_MEASURE8'

Line 1125: , p_total_flag => 'N') || fnd_global.newline;

1121: , p_col_name => 'oset.POA_MEASURE8'
1122: , p_alias_name => 'POA_MEASURE8'
1123: , p_prefix => ''
1124: , p_suffix => ''
1125: , p_total_flag => 'N') || fnd_global.newline;
1126:
1127: l_sel_clause := l_sel_clause ||
1128: poa_dbi_util_pkg.get_bucket_drill_url(
1129: p_bucket_rec

Line 1133: , p_add_bucket_num => 'Y') || ' ,'||fnd_global.newline;

1129: p_bucket_rec
1130: , 'POA_ATTRIBUTE6'
1131: , '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='
1132: , ''''
1133: , p_add_bucket_num => 'Y') || ' ,'||fnd_global.newline;
1134:
1135: l_sel_clause := l_sel_clause ||
1136: '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
1137: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE8';

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

1135: l_sel_clause := l_sel_clause ||
1136: '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
1137: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE8';
1138:
1139: l_sel_clause := l_sel_clause || fnd_global.newline||'from
1140: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;
1141:
1142: if(p_view_by_dim = 'ITEM+POA_ITEMS')
1143: then

Line 1140: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;

1136: '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'' POA_ATTRIBUTE7,
1137: ''pFunctionName=POA_DBI_FR_MAN_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=2'' POA_ATTRIBUTE8';
1138:
1139: l_sel_clause := l_sel_clause || fnd_global.newline||'from
1140: ( select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col|| ')) - 1 rnk,' ||fnd_global.newline|| ' ' || p_view_by_col;
1141:
1142: if(p_view_by_dim = 'ITEM+POA_ITEMS')
1143: then
1144: l_sel_clause := l_sel_clause ||',

Line 1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||

1205: , p_alias_name => 'POA_MEASURE4'
1206: , p_prefix => 'nvl('
1207: , p_suffix => ',0)'
1208: , p_total_flag => 'N') ||',
1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||
1210: poa_dbi_util_pkg.change_clause(
1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,