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 (0)
Payment Number
VENDOR_NUM VARCHAR2 (30)
Supplier Number
CUSTOMER_NUM VARCHAR2 (0)
Customer Number Supplier Uses for Your Company
INVOICE_NUM VARCHAR2 (50)
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 (0)
Discount Amount
PRINT_SELECTED_CHECK_ID VARCHAR2 (0)
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 (150)
Invoice Global Attribute Category
INV_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Invoice Global Attribute 1
INV_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Invoice Global Attribute 2
INV_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Invoice Global Attribute 3
INV_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Invoice Global Attribute 4
INV_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Invoice Global Attribute 5
INV_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Invoice Global Attribute 6
INV_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Invoice Global Attribute 7
INV_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Invoice Global Attribute 8
INV_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Invoice Global Attribute 9
INV_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Invoice Global Attribute 10
INV_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Invoice Global Attribute 11
INV_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Invoice Global Attribute 12
INV_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Invoice Global Attribute 13
INV_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Invoice Global Attribute 14
INV_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Invoice Global Attribute 15
INV_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Invoice Global Attribute 16
INV_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Invoice Global Attribute 17
INV_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Invoice Global Attribute 18
INV_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Invoice Global Attribute 19
INV_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
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)
PAYMENT METHOD CODE
VENDOR_ID NUMBER

Vendor ID
VENDOR_SITE_ID NUMBER

Vendor Site ID
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
FROM APPS.ECE_PYO_INVOICE_V;

Dependencies

[top of page]

APPS.ECE_PYO_INVOICE_V references the following:

SchemaAPPS
SynonymAP_INVOICES
SynonymAP_SUPPLIERS
SynonymAP_SUPPLIER_SITES
SynonymIBY_DOCS_PAYABLE_ALL
SynonymIBY_PAYMENTS_ALL

APPS.ECE_PYO_INVOICE_V is not referenced by any database object