EODL_DLGT_MAPLN

(SQL View)
 Index Back

AdHoc Sal Chg - Pending Txn Vw

This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , X.TRANSACTION_NAME , X.EODL_TRAN_ALLOWED , A.FROM_DATE , C.LANGUAGE_CD , C.DESCR FROM PS_EODL_APPR_XREF X , PS_EODL_DELEGATION A , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_EODL_TXN_LANG C WHERE X.EODL_DELEGATOR_OID = A.EODL_DELEGATOR_OID AND X.EODL_DELEGATOR_RCD = A.EODL_DELEGATOR_RCD AND X.EODL_PROXY_OID = A.EODL_PROXY_OID AND X.TRANSACTION_NAME IN ( SELECT A1.TRANSACTION_NAME FROM PS_EODL_DELEGATION A1 WHERE A1.EODL_DELEGATOR_OID = A.EODL_DELEGATOR_OID AND A1.EODL_DELEGATOR_RCD = A.EODL_DELEGATOR_RCD AND A1.FROM_DATE = A.FROM_DATE AND A1.Transaction_Nbr = A.Transaction_Nbr) AND X.FROM_DATE = A.FROM_DATE AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND A.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = C.EODL_TRAN_ALLOWED

  • Related Language Record for EODL_DLGT_MAP_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODL_DELEGATOR_OID Character(30) VARCHAR2(30) NOT NULL Delegator User Id
    2 EODL_DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
    3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    4 EODL_TRAN_ALLOWED Character(1) VARCHAR2(1) NOT NULL Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate.
    A=Approve
    I=Initiate
    5 FROM_DATE Date(10) DATE From Date
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description