Reports2017-11-18T12:27:27+00:00

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
By continuing to use the site, you agree to the use of cookies. Accept