eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: IBY.IBY_ACK_PMT_ALL#

Object Details

Object Name:	IBY_ACK_PMT_ALL#
Object Type:	VIEW
Owner:	IBY
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACK_PMT_ID	NUMBER	(15)	Yes
PAYMENT_REF_NUMBER	NUMBER	(15)	Yes
PAYMENT_INSTRUCTION_REF_NUMBER	NUMBER	(15)
BANK_STATUS_CODE	VARCHAR2	(30)	Yes
PAYMENT_ACK_STATUS	VARCHAR2	(30)	Yes
ACKNOWLEDGEMENT_DATE	DATE		Yes
BANK_ASSIGNED_REF_CODE1	VARCHAR2	(80)
BANK_ASSIGNED_REF_CODE2	VARCHAR2	(80)
PAYER_NAME	VARCHAR2	(360)
PAYER_BANK_NAME	VARCHAR2	(360)
PAYER_BANK_BRANCH_NAME	VARCHAR2	(360)
PAYER_BANK_SWIFT_CODE	VARCHAR2	(12)
PAYER_BANK_ACCOUNT_NUMBER	VARCHAR2	(30)
PAYER_BANK_IBAN_NUMBER	VARCHAR2	(40)
PAYEE_NAME	VARCHAR2	(360)
PAYEE_BANK_NAME	VARCHAR2	(360)
PAYEE_BANK_BRANCH_NAME	VARCHAR2	(360)
PAYEE_BANK_SWIFT_CODE	VARCHAR2	(12)
PAYEE_BANK_ACCOUNT_NUMBER	VARCHAR2	(30)
PAYEE_BANK_IBAN_NUMBER	VARCHAR2	(40)
PAYMENT_AMOUNT	NUMBER
BANK_CHARGE_AMOUNT	NUMBER
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)
EXCHANGE_RATE	NUMBER
CALCULATED_PAYMENT_AMOUNT	NUMBER
CALCULATED_BANK_CHARGE_AMOUNT	NUMBER
VALUE_DATE	DATE
REQUESTED_EXECUTION_DATE	DATE
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACK_PMT_ID
,      PAYMENT_REF_NUMBER
,      PAYMENT_INSTRUCTION_REF_NUMBER
,      BANK_STATUS_CODE
,      PAYMENT_ACK_STATUS
,      ACKNOWLEDGEMENT_DATE
,      BANK_ASSIGNED_REF_CODE1
,      BANK_ASSIGNED_REF_CODE2
,      PAYER_NAME
,      PAYER_BANK_NAME
,      PAYER_BANK_BRANCH_NAME
,      PAYER_BANK_SWIFT_CODE
,      PAYER_BANK_ACCOUNT_NUMBER
,      PAYER_BANK_IBAN_NUMBER
,      PAYEE_NAME
,      PAYEE_BANK_NAME
,      PAYEE_BANK_BRANCH_NAME
,      PAYEE_BANK_SWIFT_CODE
,      PAYEE_BANK_ACCOUNT_NUMBER
,      PAYEE_BANK_IBAN_NUMBER
,      PAYMENT_AMOUNT
,      BANK_CHARGE_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      EXCHANGE_RATE
,      CALCULATED_PAYMENT_AMOUNT
,      CALCULATED_BANK_CHARGE_AMOUNT
,      VALUE_DATE
,      REQUESTED_EXECUTION_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IBY.IBY_ACK_PMT_ALL#;

Dependencies

[top of page]

IBY.IBY_ACK_PMT_ALL# references the following:

IBY: IBY_ACK_PMT_ALL

IBY.IBY_ACK_PMT_ALL# is referenced by following:

APPS: IBY_ACK_PMT_ALL