[Home] [Help] [Dependency Information]
Object Name: | AR_OEX_INVOICE_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_OEX_INVOICE_VIEW |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
TRX_NUMBER | VARCHAR2 | (30) | ||
TRX_DATE | DATE | |||
TERMS_SEQUENCE_NUMBER | NUMBER | (15) | ||
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_TRX_ID | NUMBER | (15) | ||
CLASS | VARCHAR2 | (20) | Yes | |
STATUS | VARCHAR2 | (30) | Yes | |
CT_PURCHASE_ORDER | VARCHAR2 | (50) | ||
CT_PREVIOUS_CUSTOMER_TRX_ID | NUMBER | (15) | ||
DUE_DATE | DATE | Yes | ||
AMOUNT_DUE_ORIGINAL | NUMBER | Yes | ||
AMOUNT_DUE_REMAINING | NUMBER | Yes | ||
AL_CLASS_MEANING | VARCHAR2 | (80) | Yes | |
AL_STATUS_MEANING | VARCHAR2 | (80) | Yes | |
INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) | ||
BILL_TO_PARTY_ID | VARCHAR2 | (150) | ||
BILL_TO_SITE_USE_ID | VARCHAR2 | (150) | ||
BILLING_INTERFACE_REQUEST_ID | VARCHAR2 | (150) | ||
BILLING_PERIOD | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, TRX_NUMBER
, TRX_DATE
, TERMS_SEQUENCE_NUMBER
, INVOICE_CURRENCY_CODE
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, CUSTOMER_TRX_ID
, CLASS
, STATUS
, CT_PURCHASE_ORDER
, CT_PREVIOUS_CUSTOMER_TRX_ID
, DUE_DATE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, AL_CLASS_MEANING
, AL_STATUS_MEANING
, INTERFACE_HEADER_CONTEXT
, BILL_TO_PARTY_ID
, BILL_TO_SITE_USE_ID
, BILLING_INTERFACE_REQUEST_ID
, BILLING_PERIOD
FROM APPS.AR_OEX_INVOICE_VIEW;
APPS.AR_OEX_INVOICE_VIEW is not referenced by any database object
|
|
|