PSC_BNP_ADAPTER_METHOD_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
ADAPTER_ID PAYMENT_METHOD_CODE ENABLED_FLAG SERVICE_CHARGE_PERCENT SERVICE_CHARGE_AMOUNT SERVICE_CHARGE_CURRENCY SERVICE_CHARGE_DESCR AGENCY_ID SPECIAL_INSTRUCTIONS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.ADAPTER_ID, B.PAYMENT_METHOD_CODE, B.ENABLED_FLAG, B.SERVICE_CHARGE_PERCENT, B.SERVICE_CHARGE_AMOUNT, B.SERVICE_CHARGE_CURRENCY, B.SERVICE_CHARGE_DESCR, B.AGENCY_ID, L.SPECIAL_INSTRUCTIONS, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM PSC_BNP_ADAPTER_METHOD_B B, PSC_BNP_ADAPTER_METHOD_TL L WHERE B.AGENCY_ID = L.AGENCY_ID AND B.ADAPTER_ID = L.ADAPTER_ID AND B.PAYMENT_METHOD_CODE = L.PAYMENT_METHOD_CODE AND L.LANGUAGE = USERENV('LANG')