AM_TXN_INT_VW

(SQL View)
 Index Back

Category

Selects the AM Business Unit + Category from those entries in INTFC PHY A for all load status values.

SELECT DISTINCT A.INTFC_TYPE , B.XLATLONGNAME FROM PS_INTFC_PHY_A A , %Table(XLATTABLE_VW) B WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND A.INTFC_TYPE <> ' ' AND B.FIELDNAME = 'INTFC_TYPE' AND A.INTFC_TYPE = %Substring(B.FIELDVALUE, 1, 3) AND %EffdtCheck(XLATTABLE_VW C, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' UNION SELECT DISTINCT A.INTFC_TYPE , B.XLATLONGNAME FROM PS_INTFC_FIN A , %Table(XLATTABLE_VW) B WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') AND A.INTFC_TYPE <> ' ' AND B.FIELDNAME = 'INTFC_TYPE' AND A.INTFC_TYPE = %Substring(B.FIELDVALUE, 1, 3) AND %EffdtCheck(XLATTABLE_VW C, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description