PSA Encumbrance Detail Trial Balance

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector Financials
Source: Encumbrance Detail Trial Balance Report
Short Name: PSAENCTBR
DB package: psa_psaenctbr_pkg

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
DOCUMENT_NUM,
DOC_HEADER_ID  ,
V.LINE_NUM    ,
V.DISTRIBUTION_NUM,
DOC_DISTRIBUTION_ID,
LEDGER_ID,
DISTRIBUTION_TYPE,
ACTIVITY_AMOUNT,
ACTIVITY_QUANTITY,
GL_PERIOD,
ENCUMBRANCE_TYPE_ID,
SHIPMENT_NUM,
SUPPLIER_NAME,                                   
REQUISION_CREATE_BY,                       
REQUESTOR,                                           
REQUISITION_NUM,                               
BUYER,                                                   
APPROVED_DATE,                                   
APPROVAL_STATUS,                               
ITEM_DESCRIPTION,                             
LINE_TYPE,  
QUANTITY_ORDERED ,
QUANTITY_DELIVERED , 
QUANTITY_BILLED,               
QUANTITY_CANCELLED,
AMOUNT_BILLED,                       
AMOUNT_ORDERED,
AMOUNT_DELIVERED,
AMOUNT_CANCELLED ,
QUANTITY_DUE,
AMOUNT_DUE,
ENCUMBERED_AMOUNT, 
UOM,
NVL(BEG_ACTIVITY_AMOUNT,0) BEG_ACTIVITY_AMT,
(NVL(BEG_ACTIVITY_AMOUNT,0) + NVL(ACTIVITY_AMOUNT,0))  END_ACTIVITY_AMOUNT,
e.distribution_ccid INFO_DIST_CCID
FROM psa_enc_summary e, 
PO_PSA_POINFO_V v
WHERE e.distribution_ccid = :distribution_ccid
and &p_where4
and v.po_distribution_id   = e.doc_distribution_id
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Period 
 
 LOV Oracle
Account From 
 
 Char
Account To 
 
 Char
Encumbrance Type 
 
 LOV Oracle
Report Group By 
 
 LOV Oracle
Download
 
Related Blitz Reports
PN Generate Lease Details PSA Budgetary Control Transactions PAY IT3A Tax Certificates PAY Electronic Tax File PAY IRP5 Tax Certificates ECC Project Procurement, Approved Supplier List GL Balance PO Modification Data template FA Asset Book Details
Blitz Report™

Blitz Report™ provides multiple benefits: