PK_RELEASEPK_LIC_REL_VW(SQL View) |
Index Back |
|---|---|
Packaging - Product Licensing |
| SELECT DISTINCT a.pk_release FROM PS_PK_LICENSE_CODE a WHERE a.eff_status = 'A' AND a.effdt = ( SELECT MAX(a1.effdt) FROM PS_PK_LICENSE_CODE a1 WHERE a1.pk_license_code = a.pk_license_code AND a1.pk_release = a.pk_release AND a1.pk_product_line = a.pk_product_line AND a1.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PK_RELEASE |
Character(10) | VARCHAR2(10) NOT NULL | Release |