VIEW: APPS.CE_P_BA_SIGNATORY_HIST_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'