View: CE_P_BA_SIGNATORY_HIST_V

Product:	CE - Cash Management
Description:	Public view to show consolidated information of the bank account signatory's history for audit purposes
Implementation/DBA Data:	APPS.CE_P_BA_SIGNATORY_HIST_V

View Text

SELECT BASIG.ROWID
, BASIG.SIGNATORY_ID
, BASIG.BANK_ACCOUNT_ID
, BA.BANK_ACCOUNT_NUM
, BA.BANK_ACCOUNT_NAME
, BB.BANK_NAME
, BB.BANK_BRANCH_NAME
, BA.CURRENCY_CODE
, BASIG.PERSON_ID
, PPF.FULL_NAME
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE (SYSDATE
, PPF.PERSON_ID) PERSON_TYPE
, DECODE(PAAF.ORGANIZATION_ID
, NULL
, NULL
, HR_GENERAL.DECODE_ORGANIZATION(PAAF.ORGANIZATION_ID))
, DECODE(PAAF.JOB_ID
, NULL
, NULL
, HR_GENERAL.DECODE_JOB (PAAF.JOB_ID))
, PPF.INTERNAL_LOCATION
, PPF.EMAIL_ADDRESS
, BASIG.SINGLE_LIMIT_AMOUNT
, BASIG.JOINT_LIMIT_AMOUNT
, BASIG.SIGNER_GROUP
, BASIG.OTHER_LIMITS
, BASIG.START_DATE
, BASIG.END_DATE
, BASIG.STATUS
, BASIG.APPROVAL_TYPE_FLAG
, BASIG.DELETED_FLAG
, BASIG.REQUESTER_ID
, BASIGH.ACTION
, BASIGH.CREATED_BY
, BASIGH.CREATION_DATE
, BASIGH.CURRENT_RECORD_FLAG
, BASIG.CREATED_BY
, BASIG.CREATION_DATE
, BASIG.LAST_UPDATED_BY
, BASIG.LAST_UPDATE_DATE
, BASIG.LAST_UPDATE_LOGIN
, BASIG.ATTRIBUTE_CATEGORY
, BASIG.ATTRIBUTE1
, BASIG.ATTRIBUTE2
, BASIG.ATTRIBUTE3
, BASIG.ATTRIBUTE4
, BASIG.ATTRIBUTE5
, BASIG.ATTRIBUTE6
, BASIG.ATTRIBUTE7
, BASIG.ATTRIBUTE8
, BASIG.ATTRIBUTE9
, BASIG.ATTRIBUTE10
, BASIG.ATTRIBUTE11
, BASIG.ATTRIBUTE12
, BASIG.ATTRIBUTE13
, BASIG.ATTRIBUTE14
, BASIG.ATTRIBUTE15
FROM CE_BA_SIGNATORIES BASIG
, CE_BA_SIGNATORY_HIST_H BASIGH
, CE_BANK_ACCOUNTS_V BA
, CE_BANK_BRANCHES_V BB
, PER_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAAF
WHERE BASIG.PERSON_ID = PPF.PERSON_ID
AND BASIG.SIGNATORY_ID = BASIGH.SIGNATORY_ID
AND BA.BANK_ACCOUNT_ID = BASIG.BANK_ACCOUNT_ID
AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID
AND PPF.PERSON_ID = PAAF.PERSON_ID(+)
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE(+)
AND PAAF.EFFECTIVE_END_DATE(+)
AND PAAF.ASSIGNMENT_TYPE (+) <> 'B'
AND PAAF.PRIMARY_FLAG (+) = 'Y'

Columns