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

Line 141: || fnd_global.newline

137:
138:
139: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
140: l_sel_clause := l_sel_clause
141: || fnd_global.newline
142: ||
143: ' v.description POA_ATTRIBUTE1, --Description
144: v2.description POA_ATTRIBUTE2, --UOM
145: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity

Line 147: '|| fnd_global.newline;

143: ' v.description POA_ATTRIBUTE1, --Description
144: v2.description POA_ATTRIBUTE2, --UOM
145: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity
146:
147: '|| fnd_global.newline;
148:
149: else
150: l_sel_clause := l_sel_clause
151: || fnd_global.newline

Line 151: || fnd_global.newline

147: '|| fnd_global.newline;
148:
149: else
150: l_sel_clause := l_sel_clause
151: || fnd_global.newline
152: ||
153: ' null POA_ATTRIBUTE1, --Description
154: null POA_ATTRIBUTE2, --UOM
155: null POA_MEASURE10, --Quantity'

Line 156: || fnd_global.newline;

152: ||
153: ' null POA_ATTRIBUTE1, --Description
154: null POA_ATTRIBUTE2, --UOM
155: null POA_MEASURE10, --Quantity'
156: || fnd_global.newline;
157:
158: end if;
159:
160: l_sel_clause := l_sel_clause ||

Line 370: || fnd_global.newline

366:
367:
368: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
369: l_sel_clause := l_sel_clause
370: || fnd_global.newline
371: || '
372: v.description POA_ATTRIBUTE1,
373: v2.description POA_ATTRIBUTE2,
374: oset.POA_MEASURE1 POA_MEASURE1,

Line 376: '|| fnd_global.newline;

372: v.description POA_ATTRIBUTE1,
373: v2.description POA_ATTRIBUTE2,
374: oset.POA_MEASURE1 POA_MEASURE1,
375:
376: '|| fnd_global.newline;
377:
378: else
379: l_sel_clause := l_sel_clause
380: || fnd_global.newline

Line 380: || fnd_global.newline

376: '|| fnd_global.newline;
377:
378: else
379: l_sel_clause := l_sel_clause
380: || fnd_global.newline
381: || '
382: null POA_ATTRIBUTE1,
383: null POA_ATTRIBUTE2,
384: null POA_MEASURE1, '

Line 385: || fnd_global.newline;

381: || '
382: null POA_ATTRIBUTE1,
383: null POA_ATTRIBUTE2,
384: null POA_MEASURE1, '
385: || fnd_global.newline;
386:
387: end if;
388:
389: l_sel_clause := l_sel_clause ||

Line 393: || fnd_global.newline

389: l_sel_clause := l_sel_clause ||
390: ' oset.POA_MEASURE2 POA_MEASURE2, --unfulf amt
391: oset.POA_MEASURE3 POA_MEASURE3, -- unfulf amt pend process
392: oset.POA_MEASURE4 POA_MEASURE4 -- pending fulf'
393: || fnd_global.newline
394: || poa_dbi_util_pkg.get_bucket_outer_query(
395: p_bucket_rec
396: , p_col_name => 'oset.POA_MEASURE5'
397: , p_alias_name => 'POA_MEASURE5'

Line 401: || fnd_global.newline

397: , p_alias_name => 'POA_MEASURE5'
398: , p_prefix => ''
399: , p_suffix => ''
400: , p_total_flag => 'N')
401: || fnd_global.newline
402: || ',
403: oset.POA_MEASURE6 POA_MEASURE6, --unfulf amt total
404: oset.POA_MEASURE7 POA_MEASURE7, -- pend process total
405: oset.POA_MEASURE8 POA_MEASURE8 -- unfulf amt pend fulf total'

Line 406: || fnd_global.newline

402: || ',
403: oset.POA_MEASURE6 POA_MEASURE6, --unfulf amt total
404: oset.POA_MEASURE7 POA_MEASURE7, -- pend process total
405: oset.POA_MEASURE8 POA_MEASURE8 -- unfulf amt pend fulf total'
406: || fnd_global.newline
407: || poa_dbi_util_pkg.get_bucket_outer_query(
408: p_bucket_rec
409: , p_col_name => 'oset.POA_MEASURE9'
410: , p_alias_name => 'POA_MEASURE9'

Line 414: || fnd_global.newline

410: , p_alias_name => 'POA_MEASURE9'
411: , p_prefix => ''
412: , p_suffix => ''
413: , p_total_flag => 'N')
414: || fnd_global.newline
415: ||
416: ',
417: oset.POA_MEASURE3 POA_ATTRIBUTE4, --unful amt-pending proc for graph
418: oset.POA_MEASURE4 POA_ATTRIBUTE5 --unful amt-pending fulf for graph '

Line 419: || fnd_global.newline ;

415: ||
416: ',
417: oset.POA_MEASURE3 POA_ATTRIBUTE4, --unful amt-pending proc for graph
418: oset.POA_MEASURE4 POA_ATTRIBUTE5 --unful amt-pending fulf for graph '
419: || fnd_global.newline ;
420:
421:
422: l_sel_clause := l_sel_clause ||
423: poa_dbi_util_pkg.get_bucket_drill_url(

Line 457: || fnd_global.newline

453: end if;
454:
455: l_sel_clause := l_sel_clause || ',POA_MEASURE2,POA_MEASURE3,
456: POA_MEASURE4 '
457: || fnd_global.newline
458: || poa_dbi_util_pkg.get_bucket_outer_query(
459: p_bucket_rec
460: , p_col_name => 'POA_MEASURE5'
461: , p_alias_name => 'POA_MEASURE5'

Line 465: || fnd_global.newline ||

461: , p_alias_name => 'POA_MEASURE5'
462: , p_prefix => ''
463: , p_suffix => ''
464: , p_total_flag => 'N')
465: || fnd_global.newline ||
466: ' ,POA_MEASURE6,
467: POA_MEASURE7,POA_MEASURE8'
468: || poa_dbi_util_pkg.get_bucket_outer_query(
469: p_bucket_rec

Line 475: || fnd_global.newline || '

471: , p_alias_name => 'POA_MEASURE9'
472: , p_prefix => ''
473: , p_suffix => ''
474: , p_total_flag => 'N')
475: || fnd_global.newline || '
476: from (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';
477:
478: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
479: l_sel_clause := l_sel_clause || ' base_uom,

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

483: l_sel_clause := l_sel_clause
484: || ' nvl(c_unfulf_amt,0) POA_MEASURE2,
485: (nvl(c_unfulf_amt,0)-nvl(c_pen_fulf_amt,0)) POA_MEASURE3,
486: nvl(c_pen_fulf_amt,0) POA_MEASURE4';
487: l_sel_clause := l_sel_clause || fnd_global.newline
488: || poa_dbi_util_pkg.get_bucket_outer_query(
489: p_bucket_rec
490: , p_col_name => 'c_unfulf_amt_age'
491: , p_alias_name => 'POA_MEASURE5'

Line 495: || fnd_global.newline || ',

491: , p_alias_name => 'POA_MEASURE5'
492: , p_prefix => 'nvl('
493: , p_suffix => ',0)'
494: , p_total_flag => 'N')
495: || fnd_global.newline || ',
496:
497: nvl(c_unfulf_amt_total,0) POA_MEASURE6,
498: (nvl(c_unfulf_amt_total,0)-nvl(c_pen_fulf_amt_total,0)) POA_MEASURE7,
499: nvl(c_pen_fulf_amt_total,0) POA_MEASURE8'

Line 507: || fnd_global.newline;

503: , p_alias_name => 'POA_MEASURE9'
504: , p_prefix => 'nvl('
505: , p_suffix => ',0)'
506: , p_total_flag => 'Y')
507: || fnd_global.newline;
508:
509: return l_sel_clause;
510: END get_amt_sel_clause;
511:

Line 652: || fnd_global.newline

648:
649:
650: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
651: l_sel_clause := l_sel_clause
652: || fnd_global.newline
653: || '
654: v.description POA_ATTRIBUTE1, --Description
655: v2.description POA_ATTRIBUTE2, --UOM
656: oset.POA_MEASURE1 POA_MEASURE1, --Unfulfilled Quantity

Line 658: '|| fnd_global.newline;

654: v.description POA_ATTRIBUTE1, --Description
655: v2.description POA_ATTRIBUTE2, --UOM
656: oset.POA_MEASURE1 POA_MEASURE1, --Unfulfilled Quantity
657:
658: '|| fnd_global.newline;
659:
660: else
661: l_sel_clause := l_sel_clause
662: || fnd_global.newline

Line 662: || fnd_global.newline

658: '|| fnd_global.newline;
659:
660: else
661: l_sel_clause := l_sel_clause
662: || fnd_global.newline
663: || '
664: null POA_ATTRIBUTE1, --Description
665: null POA_ATTRIBUTE2, --UOM
666: null POA_MEASURE1, --Unfulfilled Quantity'

Line 668: || fnd_global.newline;

664: null POA_ATTRIBUTE1, --Description
665: null POA_ATTRIBUTE2, --UOM
666: null POA_MEASURE1, --Unfulfilled Quantity'
667:
668: || fnd_global.newline;
669:
670: end if;
671:
672: l_sel_clause := l_sel_clause ||

Line 881: || fnd_global.newline

877: ,'7.1');
878:
879: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
880: l_sel_clause := l_sel_clause
881: || fnd_global.newline
882: || '
883: v.description POA_ATTRIBUTE1, --Description
884: v2.description POA_ATTRIBUTE2, --UOM
885: oset.POA_MEASURE1 POA_MEASURE1, --Unfulfilled Quantity

Line 887: '|| fnd_global.newline;

883: v.description POA_ATTRIBUTE1, --Description
884: v2.description POA_ATTRIBUTE2, --UOM
885: oset.POA_MEASURE1 POA_MEASURE1, --Unfulfilled Quantity
886:
887: '|| fnd_global.newline;
888:
889: else
890: l_sel_clause := l_sel_clause
891: || fnd_global.newline

Line 891: || fnd_global.newline

887: '|| fnd_global.newline;
888:
889: else
890: l_sel_clause := l_sel_clause
891: || fnd_global.newline
892: || '
893: null POA_ATTRIBUTE1, --Description
894: null POA_ATTRIBUTE2, --UOM
895: null POA_MEASURE1, --Unfulfilled Quantity'

Line 897: || fnd_global.newline;

893: null POA_ATTRIBUTE1, --Description
894: null POA_ATTRIBUTE2, --UOM
895: null POA_MEASURE1, --Unfulfilled Quantity'
896:
897: || fnd_global.newline;
898:
899: end if;
900:
901: l_sel_clause := l_sel_clause ||

Line 905: || fnd_global.newline

901: l_sel_clause := l_sel_clause ||
902: ' oset.POA_MEASURE2 POA_MEASURE2, --Average Age (Days)
903: oset.POA_MEASURE3 POA_MEASURE3 --Unfulfilled Lines'
904:
905: || fnd_global.newline
906: || poa_dbi_util_pkg.get_bucket_outer_query(
907: p_bucket_rec
908: , p_col_name => 'oset.POA_MEASURE4'
909: , p_alias_name => 'POA_MEASURE4'

Line 913: || fnd_global.newline

909: , p_alias_name => 'POA_MEASURE4'
910: , p_prefix => ''
911: , p_suffix => ''
912: , p_total_flag => 'N')
913: || fnd_global.newline
914: || ',
915:
916: oset.POA_MEASURE5 POA_MEASURE5, --Grand Total for Average Age (Days)
917: oset.POA_MEASURE6 POA_MEASURE6 --Grand Total for Unfulfilled Lines'

Line 918: || fnd_global.newline

914: || ',
915:
916: oset.POA_MEASURE5 POA_MEASURE5, --Grand Total for Average Age (Days)
917: oset.POA_MEASURE6 POA_MEASURE6 --Grand Total for Unfulfilled Lines'
918: || fnd_global.newline
919: || poa_dbi_util_pkg.get_bucket_outer_query(
920: p_bucket_rec
921: , p_col_name => 'oset.POA_MEASURE7'
922: , p_alias_name => 'POA_MEASURE7'

Line 926: || fnd_global.newline ;

922: , p_alias_name => 'POA_MEASURE7'
923: , p_prefix => ''
924: , p_suffix => ''
925: , p_total_flag => 'N')
926: || fnd_global.newline ;
927:
928:
929: l_sel_clause := l_sel_clause ||
930: poa_dbi_util_pkg.get_bucket_drill_url(

Line 958: || fnd_global.newline

954: end if;
955:
956: l_sel_clause := l_sel_clause || ',POA_MEASURE2,POA_MEASURE3'
957:
958: || fnd_global.newline
959: || poa_dbi_util_pkg.get_bucket_outer_query(
960: p_bucket_rec
961: , p_col_name => 'POA_MEASURE4'
962: , p_alias_name => 'POA_MEASURE4'

Line 966: || fnd_global.newline ||

962: , p_alias_name => 'POA_MEASURE4'
963: , p_prefix => ''
964: , p_suffix => ''
965: , p_total_flag => 'N')
966: || fnd_global.newline ||
967: ' ,POA_MEASURE5,
968: POA_MEASURE6'
969: || poa_dbi_util_pkg.get_bucket_outer_query(
970: p_bucket_rec

Line 976: || fnd_global.newline || '

972: , p_alias_name => 'POA_MEASURE7'
973: , p_prefix => ''
974: , p_suffix => ''
975: , p_total_flag => 'N')
976: || fnd_global.newline || '
977: from (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';
978:
979: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
980: l_sel_clause := l_sel_clause || ' base_uom,

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

984: l_sel_clause := l_sel_clause
985: || ' nvl(c_num_days_unfulf,0)/decode(c_unfulf_cnt,0,null,c_unfulf_cnt) POA_MEASURE2,
986: nvl(c_unfulf_cnt,0) POA_MEASURE3';
987:
988: l_sel_clause := l_sel_clause || fnd_global.newline
989: || poa_dbi_util_pkg.get_bucket_outer_query(
990: p_bucket_rec
991: , p_col_name => 'c_unfulf_cnt_age'
992: , p_alias_name => 'POA_MEASURE4'

Line 996: || fnd_global.newline || ',

992: , p_alias_name => 'POA_MEASURE4'
993: , p_prefix => 'nvl('
994: , p_suffix => ',0)'
995: , p_total_flag => 'N')
996: || fnd_global.newline || ',
997: nvl(c_num_days_unfulf_total,0)/decode(c_unfulf_cnt_total,0,null,c_unfulf_cnt_total) POA_MEASURE5,
998:
999: nvl(c_unfulf_cnt_total,0) POA_MEASURE6'
1000:

Line 1008: || fnd_global.newline;

1004: , p_alias_name => 'POA_MEASURE7'
1005: , p_prefix => 'nvl('
1006: , p_suffix => ',0)'
1007: , p_total_flag => 'Y')
1008: || fnd_global.newline;
1009:
1010: return l_sel_clause;
1011: END get_age_sel_clause;
1012:

Line 1084: || fnd_global.newline

1080: if(l_bucket is not null) then
1081: l_aging_where := 'and (&RANGE_LOW is null or '
1082: || '(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1083: || ' >= &RANGE_LOW)'
1084: || fnd_global.newline
1085: ||' and (&RANGE_HIGH is null or '
1086: ||'(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1087: || ' < &RANGE_HIGH)';
1088:

Line 1192: and fact.include_in_ufr=''Y'' ' || l_where_clause || fnd_global.newline ||

1188: poa_dbi_req_f fact ' || l_in_join_tables || '
1189: where
1190: fact.req_approved_date is not null
1191: and fact.req_fulfilled_date is null' || '
1192: and fact.include_in_ufr=''Y'' ' || l_where_clause || fnd_global.newline ||
1193: l_context_where || fnd_global.newline ||
1194: l_aging_where ||
1195: ')) i2 where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1) ) i3 '||l_rownum_where||' ) i,
1196: po_requisition_headers_all prh,

Line 1193: l_context_where || fnd_global.newline ||

1189: where
1190: fact.req_approved_date is not null
1191: and fact.req_fulfilled_date is null' || '
1192: and fact.include_in_ufr=''Y'' ' || l_where_clause || fnd_global.newline ||
1193: l_context_where || fnd_global.newline ||
1194: l_aging_where ||
1195: ')) i2 where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1) ) i3 '||l_rownum_where||' ) i,
1196: po_requisition_headers_all prh,
1197: po_requisition_lines_all prl,