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

VIEW: APPS.IBY_EXT_FD_DOC_1_0_V

Object Details
Object Name: IBY_EXT_FD_DOC_1_0_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_EXT_FD_DOC_1_0_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_ID NUMBER (15)
DOCUMENT_PAYABLE_ID NUMBER (15)
PAYMENT_SERVICE_REQUEST_ID NUMBER (15)
CALLING_APP_DOC_UNIQUE_REF1 VARCHAR2 (100)
CALLING_APP_DOC_UNIQUE_REF2 VARCHAR2 (100)
CALLING_APP_DOC_UNIQUE_REF3 VARCHAR2 (100)
CALLING_APP_DOC_UNIQUE_REF4 VARCHAR2 (100)
CALLING_APP_DOC_UNIQUE_REF5 VARCHAR2 (100)
CALLING_APP_ID NUMBER (15)
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 (100)
CALLING_APP_DOCUMENT_UNIQUE_ID VARCHAR2 (100)
CALLING_APP_DOC_REF_NUMBER VARCHAR2 (100)
BANK_ASSIGNED_REF_CODE VARCHAR2 (4000)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
DOC_CATEGORY VARCHAR2 (30)
DOC_SEQUENCE_NAME VARCHAR2 (30)
DOC_SEQUENCE_VALUE NUMBER

PO_NUMBER VARCHAR2 (255)
DOCUMENT_STATUS VARCHAR2 (30)
DOCUMENT_STATUS_MEANING VARCHAR2 (80)
DOCUMENT_DATE DATE

DOCUMENT_CREATION_DATE DATE

PAYMENT_DUE_DATE DATE

DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_TYPE_MEANING VARCHAR2 (80)
DOCUMENT_DESCRIPTION VARCHAR2 (255)
DOCUMENT_AMOUNT NUMBER

DOCUMENT_CURRENCY_CODE VARCHAR2 (10)
PAYMENT_AMOUNT NUMBER

PAYMENT_CURRENCY_CODE VARCHAR2 (10)
DISCOUNT_DATE DATE

PAYMENT_CURR_DISCOUNT_TAKEN NUMBER

DOCUMENT_CURR_CHARGE_AMOUNT NUMBER

INTEREST_RATE NUMBER

BANK_CHARGE_BEARER VARCHAR2 (30)
BANK_CHARGE_BEARER_MEANING VARCHAR2 (80)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
DELIVERY_CHANNEL_MEANING VARCHAR2 (80)
DELIVERY_CHANNEL_FORMAT_VALUE VARCHAR2 (80)
SETTLEMENT_PRIORITY VARCHAR2 (30)
SETTLEMENT_PRIORITY_MEANING VARCHAR2 (80)
AMOUNT_WITHHELD NUMBER

PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON_MEANING VARCHAR2 (80)
PAYMENT_REASON_FORMAT_VALUE VARCHAR2 (80)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
DOC_PAYABLE_ATTR_CAT VARCHAR2 (150)
FORMATTING_PAYMENT_ID NUMBER (15)
EMPLOYEE_PAYMENT_FLAG VARCHAR2 (1)
BORDERO_INT_AMT NUMBER

BORDERO_ABATEMENT NUMBER

DOCUMENT_CURRENCY_TAX_AMOUNT NUMBER

EXPENSE_RPT_CC_NUM VARCHAR2 (4000)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (240)
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
DOC_PAYER_LE_NAME VARCHAR2 (240)
DOC_PAYER_LE_REG_NUM VARCHAR2 (30)
DOC_PAYER_TAX_REG_NUM VARCHAR2 (4000)
Query Text

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


SELECT PAYMENT_ID
,      DOCUMENT_PAYABLE_ID
,      PAYMENT_SERVICE_REQUEST_ID
,      CALLING_APP_DOC_UNIQUE_REF1
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      CALLING_APP_ID
,      PAY_PROC_TRXN_TYPE_CODE
,      CALLING_APP_DOCUMENT_UNIQUE_ID
,      CALLING_APP_DOC_REF_NUMBER
,      BANK_ASSIGNED_REF_CODE
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DOC_CATEGORY
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      PO_NUMBER
,      DOCUMENT_STATUS
,      DOCUMENT_STATUS_MEANING
,      DOCUMENT_DATE
,      DOCUMENT_CREATION_DATE
,      PAYMENT_DUE_DATE
,      DOCUMENT_TYPE
,      DOCUMENT_TYPE_MEANING
,      DOCUMENT_DESCRIPTION
,      DOCUMENT_AMOUNT
,      DOCUMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      DISCOUNT_DATE
,      PAYMENT_CURR_DISCOUNT_TAKEN
,      DOCUMENT_CURR_CHARGE_AMOUNT
,      INTEREST_RATE
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_BEARER_MEANING
,      EXCLUSIVE_PAYMENT_FLAG
,      DELIVERY_CHANNEL_CODE
,      DELIVERY_CHANNEL_MEANING
,      DELIVERY_CHANNEL_FORMAT_VALUE
,      SETTLEMENT_PRIORITY
,      SETTLEMENT_PRIORITY_MEANING
,      AMOUNT_WITHHELD
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_MEANING
,      PAYMENT_REASON_FORMAT_VALUE
,      PAYMENT_REASON_COMMENTS
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      DOC_PAYABLE_ATTR_CAT
,      FORMATTING_PAYMENT_ID
,      EMPLOYEE_PAYMENT_FLAG
,      BORDERO_INT_AMT
,      BORDERO_ABATEMENT
,      DOCUMENT_CURRENCY_TAX_AMOUNT
,      EXPENSE_RPT_CC_NUM
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      DOC_PAYER_LE_NAME
,      DOC_PAYER_LE_REG_NUM
,      DOC_PAYER_TAX_REG_NUM
FROM APPS.IBY_EXT_FD_DOC_1_0_V;

Dependencies

[top of page]

APPS.IBY_EXT_FD_DOC_1_0_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewIBY_EXT_FD_DOC_1_0_VT
PL/SQL PackageIBY_FD_EXTRACT_GEN_PVT - show dependent code
APPS.IBY_EXT_FD_DOC_1_0_V is referenced by following:

SchemaAPPS
ViewIBY_XML_FD_DOC_1_0_V