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

VIEW: APPS.ECE_PYO_INVOICE_V

Object Details
Object Name: ECE_PYO_INVOICE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_PYO_INVOICE_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view extracts invoices selected for payment to support
the outbound Payment Order/Remittance Advice (820/PAYORD/REMADV) transaction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYMENT_ID NUMBER (15)
PAYMENT ID
PAYMENT_INSTRUCTION_ID NUMBER (15)
PAYMENT INSTRUCTION ID
PAY_SELECTED_CHECK_ID VARCHAR2 (100)
Payment Number
VENDOR_NUM VARCHAR2 (30)
Supplier Number
CUSTOMER_NUM VARCHAR2 (100)
Customer Number Supplier Uses for Your Company
INVOICE_NUM VARCHAR2 (100) Yes Invoice Number
INVOICE_DATE DATE
Yes Invoice Date
INVOICE_DESCRIPTION VARCHAR2 (255)
Invoice Description
PROPOSED_PAYMENT_AMOUNT NUMBER
Yes Payment Amount
INVOICE_AMOUNT NUMBER
Yes Invoice Amount
DISCOUNT_AMOUNT VARCHAR2 (100)
Discount Amount
PRINT_SELECTED_CHECK_ID VARCHAR2 (100)
Print Selected Check ID
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Remittance Advice Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Remittance Advice Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Remittance Advice Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Remittance Advice Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Remittance Advice Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Remittance Advice Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Remittance Advice Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Remittance Advice Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Remittance Advice Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Remittance Advice Attribute 9
ATTRIBUTE10 VARCHAR2 (150)
Remittance Advice Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Remittance Advice Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Remittance Advice Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Remittance Advice Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Remittance Advice Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Remittance Advice Attribute 15
INV_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (240)
Invoice Global Attribute Category
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
Invoice Global Attribute 1
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
Invoice Global Attribute 2
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
Invoice Global Attribute 3
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
Invoice Global Attribute 4
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
Invoice Global Attribute 5
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
Invoice Global Attribute 6
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
Invoice Global Attribute 7
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
Invoice Global Attribute 8
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
Invoice Global Attribute 9
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
Invoice Global Attribute 10
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
Invoice Global Attribute 11
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
Invoice Global Attribute 12
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
Invoice Global Attribute 13
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
Invoice Global Attribute 14
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
Invoice Global Attribute 15
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
Invoice Global Attribute 16
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
Invoice Global Attribute 17
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
Invoice Global Attribute 18
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
Invoice Global Attribute 19
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
Invoice Global Attribute 20
BANK_CHARGE_BEARER VARCHAR2 (30)
BANK CHARGE BEARER
PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT REASON CODE
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
PAYMENT REASON COMMENTS
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE MESSAGE1
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE MESSAGE2
REMITTANCE_MESSAGE3 VARCHAR2 (150)
REMITTANCE MESSAGE3
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 (30)
UNIQUE_REMITTANCE IDENTIFIER
URI_CHECK_DIGIT VARCHAR2 (2)
URI CHECK DIGIT
DELIVERY_CHANNEL_CODE VARCHAR2 (30)
DELIVERY CHANNEL_CODE
SETTLEMENT_PRIORITY VARCHAR2 (30)
SETTLEMENT PRIORITY
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
EXTERNAL BANK ACCOUNT ID
PAYMENT_METHOD_CODE VARCHAR2 (30) Yes PAYMENT METHOD CODE
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER (15)
PAYMENT_MEAN VARCHAR2 (150)
PAYMENT_CHANNEL VARCHAR2 (150)
COUNTRY VARCHAR2 (60)
PAYMENT_PROCESS_REQUEST_NAME VARCHAR2 (255)
BANK_ACCOUNT_ID NUMBER (15)
VENDOR_BANK_ACCOUNT_ID NUMBER (15)
PAYMENT_REFERENCE_NUMBER NUMBER (15)
CHECK_NUMBER NUMBER (15)
AMOUNT_WITHHELD NUMBER

CALLING_APP_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)
DOCUMENT_SEQUENCE_ID NUMBER

DOCUMENT_SEQUENCE_VALUE NUMBER

DOCUMENT_CATEGORY_CODE VARCHAR2 (30)
Query Text

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


SELECT PAYMENT_ID
,      PAYMENT_INSTRUCTION_ID
,      PAY_SELECTED_CHECK_ID
,      VENDOR_NUM
,      CUSTOMER_NUM
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_DESCRIPTION
,      PROPOSED_PAYMENT_AMOUNT
,      INVOICE_AMOUNT
,      DISCOUNT_AMOUNT
,      PRINT_SELECTED_CHECK_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE_CATEGORY
,      INV_GLOBAL_ATTRIBUTE1
,      INV_GLOBAL_ATTRIBUTE2
,      INV_GLOBAL_ATTRIBUTE3
,      INV_GLOBAL_ATTRIBUTE4
,      INV_GLOBAL_ATTRIBUTE5
,      INV_GLOBAL_ATTRIBUTE6
,      INV_GLOBAL_ATTRIBUTE7
,      INV_GLOBAL_ATTRIBUTE8
,      INV_GLOBAL_ATTRIBUTE9
,      INV_GLOBAL_ATTRIBUTE10
,      INV_GLOBAL_ATTRIBUTE11
,      INV_GLOBAL_ATTRIBUTE12
,      INV_GLOBAL_ATTRIBUTE13
,      INV_GLOBAL_ATTRIBUTE14
,      INV_GLOBAL_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE16
,      INV_GLOBAL_ATTRIBUTE17
,      INV_GLOBAL_ATTRIBUTE18
,      INV_GLOBAL_ATTRIBUTE19
,      INV_GLOBAL_ATTRIBUTE20
,      BANK_CHARGE_BEARER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      UNIQUE_REMITTANCE_IDENTIFIER
,      URI_CHECK_DIGIT
,      DELIVERY_CHANNEL_CODE
,      SETTLEMENT_PRIORITY
,      EXTERNAL_BANK_ACCOUNT_ID
,      PAYMENT_METHOD_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PAYMENT_MEAN
,      PAYMENT_CHANNEL
,      COUNTRY
,      PAYMENT_PROCESS_REQUEST_NAME
,      BANK_ACCOUNT_ID
,      VENDOR_BANK_ACCOUNT_ID
,      PAYMENT_REFERENCE_NUMBER
,      CHECK_NUMBER
,      AMOUNT_WITHHELD
,      CALLING_APP_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
,      DOCUMENT_SEQUENCE_ID
,      DOCUMENT_SEQUENCE_VALUE
,      DOCUMENT_CATEGORY_CODE
FROM APPS.ECE_PYO_INVOICE_V;

Dependencies

[top of page]

APPS.ECE_PYO_INVOICE_V references the following:

SchemaAPPS
TableIBY_PYO_INVOICE_GT

APPS.ECE_PYO_INVOICE_V is not referenced by any database object