[Home] [Help] [Dependency Information]
Object Name: | IEX_WRITEOFF_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | |
CONTRACT_ID | NUMBER | |||
CONS_INV_ID | NUMBER | |||
CONSOLIDATED_INVOICE_NUMBER | VARCHAR2 | (90) | ||
INVOICE_LINE_ID | NUMBER | |||
PAYMENT_SCHEDULE_ID | NUMBER | (15) | ||
TRANSACTION_ID | NUMBER | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
TRANSACTION_AMOUNT | NUMBER | Yes | ||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_REMAINING | NUMBER | Yes | ||
CASE_ID | NUMBER | Yes | ||
DELINQUENCY_ID | NUMBER | Yes | ||
RECEVIABLES_ADJUSTMENT_ID | NUMBER | |||
ADJUSTMENT_STATUS | VARCHAR2 | (80) | Yes | |
WRITEOFF_OBJECT_ID | NUMBER | Yes | ||
WRITEOFF_ID | NUMBER | Yes | ||
ADJUSTMENT_AMOUNT | NUMBER | Yes | ||
ADJUSTMENT_REASON | VARCHAR2 | (80) | Yes | |
REQUEST_ID | NUMBER | (15) | ||
WRITEOFF_TYPE | VARCHAR2 | (50) | ||
WRITEOFF_TYPE_ID | NUMBER | |||
WRITEOFF_STATUS | VARCHAR2 | (15) | ||
TRANSACTION_TYPE | VARCHAR2 | (150) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NUMBER
, CONTRACT_ID
, CONS_INV_ID
, CONSOLIDATED_INVOICE_NUMBER
, INVOICE_LINE_ID
, PAYMENT_SCHEDULE_ID
, TRANSACTION_ID
, CURRENCY_CODE
, TRANSACTION_AMOUNT
, AMOUNT_APPLIED
, AMOUNT_REMAINING
, CASE_ID
, DELINQUENCY_ID
, RECEVIABLES_ADJUSTMENT_ID
, ADJUSTMENT_STATUS
, WRITEOFF_OBJECT_ID
, WRITEOFF_ID
, ADJUSTMENT_AMOUNT
, ADJUSTMENT_REASON
, REQUEST_ID
, WRITEOFF_TYPE
, WRITEOFF_TYPE_ID
, WRITEOFF_STATUS
, TRANSACTION_TYPE
FROM APPS.IEX_WRITEOFF_INVOICES_V;
APPS.IEX_WRITEOFF_INVOICES_V is not referenced by any database object
|
|
|