BUSINESS_UNITPO_SS_STDCOM_VW(SQL View) |
Index Back |
|---|
| SELECT D.BUSINESS_UNIT , C.EFFDT , C.STD_COMMENT_ID , A.COMMENTS_2000 FROM PS_COMMENTS_TBL A , PS_SET_CNTRL_REC B , PS_STD_COMM_TBL_PO C , PS_BUS_UNIT_TBL_PM D WHERE B.SETCNTRLVALUE = D.BUSINESS_UNIT AND B.RECNAME = 'STD_COMM_TBL_PO' AND C.STD_COMMENT_TYPE = D.STD_COMMENT_TYPE AND C.STD_COMMENT_ID = D.STD_COMMENT_ID AND C.SETID = C.SETID AND C.COMMENT_ID = A.COMMENT_ID AND C.OPRID = A.OPRID AND C.RANDOM_CMMT_NBR = A.RANDOM_CMMT_NBR AND C.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | STD_COMMENT_ID | Character(4) | VARCHAR2(4) NOT NULL | Standard Comment ID |
| 4 | COMMENTS_2000 | Long Character | CLOB | Comment Text |