[Home] [Help] [Dependency Information]
Object Name: | OKL_RCPT_ARINV_BALANCES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_RCPT_ARINV_BALANCES_UV |
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 |
---|---|---|---|---|
INVOICE_NUMBER | VARCHAR2 | (20) | Yes | Invoice Number |
AR_INVOICE_ID | NUMBER | (15) | Yes | AR Invoice transaction Id |
INVOICE_LINE_ID | NUMBER | (15) | Yes | Invoice Line Id |
INVOICE_DATE | DATE | Yes | Invoice Date | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Invoice Currency Code | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Customer Name |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | Customer Number |
CUSTOMER_ACCT_ID | NUMBER | (15) | Yes | Customer Account Id |
CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Customer Account Number |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill To Site Address Id | |
KHR_ID | NUMBER | Contract Id | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
START_DATE | DATE | Contract Start Date | ||
ASSET_NUMBER | VARCHAR2 | (150) | Asset Number | |
STREAM_TYPE | VARCHAR2 | (150) | Stream Type | |
LINE_IDENTIFIER | NUMBER | Yes | Invoice Line Identifier | |
STY_ID | NUMBER | Stream Type Id | ||
KLE_ID | NUMBER | Contract Line Id | ||
SEL_ID | NUMBER | Stream element Id | ||
AMOUNT_DUE_ORIGINAL | NUMBER | Original amount due on a invoice | ||
AMOUNT_DUE_REMAINING | NUMBER | Remaining amount due on a invoice | ||
INVOICE_DUE_DATE | DATE | Yes | Invoice due date | |
TRX_DATE | DATE | Transaction date | ||
STATUS | VARCHAR2 | (30) | Yes | Status |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_NUMBER
, AR_INVOICE_ID
, INVOICE_LINE_ID
, INVOICE_DATE
, INVOICE_CURRENCY_CODE
, ORG_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_ACCT_ID
, CUSTOMER_ACCOUNT_NUMBER
, BILL_TO_SITE_USE_ID
, KHR_ID
, CONTRACT_NUMBER
, START_DATE
, ASSET_NUMBER
, STREAM_TYPE
, LINE_IDENTIFIER
, STY_ID
, KLE_ID
, SEL_ID
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, INVOICE_DUE_DATE
, TRX_DATE
, STATUS
FROM APPS.OKL_RCPT_ARINV_BALANCES_UV;
|
|
|