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
Run PSA Encumbrance Detail Trial Balance and other Oracle EBS reports with Blitz Report™ on our demo environment
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 PO Modification Data template PO IDV Modification FA Asset Book Details
Blitz Report™

Blitz Report™ provides multiple benefits: