WM_TSK_AREA_LVW

(SQL View)
 Index Back

Work Order Task Area


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , C.LANGUAGE_CD , C.DESCR FROM PS_WM_WO_TSK A , PS_AM_AREA_LANG C , PS_SET_CNTRL_REC S WHERE S.REC_GROUP_ID = 'FS_26' AND S.RECNAME = 'AM_AREA_TBL' AND S.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.SETID = S.SETID AND C.LOCATION = A.ASSET_LOCATION AND C.AREA_ID = A.AREA_ID AND C.EFFDT = ( SELECT MAX(EC.EFFDT) FROM PS_AM_AREA_TBL EC WHERE EC.SETID = C.SETID AND EC.LOCATION = C.LOCATION AND EC.AREA_ID = C.AREA_ID AND EC.EFFDT <= %CurrentDateIn)

  • Related Language Record for WM_TSK_AREA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
    3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description