[Home] [Help]
[Dependency Information]
Object Name: | IBY_XML_FD_PMT_1_0_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT | XMLTYPE | (64) | ||
PAYMENT_INSTRUCTION_ID | NUMBER | (15) | ||
INTERNAL_BANK_ACCOUNT_ID | NUMBER | (15) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
PAYMENT_ID | NUMBER | (15) | ||
PAYMENT_STATUS | VARCHAR2 | (30) | ||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (10) | ||
PAYMENT_SERVICE_REQUEST_ID | NUMBER | (15) | ||
POSITIVE_PAY_FILE_CREATED_FLAG | VARCHAR2 | (1) | ||
PAYMENT_DATE | DATE | Specifies the date on which payment is made | ||
VOID_DATE | DATE | |||
LOGICAL_GROUP_REFERENCE | VARCHAR2 | (200) | Specifies the reference of the group to which this payment belongs to |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT
, PAYMENT_INSTRUCTION_ID
, INTERNAL_BANK_ACCOUNT_ID
, LEGAL_ENTITY_ID
, PAYMENT_ID
, PAYMENT_STATUS
, PAYMENT_CURRENCY_CODE
, PAYMENT_SERVICE_REQUEST_ID
, POSITIVE_PAY_FILE_CREATED_FLAG
, PAYMENT_DATE
, VOID_DATE
, LOGICAL_GROUP_REFERENCE
FROM APPS.IBY_XML_FD_PMT_1_0_V;
|
|
|