[Home] [Help] [Dependency Information]
Object Name: | OKE_DTS_RECEIVABLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 |
---|---|---|---|---|
K_HEADER_ID | NUMBER | Yes | Contract document unique identifier | |
K_LINE_ID | NUMBER | Contract line unique identifer related to billing event | ||
DELIVERABLE_ID | NUMBER | Yes | Contract deliverable unique identifier | |
PROJECT_ID | NUMBER | (15) | Yes | Project unique identifier |
TASK_ID | NUMBER | (15) | Task unique identifier | |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | Project number |
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
EVENT_NUM | NUMBER | (15) | Yes | Event number |
DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | Draft invoice number |
DRAFT_INVOICE_LINE | NUMBER | (15) | Yes | Draft invoice line |
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Custermer transaction unique identifier |
INVOICE_NUM | VARCHAR2 | (20) | Yes | Invoice number |
INVOICE_DATE | DATE | Yes | Invoice date | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Invoice currency code | |
PAYMENT_TERM | VARCHAR2 | (15) | Yes | Payment term |
INVOICE_AMOUNT_DUE_ORIGINAL | NUMBER | Invoice amount due original | ||
INVOICE_AMOUNT_DUE_REMAINING | NUMBER | Invoice amount due remaining | ||
INVOICE_AMOUNT_APPLIED | NUMBER | Invoice amount applier | ||
INVOICE_AMOUNT_CREDITED | NUMBER | Invoice amount credited | ||
INVOICE_AMOUNT_ADJUSTED | NUMBER | Invoice amount adjusted | ||
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Customer transaction line unique identifier |
INVOICE_LINE | NUMBER | Yes | Invoice line number | |
INVOICE_LINE_AMOUNT | NUMBER | Yes | Invoice line amount | |
DESCRIPTION | VARCHAR2 | (240) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT K_HEADER_ID
, K_LINE_ID
, DELIVERABLE_ID
, PROJECT_ID
, TASK_ID
, PROJECT_NUMBER
, TASK_NUMBER
, EVENT_NUM
, DRAFT_INVOICE_NUM
, DRAFT_INVOICE_LINE
, CUSTOMER_TRX_ID
, INVOICE_NUM
, INVOICE_DATE
, INVOICE_CURRENCY_CODE
, PAYMENT_TERM
, INVOICE_AMOUNT_DUE_ORIGINAL
, INVOICE_AMOUNT_DUE_REMAINING
, INVOICE_AMOUNT_APPLIED
, INVOICE_AMOUNT_CREDITED
, INVOICE_AMOUNT_ADJUSTED
, CUSTOMER_TRX_LINE_ID
, INVOICE_LINE
, INVOICE_LINE_AMOUNT
, DESCRIPTION
FROM APPS.OKE_DTS_RECEIVABLES_V;
APPS.OKE_DTS_RECEIVABLES_V is not referenced by any database object
|
|
|