WM_TSK_AREA_VW

(SQL View)
 Index Back

Work Order Task Area


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.ASSET_LOCATION , A.AREA_ID , C.DESCR FROM PS_WM_WO_TSK A , PS_AM_AREA_TBL 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: WM_TSK_AREA_LVW

    • # 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 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    5 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description