PGM_SO_GEN_VW

(SQL View)
 Index Back

SO Gen Resourc View

View of SO related to a Gen Resource on Project Team

SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,B.REQUIREMENT_ID ,A.SO_ID ,B.SO_LINE ,B.SO_LINE_STATUS FROM %Table(RS_SO_HDR) A , %Table(RS_SO_LINE) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.REQUIREMENT_ID <> ' ' AND B.SO_LINE_STATUS = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PROJECT.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_VW

3 GEN_RESOURCE Character(30) VARCHAR2(30) NOT NULL Generic Resource Name
4 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
5 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
6 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Closed
C=Cancel
O=Open