SHIPTO_IDRECV_INSPSHIPTO(SQL View) |
Index Back |
|---|---|
Receipt Insp Shipto View |
| select distinct H.shipto_id, A.descr from ps_recv_hdr H, PS_SHIPTO_TBL A where H.setid = A.setid and H.shipto_id = a.shipto_id and A.EFFDT = (select max(B.EFFDT) from PS_SHIPTO_TBL B where A.SETID = B.SETID and A.SHIPTO_ID = B.SHIPTO_ID and B.EFFDT <= %currentdatein) and A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |