[Home] [Help] [Dependency Information]
Object Name: | OKL_RCPT_CONSINV_BALANCES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_RCPT_CONSINV_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 |
---|---|---|---|---|
CONSOLIDATED_INVOICE_NUMBER | VARCHAR2 | (90) | Pre R12 OKL Consolidated Invoice Number | |
CONSOLIDATED_INVOICE_ID | NUMBER | Yes | Consolidated Invoice Id | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
INVOICE_DATE | DATE | Yes | Invoice Date | |
LINE_NUMBER | NUMBER | (5) | Yes | Invoice Line Number |
AR_INVOICE_NUMBER | VARCHAR2 | (20) | Yes | Invoice Number |
AR_INVOICE_ID | NUMBER | (15) | Yes | Invoice Id |
ORG_ID | NUMBER | (15) | Organization Id | |
AR_INVOICE_LINE_ID | NUMBER | (15) | Yes | Invoice Line Id |
AR_INVOICE_LINE_NUMBER | NUMBER | Yes | Invoice Line Number | |
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 | |
CONTRACT_ID | NUMBER | Contract Id | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Yes | Contract Number |
CONTRACT_START_DATE | DATE | Contract Start Date | ||
ASSET_NUMBER | VARCHAR2 | (150) | Asset Number | |
STREAM_TYPE | VARCHAR2 | (150) | Stream Type | |
STREAM_TYPE_ID | NUMBER | Yes | Stream Type Id | |
CONTRACT_LINE_ID | NUMBER | Contract Line Id | ||
STREAM_ELEMENT_ID | NUMBER | Stream Element Id | ||
AMOUNT_DUE_ORIGINAL | NUMBER | Yes | Original amount due on an invoice | |
AMOUNT_DUE_REMAINING | NUMBER | Yes | Remaining amount due on an invoice | |
TAX_DUE_ORIGINAL | NUMBER | Original tax due on an invoice | ||
TAX_DUE_REMAINING | NUMBER | Remaining tax due on an invoice | ||
DUE_DATE | DATE | Yes | Invoice Due Date | |
TRX_DATE | DATE | Invoice Transaction Date | ||
STATUS | VARCHAR2 | (30) | Yes | Status |
Cut, paste (and edit) the following text to query this object:
SELECT CONSOLIDATED_INVOICE_NUMBER
, CONSOLIDATED_INVOICE_ID
, CURRENCY_CODE
, INVOICE_DATE
, LINE_NUMBER
, AR_INVOICE_NUMBER
, AR_INVOICE_ID
, ORG_ID
, AR_INVOICE_LINE_ID
, AR_INVOICE_LINE_NUMBER
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_ACCT_ID
, CUSTOMER_ACCOUNT_NUMBER
, BILL_TO_SITE_USE_ID
, CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_START_DATE
, ASSET_NUMBER
, STREAM_TYPE
, STREAM_TYPE_ID
, CONTRACT_LINE_ID
, STREAM_ELEMENT_ID
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, TAX_DUE_ORIGINAL
, TAX_DUE_REMAINING
, DUE_DATE
, TRX_DATE
, STATUS
FROM APPS.OKL_RCPT_CONSINV_BALANCES_UV;
|
|
|