TRN_IDAR_WC_TRID_F_VW(SQL View) |
Index Back |
|---|---|
Transfer Worksheet View |
| SELECT A.TRN_ID FROM PS_TRN_CONTROL A LEFT OUTER JOIN PS_TRN_ITEM D ON A.TRN_BU=D.TRN_BU AND A.TRN_ID=D.TRN_ID AND A.BUSINESS_UNIT= D.BUSINESS_UNIT LEFT OUTER JOIN PS_TRN_ID_CUST B ON B.TRN_BU= D.TRN_BU AND B.TRN_ID=D.TRN_ID LEFT OUTER JOIN PS_TRN_ID_ITEM C ON B.TRN_BU=C.TRN_BU AND B.TRN_ID=C.TRN_ID WHERE A.POST_STATUS <>'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Transfer Worksheet ID |