SPA_EXP_ACTV_VW

(SQL View)
 Index Back

Active Expenses View

Active Expenses View

SELECT W.WO_CONID ,X.BUSINESS_UNIT ,X.WORK_ORDER_ID ,X.DISTRIB_LINE_NUM ,X.SHEET_ID ,E.EXP_HDR_STATUS ,E.CREATION_DT ,SUM(L.AMOUNT_BSE) AS AMOUNT_BSE ,SUM(L.MONETARY_AMOUNT) ,L.CURRENCY_CD ,L.CURRENCY_CD_BASE ,B.DESCRSHORT ,W.WO_NAME , ' ' FROM PS_SPA_EXP_XREF X , PS_SPA_SHEET_HDR E , PS_SPA_SHEET_LINE L , PS_SPF_WORDERREC W , PS_BUS_UNIT_TBL_FS B WHERE E.SHEET_ID = L.SHEET_ID AND L.SHEET_ID = X.SHEET_ID AND B.BUSINESS_UNIT = W.BUSINESS_UNIT AND W.BUSINESS_UNIT = X.BUSINESS_UNIT AND W.WORK_ORDER_ID = X.WORK_ORDER_ID AND E.EXP_HDR_STATUS IN ('OPN','DEN') GROUP BY W.WO_CONID,X.BUSINESS_UNIT ,X.WORK_ORDER_ID ,X.DISTRIB_LINE_NUM ,X.SHEET_ID ,E.EXP_HDR_STATUS ,E.CREATION_DT ,L.CURRENCY_CD ,L.CURRENCY_CD_BASE, B.DESCRSHORT , W.WO_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
6 SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Report Status
APY=Approved for Payment
APZ=Approved For Zero Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
MFS=Marked for Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
7 CREATION_DT Date(10) DATE Creation Date
8 SPF_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount for base currency
9 SPF_EXPENSE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount.
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
12 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
13 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name
14 DESCR Character(30) VARCHAR2(30) NOT NULL Description