[Home] [Help] [Dependency Information]
Object Name: | OKS_CON_BILL_INT_ALL# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILL_LINE_ID | NUMBER | Yes | ||
CONTRACT_LINE_ID | NUMBER | Yes | ||
SEQUENCE_NO | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
LEVEL_PERIODS | NUMBER | |||
UOM_PER_PERIOD | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
LEVEL_AMOUNT | NUMBER | |||
AMOUNT | NUMBER | |||
ADVANCE_PERIODS | NUMBER | |||
INVOICE_OFFSET_DAYS | NUMBER | |||
INTERFACE_OFFSET_DAYS | NUMBER | |||
COMMENTS | VARCHAR2 | (2000) | ||
DUE_ARR_YN | VARCHAR2 | (1) | ||
LINES_DETAILED_YN | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
INTERFACED_STATUS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT BILL_LINE_ID
, CONTRACT_LINE_ID
, SEQUENCE_NO
, START_DATE
, END_DATE
, LEVEL_PERIODS
, UOM_PER_PERIOD
, UOM_CODE
, LEVEL_AMOUNT
, AMOUNT
, ADVANCE_PERIODS
, INVOICE_OFFSET_DAYS
, INTERFACE_OFFSET_DAYS
, COMMENTS
, DUE_ARR_YN
, LINES_DETAILED_YN
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, INTERFACED_STATUS_FLAG
FROM OKS.OKS_CON_BILL_INT_ALL#;
|
|
|