CUSTOM IDC Bank Letter for Authorized Signatories
Description
Categories: BI Publisher
Application: Custom Development
Source: IDC Bank Letter for Authorized Signatories
Short Name: IDC_AUTH_SIGN_LETTER
DB package:
Source: IDC Bank Letter for Authorized Signatories
Short Name: IDC_AUTH_SIGN_LETTER
DB package:
Run
CUSTOM IDC Bank Letter for Authorized Signatories and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT HP.PARTY_NAME BANK_NAME, CBA.BANK_ACCOUNT_NUM ACCOUNT_NUMBER, PPF.FULL_NAME PERSON_NAME, BASIG.SINGLE_LIMIT_AMOUNT, BASIG.JOINT_LIMIT_AMOUNT, DECODE(PAAF.ORGANIZATION_ID,NULL,NULL, HR_GENERAL.DECODE_ORGANIZATION(PAAF.ORGANIZATION_ID)) HR_ORG, SUBSTR(DECODE(PAAF.JOB_ID,NULL,NULL,HR_GENERAL.DECODE_JOB (PAAF.JOB_ID)),INSTR(DECODE(PAAF.JOB_ID,NULL,NULL,HR_GENERAL.DECODE_JOB (PAAF.JOB_ID)),'.')+1) JOB, INITCAP(basig.signer_group), basig.other_limits FROM CE_BA_SIGNATORIES BASIG , PER_PEOPLE_F PPF , PER_ALL_ASSIGNMENTS_F PAAF , CE_BANK_ACCOUNTS CBA , HZ_PARTIES HP WHERE BASIG.PERSON_ID = PPF.PERSON_ID AND BASIG.DELETED_FLAG = 'N' AND BASIG.END_DATE IS NULL 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' AND BASIG.BANK_ACCOUNT_ID=CBA.BANK_ACCOUNT_ID AND CBA.BANK_ID=HP.PARTY_ID AND HP.PARTY_ID=:PARAM1 AND BASIG.BANK_ACCOUNT_ID=NVL(:PARAM2,BASIG.BANK_ACCOUNT_ID) ORDER BY BASIG.BANK_ACCOUNT_ID,BASIG.END_DATE DESC |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Bank Name |
|
LOV Oracle | |
Bank Account Number |
|
LOV Oracle |