CATEGORY_CDPrompt Table: %EDITTABLE26
LANGUAGE_CDPL_TR_ITMCATLVW(SQL View) |
Index Back |
|---|---|
Category Codes by PL_SF_OP_HDRCategory Codes by PL_SF_OP_HEADER |
| SELECT DISTINCT D.CATEGORY_CD , D.LANGUAGE_CD , D.DESCR60 FROM PS_DEM_CHG_INF_INV A , PS_PL_BU_ITEMS B , PS_SET_CNTRL_REC C , PS_ITM_CAT_TBL_LNG D WHERE A.INV_ITEM_ID =B.INV_ITEM_ID AND A.DESTIN_BU = C.SETCNTRLVALUE AND C.RECNAME = 'ITM_CAT_TBL' AND C.SETID = D.SETID AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.CATEGORY_ID = D.CATEGORY_ID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_ITM_CAT_TBL D1 WHERE D1.SETID = D.SETID AND D1.CATEGORY_TYPE = D.CATEGORY_TYPE AND D1.CATEGORY_ID = D.CATEGORY_ID AND D1.EFF_STATUS = 'A' AND D1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CATEGORY_CD |
Character(18) | VARCHAR2(18) NOT NULL |
Category Code
Prompt Table: %EDITTABLE26 |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |