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.

[Home] [Help]

APPS.POA_DBI_UPR_PKG dependencies on FND_GLOBAL

Line 144: || fnd_global.newline

140: ,'7.1');
141:
142: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
143: l_sel_clause := l_sel_clause
144: || fnd_global.newline
145: ||
146: ' v.description POA_ATTRIBUTE1, --Description
147: v2.description POA_ATTRIBUTE2, --UOM
148: oset.POA_MEASURE8 POA_MEASURE8, --Quantity'

Line 149: || fnd_global.newline;

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

Line 152: || fnd_global.newline

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

Line 157: || fnd_global.newline;

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

Line 400: || fnd_global.newline

396:
397:
398: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
399: l_sel_clause := l_sel_clause
400: || fnd_global.newline
401: ||
402: ' v.description POA_ATTRIBUTE1, --Description
403: v2.description POA_ATTRIBUTE2, --UOM
404: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'

Line 405: || fnd_global.newline;

401: ||
402: ' v.description POA_ATTRIBUTE1, --Description
403: v2.description POA_ATTRIBUTE2, --UOM
404: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
405: || fnd_global.newline;
406: else
407: l_sel_clause := l_sel_clause
408: || fnd_global.newline
409: ||

Line 408: || fnd_global.newline

404: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
405: || fnd_global.newline;
406: else
407: l_sel_clause := l_sel_clause
408: || fnd_global.newline
409: ||
410: ' null POA_ATTRIBUTE1, --Description
411: null POA_ATTRIBUTE2, --UOM
412: null POA_MEASURE1, --Quantity'

Line 413: || fnd_global.newline;

409: ||
410: ' null POA_ATTRIBUTE1, --Description
411: null POA_ATTRIBUTE2, --UOM
412: null POA_MEASURE1, --Quantity'
413: || fnd_global.newline;
414: end if;
415:
416:
417: l_sel_clause := l_sel_clause ||

Line 423: || fnd_global.newline

419: oset.POA_MEASURE3 POA_MEASURE3, -- Lines Pending Sourcing
420: oset.POA_MEASURE4 POA_MEASURE4, -- Lines Pending Buyers Workbench
421: oset.POA_MEASURE5 POA_MEASURE5, --Lines Pending PO submit
422: oset.POA_MEASURE6 POA_MEASURE6 --Lines Pending PO Approval '
423: || fnd_global.newline
424: || poa_dbi_util_pkg.get_bucket_outer_query(
425: p_bucket_rec
426: , p_col_name => 'oset.POA_MEASURE7'
427: , p_alias_name => 'POA_MEASURE7'

Line 431: || fnd_global.newline

427: , p_alias_name => 'POA_MEASURE7'
428: , p_prefix => ''
429: , p_suffix => ''
430: , p_total_flag => 'N')
431: || fnd_global.newline
432: || ' ,oset.POA_MEASURE8 POA_MEASURE8, -- Grand Total for Total
433: oset.POA_MEASURE9 POA_MEASURE9, -- Grand Total for Pending Src
434: oset.POA_MEASURE10 POA_MEASURE10, -- Grand Total for Buyers Wkbnch
435: oset.POA_MEASURE11 POA_MEASURE11, -- Grand Total for PO Submit

Line 437: || fnd_global.newline

433: oset.POA_MEASURE9 POA_MEASURE9, -- Grand Total for Pending Src
434: oset.POA_MEASURE10 POA_MEASURE10, -- Grand Total for Buyers Wkbnch
435: oset.POA_MEASURE11 POA_MEASURE11, -- Grand Total for PO Submit
436: oset.POA_MEASURE12 POA_MEASURE12 -- Grand Total for PO Approval '
437: || fnd_global.newline
438: || poa_dbi_util_pkg.get_bucket_outer_query(
439: p_bucket_rec
440: , p_col_name => 'oset.POA_MEASURE13'
441: , p_alias_name => 'POA_MEASURE13'

Line 445: || fnd_global.newline

441: , p_alias_name => 'POA_MEASURE13'
442: , p_prefix => ''
443: , p_suffix => ''
444: , p_total_flag => 'N')
445: || fnd_global.newline
446: || ',oset.POA_MEASURE3 POA_MEASURE14,
447: oset.POA_MEASURE4 POA_MEASURE15,
448: oset.POA_MEASURE5 POA_MEASURE16,
449: oset.POA_MEASURE6 POA_MEASURE17' ;

Line 497: || fnd_global.newline

493: l_sel_clause := l_sel_clause || ',
494: POA_MEASURE2,POA_MEASURE3,
495: POA_MEASURE4, POA_MEASURE5,
496: POA_MEASURE6'
497: || fnd_global.newline
498: || poa_dbi_util_pkg.get_bucket_outer_query(
499: p_bucket_rec
500: , p_col_name => 'POA_MEASURE7'
501: , p_alias_name => 'POA_MEASURE7'

Line 505: || fnd_global.newline ||

501: , p_alias_name => 'POA_MEASURE7'
502: , p_prefix => ''
503: , p_suffix => ''
504: , p_total_flag => 'N')
505: || fnd_global.newline ||
506: ' , POA_MEASURE8, POA_MEASURE9,
507: POA_MEASURE10, POA_MEASURE11,
508: POA_MEASURE12 '
509: || poa_dbi_util_pkg.get_bucket_outer_query(

Line 516: || fnd_global.newline ||

512: , p_alias_name => 'POA_MEASURE13'
513: , p_prefix => ''
514: , p_suffix => ''
515: , p_total_flag => 'N')
516: || fnd_global.newline ||
517: ' from (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';
518:
519: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
520: l_sel_clause := l_sel_clause || ' base_uom,

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

526: nvl(c_pen_po_submit_amt,0) POA_MEASURE5,
527: nvl(c_pen_po_appr_amt,0) POA_MEASURE6
528: ';
529:
530: l_sel_clause := l_sel_clause || fnd_global.newline
531: || poa_dbi_util_pkg.get_bucket_outer_query(
532: p_bucket_rec
533: , p_col_name => 'c_unproc_amt_age'
534: , p_alias_name => 'POA_MEASURE7'

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

534: , p_alias_name => 'POA_MEASURE7'
535: , p_prefix => 'nvl('
536: , p_suffix => ',0)'
537: , p_total_flag => 'N')
538: || fnd_global.newline || ',
539: nvl(c_unproc_amt_total,0) POA_MEASURE8,
540: nvl(c_pen_src_amt_total,0) POA_MEASURE9,
541: nvl(c_pen_buyer_wk_amt_total,0) POA_MEASURE10,
542: nvl(c_pen_po_submit_amt_total,0) POA_MEASURE11,

Line 551: || fnd_global.newline ;

547: , p_alias_name => 'POA_MEASURE13'
548: , p_prefix => 'nvl('
549: , p_suffix => ',0)'
550: , p_total_flag => 'Y')
551: || fnd_global.newline ;
552:
553: return l_sel_clause;
554: END;
555:

Line 706: || fnd_global.newline

702: ,'7.1');
703:
704: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
705: l_sel_clause := l_sel_clause
706: || fnd_global.newline
707: ||
708: ' v.description POA_ATTRIBUTE1, --Description
709: v2.description POA_ATTRIBUTE2, --UOM
710: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'

Line 711: || fnd_global.newline;

707: ||
708: ' v.description POA_ATTRIBUTE1, --Description
709: v2.description POA_ATTRIBUTE2, --UOM
710: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
711: || fnd_global.newline;
712: else
713: l_sel_clause := l_sel_clause
714: || fnd_global.newline
715: ||

Line 714: || fnd_global.newline

710: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
711: || fnd_global.newline;
712: else
713: l_sel_clause := l_sel_clause
714: || fnd_global.newline
715: ||
716: ' null POA_ATTRIBUTE1, --Description
717: null POA_ATTRIBUTE2, --UOM
718: null POA_MEASURE1, --Quantity'

Line 719: || fnd_global.newline;

715: ||
716: ' null POA_ATTRIBUTE1, --Description
717: null POA_ATTRIBUTE2, --UOM
718: null POA_MEASURE1, --Quantity'
719: || fnd_global.newline;
720: end if;
721:
722:
723: l_sel_clause := l_sel_clause ||

Line 726: || fnd_global.newline

722:
723: l_sel_clause := l_sel_clause ||
724: ' oset.POA_MEASURE7 POA_MEASURE7, -- Avg Age (days)
725: oset.POA_MEASURE2 POA_MEASURE2 -- Unprocessed Lines'
726: || fnd_global.newline
727: || poa_dbi_util_pkg.get_bucket_outer_query(
728: p_bucket_rec
729: , p_col_name => 'oset.POA_MEASURE3'
730: , p_alias_name => 'POA_MEASURE3'

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

730: , p_alias_name => 'POA_MEASURE3'
731: , p_prefix => ''
732: , p_suffix => ''
733: , p_total_flag => 'N')
734: || fnd_global.newline || ',
735: oset.POA_MEASURE8 POA_MEASURE8, -- Grand Total by Avg Days
736: oset.POA_MEASURE4 POA_MEASURE4 -- Grand Total Unprocessed Lns'
737: || fnd_global.newline
738: || poa_dbi_util_pkg.get_bucket_outer_query(

Line 737: || fnd_global.newline

733: , p_total_flag => 'N')
734: || fnd_global.newline || ',
735: oset.POA_MEASURE8 POA_MEASURE8, -- Grand Total by Avg Days
736: oset.POA_MEASURE4 POA_MEASURE4 -- Grand Total Unprocessed Lns'
737: || fnd_global.newline
738: || poa_dbi_util_pkg.get_bucket_outer_query(
739: p_bucket_rec
740: , p_col_name => 'oset.POA_MEASURE5'
741: , p_alias_name => 'POA_MEASURE5'

Line 745: || fnd_global.newline ;

741: , p_alias_name => 'POA_MEASURE5'
742: , p_prefix => ''
743: , p_suffix => ''
744: , p_total_flag => 'N')
745: || fnd_global.newline ;
746:
747: l_sel_clause := l_sel_clause ||
748: poa_dbi_util_pkg.get_bucket_drill_url(
749: p_bucket_rec

Line 776: || fnd_global.newline

772: POA_MEASURE1';
773: end if;
774: l_sel_clause := l_sel_clause || ',
775: POA_MEASURE7,POA_MEASURE2'
776: || fnd_global.newline
777: || poa_dbi_util_pkg.get_bucket_outer_query(
778: p_bucket_rec
779: , p_col_name => 'POA_MEASURE3'
780: , p_alias_name => 'POA_MEASURE3'

Line 784: || fnd_global.newline ||

780: , p_alias_name => 'POA_MEASURE3'
781: , p_prefix => ''
782: , p_suffix => ''
783: , p_total_flag => 'N')
784: || fnd_global.newline ||
785: ' , POA_MEASURE8, POA_MEASURE4'
786: || poa_dbi_util_pkg.get_bucket_outer_query(
787: p_bucket_rec
788: , p_col_name => 'POA_MEASURE5'

Line 793: || fnd_global.newline ||

789: , p_alias_name => 'POA_MEASURE5'
790: , p_prefix => ''
791: , p_suffix => ''
792: , p_total_flag => 'N')
793: || fnd_global.newline ||
794: ' from (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';
795:
796: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
797: l_sel_clause := l_sel_clause || ' base_uom,

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

800: l_sel_clause := l_sel_clause || ' nvl(c_num_days_unproc,0)/decode(c_unproc_cnt,0,null,c_unproc_cnt) POA_MEASURE7,
801: nvl(c_unproc_cnt,0) POA_MEASURE2
802: ';
803:
804: l_sel_clause := l_sel_clause || fnd_global.newline
805: || poa_dbi_util_pkg.get_bucket_outer_query(
806: p_bucket_rec
807: , p_col_name => 'c_unproc_cnt_age'
808: , p_alias_name => 'POA_MEASURE3'

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

808: , p_alias_name => 'POA_MEASURE3'
809: , p_prefix => 'nvl('
810: , p_suffix => ',0)'
811: , p_total_flag => 'N')
812: || fnd_global.newline || ',
813: nvl(c_num_days_unproc_total,0)/decode(c_unproc_cnt_total,0,null,c_unproc_cnt_total) POA_MEASURE8,
814: nvl(c_unproc_cnt_total,0) POA_MEASURE4'
815: || poa_dbi_util_pkg.get_bucket_outer_query(
816: p_bucket_rec

Line 822: || fnd_global.newline ;

818: , p_alias_name => 'POA_MEASURE5'
819: , p_prefix => 'nvl('
820: , p_suffix => ',0)'
821: , p_total_flag => 'Y')
822: || fnd_global.newline ;
823:
824: return l_sel_clause;
825: END;
826:

Line 1000: || fnd_global.newline

996:
997:
998: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
999: l_sel_clause := l_sel_clause
1000: || fnd_global.newline
1001: ||
1002: ' v.description POA_ATTRIBUTE1, --Description
1003: v2.description POA_ATTRIBUTE2, --UOM
1004: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'

Line 1005: || fnd_global.newline;

1001: ||
1002: ' v.description POA_ATTRIBUTE1, --Description
1003: v2.description POA_ATTRIBUTE2, --UOM
1004: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
1005: || fnd_global.newline;
1006: else
1007: l_sel_clause := l_sel_clause
1008: || fnd_global.newline
1009: ||

Line 1008: || fnd_global.newline

1004: oset.POA_MEASURE1 POA_MEASURE1, --Quantity'
1005: || fnd_global.newline;
1006: else
1007: l_sel_clause := l_sel_clause
1008: || fnd_global.newline
1009: ||
1010: ' null POA_ATTRIBUTE1, --Description
1011: null POA_ATTRIBUTE2, --UOM
1012: null POA_MEASURE1, --Quantity'

Line 1013: || fnd_global.newline;

1009: ||
1010: ' null POA_ATTRIBUTE1, --Description
1011: null POA_ATTRIBUTE2, --UOM
1012: null POA_MEASURE1, --Quantity'
1013: || fnd_global.newline;
1014: end if;
1015:
1016: l_sel_clause := l_sel_clause ||
1017: ' oset.POA_MEASURE2 POA_MEASURE2, --Unprocessed Lines Total

Line 1208: || fnd_global.newline

1204: if(l_bucket is not null) then
1205: l_bucket_where := 'and (&RANGE_LOW is null or '
1206: || '(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1207: || ' >= &RANGE_LOW)'
1208: || fnd_global.newline
1209: ||' and (&RANGE_HIGH is null or '
1210: ||'(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1211: || ' < &RANGE_HIGH)';
1212:

Line 1328: || l_where_clause || fnd_global.newline ||

1324: poa_dbi_req_f fact ' || l_in_join_tables || '
1325: where
1326: fact.req_approved_date is not null
1327: and fact.po_approved_date is null '
1328: || l_where_clause || fnd_global.newline ||
1329: l_context_where || fnd_global.newline ||
1330: l_bucket_where ||
1331: ')) i2 where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)) i3 '||l_rownum_where||' ) i,
1332: po_requisition_headers_all prh,

Line 1329: l_context_where || fnd_global.newline ||

1325: where
1326: fact.req_approved_date is not null
1327: and fact.po_approved_date is null '
1328: || l_where_clause || fnd_global.newline ||
1329: l_context_where || fnd_global.newline ||
1330: l_bucket_where ||
1331: ')) i2 where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)) i3 '||l_rownum_where||' ) i,
1332: po_requisition_headers_all prh,
1333: po_requisition_lines_all prl,