LM_DMTH_IVW_LNG(SQL View) |
Index Back |
---|---|
Delivery Method Related LngShows current(effdt), active delivery methods for current active Catalog Items |
SELECT DM.LM_CI_ID , DMTLNG.LM_DMTHD_TYPE_ID , DMTLNG.LANGUAGE_CD , DMTLNG.LM_DM_LONG_NM FROM PS_LM_DMTHD_TBL DM , PS_LM_DMTH_TYP_LNG DMTLNG , PS_LM_CI_TBL CI WHERE DM.LM_DMTHD_TYPE_ID = DMTLNG.LM_DMTHD_TYPE_ID AND %CurrentDateIn BETWEEN DM.EFFDT AND DM.LM_END_EFFDT AND DM.LM_DM_STATUS = '10' AND DM.LM_CI_ID = CI.LM_CI_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND CI.LM_CI_STATUS = '10' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
2 | LM_DMTHD_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |