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

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

148: ,'7.1');
149:
150: if(p_view_by_dim = 'ITEM+POA_ITEMS')
151: then
152: l_sel_clause := l_sel_clause || fnd_global.newline || '
153: v.description POA_ATTRIBUTE1, --Description
154: v2.description POA_ATTRIBUTE2, --UOM
155: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity'|| fnd_global.newline;
156:

Line 155: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity'|| fnd_global.newline;

151: then
152: l_sel_clause := l_sel_clause || fnd_global.newline || '
153: v.description POA_ATTRIBUTE1, --Description
154: v2.description POA_ATTRIBUTE2, --UOM
155: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity'|| fnd_global.newline;
156:
157: else
158: l_sel_clause := l_sel_clause || fnd_global.newline || '
159: null POA_ATTRIBUTE1, --Description

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

154: v2.description POA_ATTRIBUTE2, --UOM
155: oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity'|| fnd_global.newline;
156:
157: else
158: l_sel_clause := l_sel_clause || fnd_global.newline || '
159: null POA_ATTRIBUTE1, --Description
160: null POA_ATTRIBUTE2, --UOM
161: null POA_MEASURE10, --Quantity' || fnd_global.newline;
162: end if;

Line 161: null POA_MEASURE10, --Quantity' || fnd_global.newline;

157: else
158: l_sel_clause := l_sel_clause || fnd_global.newline || '
159: null POA_ATTRIBUTE1, --Description
160: null POA_ATTRIBUTE2, --UOM
161: null POA_MEASURE10, --Quantity' || fnd_global.newline;
162: end if;
163:
164: l_sel_clause := l_sel_clause ||
165: ' oset.POA_MEASURE1 POA_MEASURE1, -- Processed Lines

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

425: );
426:
427: if(p_view_by_dim = 'ITEM+POA_ITEMS')
428: then
429: l_sel_clause := l_sel_clause || fnd_global.newline ||
430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else

Line 430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||

426:
427: if(p_view_by_dim = 'ITEM+POA_ITEMS')
428: then
429: l_sel_clause := l_sel_clause || fnd_global.newline ||
430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||

Line 431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||

427: if(p_view_by_dim = 'ITEM+POA_ITEMS')
428: then
429: l_sel_clause := l_sel_clause || fnd_global.newline ||
430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||

Line 432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;

428: then
429: l_sel_clause := l_sel_clause || fnd_global.newline ||
430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||

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

430: ' v.description POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
437: ' null POA_MEASURE10, --Quantity' || fnd_global.newline;
438:

Line 435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||

431: ' v2.description POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
437: ' null POA_MEASURE10, --Quantity' || fnd_global.newline;
438:
439: end if;

Line 436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||

432: ' oset.POA_MEASURE10 POA_MEASURE10, --Unfulfilled Quantity' || fnd_global.newline;
433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
437: ' null POA_MEASURE10, --Quantity' || fnd_global.newline;
438:
439: end if;
440:

Line 437: ' null POA_MEASURE10, --Quantity' || fnd_global.newline;

433: else
434: l_sel_clause := l_sel_clause || fnd_global.newline ||
435: ' null POA_ATTRIBUTE1, --Description' || fnd_global.newline ||
436: ' null POA_ATTRIBUTE2, --UOM' || fnd_global.newline ||
437: ' null POA_MEASURE10, --Quantity' || fnd_global.newline;
438:
439: end if;
440:
441: l_sel_clause := l_sel_clause ||

Line 661: || fnd_global.newline

657:
658: if(p_view_by_dim = 'ITEM+POA_ITEMS')
659: then
660: l_sel_clause := l_sel_clause
661: || fnd_global.newline
662: || '
663: v.description POA_ATTRIBUTE1, --Description
664: v2.description POA_ATTRIBUTE2, --UOM
665: oset.POA_MEASURE10 POA_MEASURE10, --Quantity

Line 666: '|| fnd_global.newline;

662: || '
663: v.description POA_ATTRIBUTE1, --Description
664: v2.description POA_ATTRIBUTE2, --UOM
665: oset.POA_MEASURE10 POA_MEASURE10, --Quantity
666: '|| fnd_global.newline;
667:
668: else
669: l_sel_clause := l_sel_clause
670: || fnd_global.newline

Line 670: || fnd_global.newline

666: '|| fnd_global.newline;
667:
668: else
669: l_sel_clause := l_sel_clause
670: || fnd_global.newline
671: || '
672: null POA_ATTRIBUTE1, --Description
673: null POA_ATTRIBUTE2, --UOM
674: null POA_MEASURE10, --Quantity'

Line 675: || fnd_global.newline;

671: || '
672: null POA_ATTRIBUTE1, --Description
673: null POA_ATTRIBUTE2, --UOM
674: null POA_MEASURE10, --Quantity'
675: || fnd_global.newline;
676:
677: end if;
678: l_sel_clause := l_sel_clause || fnd_global.newline ||
679: ' oset.POA_MEASURE1 POA_MEASURE1, -- Processed Amount

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

674: null POA_MEASURE10, --Quantity'
675: || fnd_global.newline;
676:
677: end if;
678: l_sel_clause := l_sel_clause || fnd_global.newline ||
679: ' oset.POA_MEASURE1 POA_MEASURE1, -- Processed Amount
680: oset.POA_PERCENT1 POA_PERCENT1, -- Change
681: oset.POA_MEASURE2 POA_MEASURE2, -- Manual Amount
682: oset.POA_PERCENT2 POA_PERCENT2, -- Manual Amount Rate

Line 937: || fnd_global.newline

933: ,'7.1');
934:
935: if(p_view_by_dim = 'ITEM+POA_ITEMS') then
936: l_sel_clause := l_sel_clause
937: || fnd_global.newline
938: || '
939: v.description POA_ATTRIBUTE1, --Description
940: v2.description POA_ATTRIBUTE2, --UOM
941: oset.POA_MEASURE10 POA_MEASURE10, --Quantity

Line 943: '|| fnd_global.newline;

939: v.description POA_ATTRIBUTE1, --Description
940: v2.description POA_ATTRIBUTE2, --UOM
941: oset.POA_MEASURE10 POA_MEASURE10, --Quantity
942:
943: '|| fnd_global.newline;
944:
945: else
946: l_sel_clause := l_sel_clause
947: || fnd_global.newline

Line 947: || fnd_global.newline

943: '|| fnd_global.newline;
944:
945: else
946: l_sel_clause := l_sel_clause
947: || fnd_global.newline
948: || '
949: null POA_ATTRIBUTE1, --Description
950: null POA_ATTRIBUTE2, --UOM
951: null POA_MEASURE10, --Quantity'

Line 954: || fnd_global.newline;

950: null POA_ATTRIBUTE2, --UOM
951: null POA_MEASURE10, --Quantity'
952:
953:
954: || fnd_global.newline;
955:
956: end if;
957: l_sel_clause := l_sel_clause || fnd_global.newline ||
958: ' oset.POA_MEASURE1 POA_MEASURE1, -- Average Age (Days)

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

953:
954: || fnd_global.newline;
955:
956: end if;
957: l_sel_clause := l_sel_clause || fnd_global.newline ||
958: ' oset.POA_MEASURE1 POA_MEASURE1, -- Average Age (Days)
959: oset.POA_MEASURE2 POA_MEASURE2, -- Change
960: oset.POA_MEASURE3 POA_MEASURE3, -- Processed Lines
961: oset.POA_PERCENT1 POA_PERCENT1, -- Change

Line 1339: l_query := get_age_trend_sel_clause || 'from '|| fnd_global.newline

1335: p_prior_code => poa_dbi_util_pkg.both_priors,
1336: p_to_date_type => 'RLX'
1337: );
1338:
1339: l_query := get_age_trend_sel_clause || 'from '|| fnd_global.newline
1340: || poa_dbi_template_pkg.trend_sql(
1341: l_xtd,
1342: l_comparison_type,
1343: l_mv,

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

1539: end if;
1540: end loop;
1541:
1542: if (l_option = 2) then --manual reqs
1543: l_where_clause := l_where_clause || fnd_global.newline || ' and fact.po_creation_method = ''M'' ';
1544: end if;
1545:
1546: if(l_bucket is not null)
1547: then

Line 1551: || fnd_global.newline

1547: then
1548: l_bucket_where := 'and (&RANGE_LOW is null or '
1549: || 'greatest(0,(fact.po_approved_date-fact.req_approved_date))'
1550: || ' >= &RANGE_LOW)'
1551: || fnd_global.newline
1552: || 'and (&RANGE_HIGH is null or '
1553: || 'greatest(0,(fact.po_approved_date-fact.req_approved_date))'
1554: || ' < &RANGE_HIGH)';
1555:

Line 1631: || fnd_global.newline || l_where_clause

1627: fact.po_creation_ou_id
1628: from
1629: poa_dbi_req_f fact
1630: where fact.po_approved_date between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_EFFECTIVE_END_DATE + (86399/86400) '
1631: || fnd_global.newline || l_where_clause
1632: || fnd_global.newline || l_bucket_where ||
1633: ')
1634: ) i,
1635: po_requisition_headers_all prh,

Line 1632: || fnd_global.newline || l_bucket_where ||

1628: from
1629: poa_dbi_req_f fact
1630: where fact.po_approved_date between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_EFFECTIVE_END_DATE + (86399/86400) '
1631: || fnd_global.newline || l_where_clause
1632: || fnd_global.newline || l_bucket_where ||
1633: ')
1634: ) i,
1635: po_requisition_headers_all prh,
1636: po_requisition_lines_all prl,