PO Savings Analysis Report(by Buyer)

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Savings Analysis Report(by Buyer)
Application: Purchasing
Source: Savings Analysis Report(by Buyer) (XML)
Short Name: POXKISUM_XML
DB package: PO_POXKISUM_XMLP_PKG
Run PO Savings Analysis Report(by Buyer) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   distinct pol.line_num                 	Line
,        plt.line_type                                     	Line_type
,        pol.item_description                         	Item_description
,        pol.unit_meas_lookup_code            	Unit
,        plc1.displayed_field	 	List_code
,        plc2.displayed_field		Market_code
,        plc3.displayed_field		Quote_code
,        to_number( nvl(pol.unit_price,0) * nvl(poh.rate,1))       Actual_price
,        decode(poh.creation_date,NULL,decode((pll.promised_date),NULL,decode( (pll.need_by_date),NULL,sysdate,pll.need_by_date),pll.promised_date),
poh.creation_date)			Quote_date
,        pol.po_header_id                             	PO_header_id1
,        pol.market_price                	Market_price
,        pol.unit_price                      	Line_price
,        pol.list_price_per_unit       	List
,        poh.rate                                	Rate
,        pol.quantity                           	Line_quantity
,        poh.creation_date		Creation_date
,        pol.item_id			Item_id
,        pll.ship_to_organization_id  	Ship_to_org
,        pll.ship_to_location_id		Ship_to_loc
,        plt.order_type_lookup_code	Order_type
,        pll.shipment_num		Shipment_num
,        pll.quantity			Shipment_quantity
,        pll.quantity_cancelled                       Shipment_quantity_cancelled, 
/*	PO_POXKISUM_XMLP_PKG.return_discount(:C_AMOUNT_LIST1, :C_AMOUNT_ACTUAL1) C_DISCOUNT, 
	PO_POXKISUM_XMLP_PKG.return_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, poh.rate) C_LIST_PRICE, 
	PO_POXKISUM_XMLP_PKG.return_type(:C_MIN_QUOTE, plc3.displayed_field, pol.market_price, plc2.displayed_field, pol.list_price_per_unit, plc1.displayed_field) C_PRICE_TYPE, 
	PO_POXKISUM_XMLP_PKG.round_amount_list1(:C_AMOUNT_LIST1, :C_CURR_PRECISION) C_AMOUNT_LIST1_ROUND, */
	PO_POXKISUM_XMLP_PKG.get_quantity(pll.quantity, pll.quantity_cancelled, pol.quantity) C_QUANTITY, 
/*	PO_POXKISUM_XMLP_PKG.return_amt_list(:C_MIN_QUOTE, pol.market_price, pol.list_price_per_unit, :C_QUANTITY, poh.rate) C_AMOUNT_LIST1, 
*/	
	PO_POXKISUM_XMLP_PKG.return_amt_act(PO_POXKISUM_XMLP_PKG.get_quantity(pll.quantity, pll.quantity_cancelled, pol.quantity), pol.unit_price, poh.rate) C_AMOUNT_ACTUAL1 
/*	,PO_POXKISUM_XMLP_PKG.round_amount_actual1(:C_AMOUNT_ACTUAL1, :C_CURR_PRECISION) C_AMOUNT_ACTUAL1_ROUND, 
	PO_POXKISUM_XMLP_PKG.return_amt_saved(:C_AMOUNT_LIST1, :C_AMOUNT_ACTUAL1) C_AMOUNT_SAVED, 
	PO_POXKISUM_XMLP_PKG.round_amount_saved(:C_AMOUNT_SAVED, :C_CURR_PRECISION) C_AMOUNT_SAVED_ROUND*/
FROM     hr_locations_no_join            	hrl
,        po_line_types           	plt
,        po_headers              	poh
,        po_line_locations       	pll
,        po_lines                	pol
,        po_lookup_codes         	plc1
,        po_lookup_codes         	plc2
,        po_lookup_codes         	plc3
WHERE    pol.po_line_id          	= pll.po_line_id (+)
AND      pll.ship_to_location_id = hrl.location_id (+)
AND      pol.po_header_id     	= poh.po_header_id
AND      plt.line_type_id        	= pol.line_type_id
AND      plt.order_type_lookup_code != 'AMOUNT'
AND      plc1.lookup_type        	= 'LINE PRICE TYPE'
AND      plc1.lookup_code        	= 'LIST'
AND      plc2.lookup_type        	= 'LINE PRICE TYPE'                       
AND      plc2.lookup_code        	= 'MARKET'
AND      plc3.lookup_type        	= 'LINE PRICE TYPE'                       
AND      plc3.lookup_code        	= 'QUOTE' 
 and pol.po_header_id=:PO_header_id
ORDER BY pol.line_num, pll.shipment_num
Parameter Name SQL text Validation
Operating Unit
 
LOV
Title
 
Char
Creation Date From
 
Date
To
 
Date
Buyer Name
 
LOV Oracle
Sort By
 
LOV Oracle
Dynamic Precision Option
 
LOV Oracle
Blitz Report™