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


VIEW: APPS.ICX_AP_INVOICES_V

Object Details
Object Name: ICX_AP_INVOICES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_AP_INVOICES_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
PO_NUMBER VARCHAR2 (20)

DESCRIPTION VARCHAR2 (240)

INVOICE_AMOUNT VARCHAR2 (4000)

INVOICE_CURRENCY_CODE VARCHAR2 (15) Yes
WITHHELD_AMOUNT_CURRENCY_CODE VARCHAR2 (56)

INVOICE_DATE DATE


INVOICE_ID NUMBER (15) Yes
INVOICE_NUM VARCHAR2 (50) Yes
DUE_DATE DATE


GROSS_AMOUNT VARCHAR2 (4000)

AMOUNT_REMAINING VARCHAR2 (4000)

DISCOUNT_DATE DATE


DISCOUNT_AMOUNT_AVAILABLE VARCHAR2 (4000)

INVOICE_TYPE VARCHAR2 (80)
Invoice Type
PAYMENT_STATUS VARCHAR2 (80)
Payment Status
PAYMENT_NUMBER VARCHAR2 (4000)
Comma delimited list of payment numbers matched to this invoice
VENDOR_SITE_CODE VARCHAR2 (15)

VENDOR_SITE_ID NUMBER (15)

VENDOR_ID NUMBER (15)

EMPLOYEE_ID NUMBER

Employee unique identifier if the supplier is an employee
Query Text

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


SELECT PO_NUMBER
,      DESCRIPTION
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      WITHHELD_AMOUNT_CURRENCY_CODE
,      INVOICE_DATE
,      INVOICE_ID
,      INVOICE_NUM
,      DUE_DATE
,      GROSS_AMOUNT
,      AMOUNT_REMAINING
,      DISCOUNT_DATE
,      DISCOUNT_AMOUNT_AVAILABLE
,      INVOICE_TYPE
,      PAYMENT_STATUS
,      PAYMENT_NUMBER
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      VENDOR_ID
,      EMPLOYEE_ID
FROM APPS.ICX_AP_INVOICES_V;

Dependencies

[top of page]

APPS.ICX_AP_INVOICES_V references the following:

SchemaAPPS
SynonymAP_INVOICES
SynonymAP_INVOICE_DISTRIBUTIONS
ViewAP_LOOKUP_CODES
SynonymAP_PAYMENT_SCHEDULES
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageICX_AP_INVOICES_PKG - show dependent code
PL/SQL PackageICX_AP_INVOICE_PAYMENTS_PKG - show dependent code
ViewPO_DISTRIBUTIONS_AP_V
SynonymPO_HEADERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES
APPS.ICX_AP_INVOICES_V is referenced by following:

SchemaAPPS
ViewICX_PO_MATCHED_INVOICES_V