Skip to content

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

VIEW: APPS.IEX_WRITTENOFF_INVOICES_V2

Object Details
Object Name: IEX_WRITTENOFF_INVOICES_V2
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
WRITEOFF_ID NUMBER
Yes
CUSTOMER_TRX_ID NUMBER

CUSTOMER_TRX_LINE_ID NUMBER

INVOICE_NUMBER VARCHAR2 (90)
INVOICE_AMOUNT NUMBER

LINE_NUMBER NUMBER

CURRENCY_CODE VARCHAR2 (15)
RECEVIABLES_ADJUSTMENT_ID NUMBER

APPROVAL_TYPE VARCHAR2 (80) Yes
WRITEOFF_OBJECT_ID NUMBER
Yes
LINE_AMOUNT NUMBER

AMOUNT_APPLIED NUMBER

AMOUNT_REMAINING NUMBER

ADJUSTMENT_AMOUNT NUMBER
Yes
ADJUST_REASON VARCHAR2 (80) Yes
REQUEST_ID NUMBER (15)
WRITEOFF_TYPE VARCHAR2 (50)
WRITEOFF_TYPE_ID NUMBER

WRITEOFF_STATUS VARCHAR2 (15)
Query Text

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


SELECT WRITEOFF_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      INVOICE_NUMBER
,      INVOICE_AMOUNT
,      LINE_NUMBER
,      CURRENCY_CODE
,      RECEVIABLES_ADJUSTMENT_ID
,      APPROVAL_TYPE
,      WRITEOFF_OBJECT_ID
,      LINE_AMOUNT
,      AMOUNT_APPLIED
,      AMOUNT_REMAINING
,      ADJUSTMENT_AMOUNT
,      ADJUST_REASON
,      REQUEST_ID
,      WRITEOFF_TYPE
,      WRITEOFF_TYPE_ID
,      WRITEOFF_STATUS
FROM APPS.IEX_WRITTENOFF_INVOICES_V2;

Dependencies

[top of page]

APPS.IEX_WRITTENOFF_INVOICES_V2 references the following:

SchemaAPPS
ViewAR_LOOKUPS
ViewIEX_CS_BILLINGTRX_UV1
PL/SQL PackageIEX_UTILITIES - show dependent code
SynonymIEX_WRITEOFF_OBJECTS
PL/SQL PackageOKL_BILLING_UTIL_PVT - show dependent code
PL/SQL PackageOKL_CS_LC_CONTRACT_PVT - show dependent code

APPS.IEX_WRITTENOFF_INVOICES_V2 is not referenced by any database object