APPS.POA_DBI_UPR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 138

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
                                                            ,'PO'
                                                            ,'7.1');

Line: 186

   ' from (select * from (select * from
    (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;

Line: 206

     from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 393

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
                                                            ,'PO'
                                                            ,'7.1');

Line: 477

     (select * from (select * from
    (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;

Line: 517

'    from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 700

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
                                                            ,'PO'
                                                            ,'7.1');

Line: 761

	 (select * from (select * from
    (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;

Line: 794

'    from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 993

  l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
                                                            ,'PO'
                                                            ,'7.1');

Line: 1061

	 (select * from (select * from
    (select (rank() over(&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col;

Line: 1084

     from   (select ' || p_view_by_col || ',' || p_view_by_col || ' VIEWBY,' || p_view_by_col || ' VIEWBYID, ';

Line: 1191

                          ' and fact.po_creation_date <= to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'') and fact.po_submit_date is null '
                         WHEN l_context=5 THEN
                          ' and fact.po_submit_date <= to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'') '
                         WHEN l_context=6 THEN
                          ' and (fact.expected_date <= to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'') or fact.unproc_ped_flag = ''Y'' ) '
                         WHEN l_context=7 THEN
                          ' and nvl(fact.emergency_flag,''N'')=''Y'' '
                         WHEN l_context=8 THEN
                          ' and nvl(fact.urgent_flag,''N'')=''Y'' '
                       ELSE
                          ''
                       END;

Line: 1206

		|| '(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
		|| ' >= &RANGE_LOW)'
		|| fnd_global.newline
		||' and (&RANGE_HIGH is null or '
		||'(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
		|| ' < &RANGE_HIGH)';

Line: 1226

    select fnd_profile.value('VO_MAX_FETCH_SIZE')
    into l_vo_max_fetch_size
    from dual;

Line: 1235

    x_custom_sql := '   select
		       prh.segment1 POA_MEASURE1,      -- Requisition Number
		       prl.line_num POA_MEASURE2,      -- Line Num
		       rorg.name POA_ATTRIBUTE1,       -- Req Creation OU
		       substrb(perf.first_name,1,1) || ''. '' || perf.last_name POA_ATTRIBUTE2,  -- Requestor Name
		       POA_ATTRIBUTE3 POA_ATTRIBUTE3, -- Req Approved Date
		       POA_ATTRIBUTE4 POA_ATTRIBUTE4, -- Expected Date
		       item.value POA_ATTRIBUTE5,      -- Item Name
		       supplier.value POA_ATTRIBUTE6,  -- Supplier Name
      		       nvl(i.POA_MEASURE3,0) POA_MEASURE3,    -- Amount
		    ';

Line: 1290

		   from    (select * from (select * from
		    (select (rank() over
		            (&ORDER_BY_CLAUSE nulls last, req_header_id,
                            req_line_id))-1 rnk,
			    req_header_id,
			    req_line_id,
			    req_creation_ou_id,
			    requester_id,
			    POA_ATTRIBUTE3 POA_ATTRIBUTE3,
			    POA_ATTRIBUTE4 POA_ATTRIBUTE4,
			    po_item_id,
			    supplier_id,
			    nvl(POA_MEASURE3,0) POA_MEASURE3,
			    nvl(POA_MEASURE6,0) POA_MEASURE6,
		            po_line_location_id,
			    po_creation_ou_id,
			    sourcing_flag
		     from
		    (
		      select
		        fact.req_header_id,
			fact.req_line_id,
			fact.req_creation_ou_id,
			fact.requester_id,
			fact.req_approved_date POA_ATTRIBUTE3,
			fact.expected_date POA_ATTRIBUTE4,
			fact.po_item_id,
			fact.supplier_id,
			fact.line_amount_' || l_cur_suffix || ' POA_MEASURE3,
			sum(fact.line_amount_' || l_cur_suffix || ') over() POA_MEASURE6,
			fact.po_line_location_id,
			fact.po_creation_ou_id,
			fact.sourcing_flag
	      from
	        poa_dbi_req_f fact '  || l_in_join_tables || '
          where
		     fact.req_approved_date is not null
		 and fact.po_approved_date is null '
		 || l_where_clause || fnd_global.newline ||
		 l_context_where || fnd_global.newline ||
         l_bucket_where ||
			')) i2 where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)) i3 '||l_rownum_where||' ) i,
		        po_requisition_headers_all prh,
			po_requisition_lines_all prl,
			po_headers_all poh,
			po_line_locations_all pll,
			poa_items_v item,
			poa_suppliers_v supplier,
			per_all_people_f perf,
			hr_all_organization_units_vl rorg,
			hr_all_organization_units_vl porg,
                        po_releases_all por ';