SF_RPLS_L2_VW(SQL View) |
Index Back |
---|---|
SF Repl Stor Level 2 View |
SELECT DISTINCT business_unit , sf_rpl_stor_area , sf_rpl_stor_lev1 , sf_rpl_stor_lev2 FROM PS_SF_WIP_RPL_REQ WHERE sf_rpl_source = '1' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | SF_RPL_STOR_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
3 | SF_RPL_STOR_LEV1 | Character(4) | VARCHAR2(4) NOT NULL | Level 1 |
4 | SF_RPL_STOR_LEV2 | Character(4) | VARCHAR2(4) NOT NULL | Level 2 |