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

VIEW: APPS.IBY_EXT_FD_PMT_1_0_VT

Object Details
Object Name: IBY_EXT_FD_PMT_1_0_VT
Object Type: VIEW
Owner: APPS
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_INSTRUCTION_ID NUMBER (15)
PAYMENT_ID NUMBER (15)
INTERNAL_BANK_ACCOUNT_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15)
CALLING_APP_ID NUMBER

APPLICATION_NAME VARCHAR2 (50)
PAYMENT_SERVICE_REQUEST_ID NUMBER (15)
PAYMENT_FUNCTION VARCHAR2 (30)
PAYMENT_FUNCTION_MEANING VARCHAR2 (80)
PAYMENT_ORG_ID NUMBER (15)
PAYMENT_ORG_TYPE VARCHAR2 (30)
PAYMENT_ORG_TYPE_MEANING VARCHAR2 (80)
PAYMENT_ORG_NAME VARCHAR2 (240)
PAYMENT_DOC_CATEGORY VARCHAR2 (30)
PAYMENT_DOC_SEQUENCE_NAME VARCHAR2 (30)
PAYMENT_DOC_SEQUENCE_VALUE NUMBER

PAYMENT_REFERENCE_NUMBER NUMBER (15)
PAPER_DOCUMENT_NUMBER NUMBER (15)
PAYMENT_DATE DATE

PAYMENT_DUE_DATE DATE

MATURITY_DATE DATE

PAYMENT_STATUS VARCHAR2 (30)
PAYMENT_STATUS_MEANING VARCHAR2 (80)
PAYEE_PARTY_ID NUMBER (15)
PAYEE_PARTY_SITE_USE_ID NUMBER (15)
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
PAYMENT_AMOUNT NUMBER

PAYMENT_CURRENCY_CODE VARCHAR2 (10)
PAYMENT_AMOUNT_TEXT VARCHAR2 (4000)
PAYMENT_METHOD_CODE VARCHAR2 (30)
PAYMENT_METHOD_NAME VARCHAR2 (100)
PAYMENT_METHOD_ATTR_CAT VARCHAR2 (150)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
SETTLEMENT_PRIORITY VARCHAR2 (30)
SETTLEMENT_PRIORITY_MEANING VARCHAR2 (80)
AMOUNT_WITHHELD NUMBER

DISCOUNT_AMOUNT_TAKEN NUMBER

BANK_CHARGE_BEARER VARCHAR2 (30)
BANK_CHARGE_BEARER_MEANING VARCHAR2 (80)
BANK_CHARGE_AMOUNT NUMBER

DELIVERY_CHANNEL_CODE VARCHAR2 (30)
DELIVERY_CHANNEL_MEANING VARCHAR2 (80)
DELIVERY_CHANNEL_FORMAT_VALUE VARCHAR2 (80)
BANK_INSTRUCTION1_CODE VARCHAR2 (30)
BANK_INSTRUCTION1_MEANING VARCHAR2 (80)
BANK_INSTRUCTION1_FORMAT_VALUE VARCHAR2 (80)
BANK_INSTRUCTION2_CODE VARCHAR2 (30)
BANK_INSTRUCTION2_MEANING VARCHAR2 (80)
BANK_INSTRUCTION2_FORMAT_VALUE VARCHAR2 (80)
BANK_INSTRUCTION_DETAILS VARCHAR2 (255)
PAYMENT_TEXT_MESSAGE1 VARCHAR2 (150)
PAYMENT_TEXT_MESSAGE2 VARCHAR2 (150)
PAYMENT_TEXT_MESSAGE3 VARCHAR2 (150)
PAYMENT_DETAILS VARCHAR2 (4000)
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
URI_CHECK_DIGIT VARCHAR2 (2)
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)
DECLARE_PAYMENT_FLAG VARCHAR2 (1)
DECLARATION_AMOUNT NUMBER

DECLARATION_CURRENCY_CODE VARCHAR2 (10)
FEDERAL_ALLOTMENT_CODE VARCHAR2 (4000)
FEDERAL_OFFSET_ELIGIBILITY VARCHAR2 (4000)
PAYMENT_ATTR_CAT VARCHAR2 (150)
BENEFICIARY_NAME VARCHAR2 (360)
FEDERAL_SPS_TREASURY_SYMBOL VARCHAR2 (4000)
EMPLOYEE_PAYMENT_FLAG VARCHAR2 (1)
PAYMENT_METHOD_FORMAT_VALUE VARCHAR2 (80)
POSITIVE_PAY_FILE_CREATED_FLAG VARCHAR2 (1)
VOID_DATE DATE

LOGICAL_GROUP_REFERENCE VARCHAR2 (200)
Specifies the reference to the group to which this payment belongs
PAYMENT_PROFILE_ID NUMBER (15)
ANTICIPATED_VALUE_DATE DATE

Query Text

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


SELECT PAYMENT_INSTRUCTION_ID
,      PAYMENT_ID
,      INTERNAL_BANK_ACCOUNT_ID
,      LEGAL_ENTITY_ID
,      CALLING_APP_ID
,      APPLICATION_NAME
,      PAYMENT_SERVICE_REQUEST_ID
,      PAYMENT_FUNCTION
,      PAYMENT_FUNCTION_MEANING
,      PAYMENT_ORG_ID
,      PAYMENT_ORG_TYPE
,      PAYMENT_ORG_TYPE_MEANING
,      PAYMENT_ORG_NAME
,      PAYMENT_DOC_CATEGORY
,      PAYMENT_DOC_SEQUENCE_NAME
,      PAYMENT_DOC_SEQUENCE_VALUE
,      PAYMENT_REFERENCE_NUMBER
,      PAPER_DOCUMENT_NUMBER
,      PAYMENT_DATE
,      PAYMENT_DUE_DATE
,      MATURITY_DATE
,      PAYMENT_STATUS
,      PAYMENT_STATUS_MEANING
,      PAYEE_PARTY_ID
,      PAYEE_PARTY_SITE_USE_ID
,      EXTERNAL_BANK_ACCOUNT_ID
,      PAYMENT_AMOUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT_TEXT
,      PAYMENT_METHOD_CODE
,      PAYMENT_METHOD_NAME
,      PAYMENT_METHOD_ATTR_CAT
,      EXCLUSIVE_PAYMENT_FLAG
,      SETTLEMENT_PRIORITY
,      SETTLEMENT_PRIORITY_MEANING
,      AMOUNT_WITHHELD
,      DISCOUNT_AMOUNT_TAKEN
,      BANK_CHARGE_BEARER
,      BANK_CHARGE_BEARER_MEANING
,      BANK_CHARGE_AMOUNT
,      DELIVERY_CHANNEL_CODE
,      DELIVERY_CHANNEL_MEANING
,      DELIVERY_CHANNEL_FORMAT_VALUE
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION1_MEANING
,      BANK_INSTRUCTION1_FORMAT_VALUE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION2_MEANING
,      BANK_INSTRUCTION2_FORMAT_VALUE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      PAYMENT_TEXT_MESSAGE3
,      PAYMENT_DETAILS
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_MEANING
,      PAYMENT_REASON_FORMAT_VALUE
,      PAYMENT_REASON_COMMENTS
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      DECLARE_PAYMENT_FLAG
,      DECLARATION_AMOUNT
,      DECLARATION_CURRENCY_CODE
,      FEDERAL_ALLOTMENT_CODE
,      FEDERAL_OFFSET_ELIGIBILITY
,      PAYMENT_ATTR_CAT
,      BENEFICIARY_NAME
,      FEDERAL_SPS_TREASURY_SYMBOL
,      EMPLOYEE_PAYMENT_FLAG
,      PAYMENT_METHOD_FORMAT_VALUE
,      POSITIVE_PAY_FILE_CREATED_FLAG
,      VOID_DATE
,      LOGICAL_GROUP_REFERENCE
,      PAYMENT_PROFILE_ID
,      ANTICIPATED_VALUE_DATE
FROM APPS.IBY_EXT_FD_PMT_1_0_VT;

Dependencies

[top of page]

APPS.IBY_EXT_FD_PMT_1_0_VT references the following:

SchemaAPPS
SynonymCE_SECURITY_PROFILES_GT
SynonymFND_APPLICATION
SynonymFND_DOCUMENT_SEQUENCES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewIBY_BANK_INSTRUCTIONS_VL
ViewIBY_DELIVERY_CHANNELS_VL
PL/SQL PackageIBY_FD_EXTRACT_GEN_PVT - show dependent code
SynonymIBY_PAYMENTS_ALL
ViewIBY_PAYMENT_METHODS_VL
ViewIBY_PAYMENT_REASONS_VL
SynonymIBY_PAY_SERVICE_REQUESTS
APPS.IBY_EXT_FD_PMT_1_0_VT is referenced by following:

SchemaAPPS
ViewIBY_EXT_FD_PMT_1_0_V