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
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 NameSQL textValidation
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 QA: GL Balance CYTA Test: GL Balance
Blitz Report™