PSA Encumbrance Detail Trial Balance

Description
Categories: BI Publisher, Financials
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 Name SQL text Validation
PSA_SRS_COA_ID_BYLEDGER
 
LOV Oracle
Report Group By
 
LOV Oracle
Encumbrance Type
 
LOV Oracle
Account To
 
Account From
 
Period
 
LOV Oracle
Ledger
 
LOV Oracle