JA India - Purchase Register - draft

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Purchase Register Report (XML) - Not Supported: Reserved For Future Use
Short Name: JAINPRRG_XML
DB package: JA_JAINPRRG_XMLP_PKG
SELECT
    vendor_id,
    vendor_site_id,
    invoice_id,
    invoice_num,
    invoice_date,
    invoice_currency_code,
    voucher_num,
    exchange_rate,
    po_number,
    po_header_id,
    po_release_num,
    po_creation_date,
    receipt_number,
    receipt_date,
    round(sum(line_amount), :p_rnd_fact)			                line_amount,
    round(sum(excise), :p_rnd_fact)				excise,
    round(sum(customs), :p_rnd_fact)				customs,
    round(sum(cvd), :p_rnd_fact)				cvd,
    round(sum(additional_cvd), :p_rnd_fact)			addcvd,     
    round(sum(cst), :p_rnd_fact)				cst,
    round(sum(lst), :p_rnd_fact)				                lst,
    round(sum(freight), :p_rnd_fact)				freight,
    round(sum(octroi), :p_rnd_fact)				octroi,
    round(sum(others), :p_rnd_fact)				others,
    round( sum(NVL(vat,0) ), :p_rnd_fact )    vat ,    
    round(sum(nvl(service_tax,0)), :p_rnd_fact)    service_tax, 
    round(sum(line_amount)*exchange_rate, :p_rnd_fact)		inr_line_amount,
    round(sum(excise)*exchange_rate, :p_rnd_fact)		                inr_excise,
    round(sum(customs)*exchange_rate, :p_rnd_fact)		inr_customs,
    round(sum(cvd)*exchange_rate, :p_rnd_fact)			inr_cvd,
    round(sum(additional_cvd)*exchange_rate, :p_rnd_fact)	                inr_addcvd,  
    round(sum(cst)*exchange_rate, :p_rnd_fact)			inr_cst,
    round(sum(lst)*exchange_rate, :p_rnd_fact)			inr_lst,
    round(sum(freight)*exchange_rate, :p_rnd_fact)		                inr_freight,
    round(sum(octroi)*exchange_rate, :p_rnd_fact)		                inr_octroi,
    round(sum(others)*exchange_rate, :p_rnd_fact)		                inr_others,
    round( sum(NVL(vat,0)) * exchange_rate , :p_rnd_fact)   inr_tot_vat ,
    round(sum(nvl(service_tax,0))*exchange_rate, :p_rnd_fact)             inr_service,
    round( sum( line_amount + 
                excise + 
		customs + 
		cvd + 
		additional_cvd  + 
		cst + 
		lst + 
		freight + 
		octroi + 
		others + 
		vat + 
		service_tax 
	     ), :p_rnd_fact)		        total_amount,
    round( sum( line_amount + 
                excise + 
		customs + 
		cvd + 
		additional_cvd  + 
		cst + 
		lst + 
		freight + 
		octroi + 
		others + 
		vat +  
		service_tax 
	      )*exchange_rate, :p_rnd_fact)	inr_total_amount, 
	JA_JAINPRRG_XMLP_PKG.cf_total_amountformula(:cs_line_amount, :cs_excise, :cs_cvd, :cs_addcvd, :cs_customs, :cs_cst, :cs_lst, :cs_freight, :cs_octroi, :cs_others) cf_total_amount, 
	JA_JAINPRRG_XMLP_PKG.cf_vendor_nameformula(vendor_id) cf_vendor_name, 
	JA_JAINPRRG_XMLP_PKG.cf_vendor_site_codeformula(vendor_site_id) cf_vendor_site_code, 
	JA_JAINPRRG_XMLP_PKG.cf_po_num_n_releaseformula(po_number, po_release_num) cf_po_num_n_release,
	JA_JAINPRRG_XMLP_PKG.cp_serial_p cp_serial
	--,JA_JAINPRRG_XMLP_PKG.P_ORG_ADDR1ValidTrigger
FROM JAI_PO_REP_PRRG_T
WHERE run_no = :lp_run_no
GROUP BY 
    vendor_id, vendor_site_id,
    invoice_id, invoice_num, invoice_date, invoice_currency_code, voucher_num, exchange_rate,
    po_number, po_header_id, po_release_num, po_creation_date,
    receipt_number, receipt_date
ORDER BY
    vendor_id, vendor_site_id, invoice_id, po_header_id, po_release_num, receipt_number
Parameter Name SQL text Validation
Commit Temp Data
 
LOV Oracle
Operating Unit
 
Number
End Date
 
Date
Start Date
 
Date
Vendor Site
 
LOV Oracle
Vendor Name
 
LOV Oracle
Ask a question