BUSINESS_UNITLOCATIONBI_LOCATION_VW(SQL View) |
Index Back |
|---|---|
Billing Location View |
| SELECT BI.BUSINESS_UNIT , FS.DESCR , LOC.LOCATION , LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.CITY , LOC.STATE , ST.NUMERIC_CD , ST.DESCR , LOC.COUNTRY , LOC.POSTAL , LOC.PHONE FROM PS_BUS_UNIT_TBL_BI BI , PS_BUS_UNIT_TBL_FS FS , PS_LOCATION_TBL LOC , PS_STATE_TBL ST WHERE BI.BUSINESS_UNIT = FS.BUSINESS_UNIT AND LOC.SETID = ( SELECT REC.SETID FROM PS_SET_CNTRL_REC REC WHERE REC.SETCNTRLVALUE = BI.BUSINESS_UNIT AND REC.RECNAME = 'LOCATION_TBL') AND BI.LOCATION = LOC.LOCATION AND LOC.EFF_STATUS = 'A' AND LOC.COUNTRY = ST.COUNTRY AND LOC.STATE = ST.STATE AND LOC.EFFDT = ( SELECT MAX(LOC1.EFFDT) FROM PS_LOCATION_TBL LOC1 WHERE LOC.SETID = LOC1.SETID AND LOC.LOCATION = LOC1.LOCATION AND LOC1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 4 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 5 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 6 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 8 | NUMERIC_CD | Character(2) | VARCHAR2(2) NOT NULL | Numeric Code |
| 9 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 10 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |