[Home] [Help] [Dependency Information]
Object Name: | OKS_CON_BILL_INT_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILL_LINE_ID | NUMBER | Yes | Bill Line Id | |
CONTRACT_LINE_ID | NUMBER | Yes | Contract Line Id | |
SEQUENCE_NO | NUMBER | Sequence No | ||
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
LEVEL_PERIODS | NUMBER | Level Periods | ||
UOM_PER_PERIOD | NUMBER | Uom Per Period | ||
UOM_CODE | VARCHAR2 | (3) | Uom Code | |
LEVEL_AMOUNT | NUMBER | Level Amount | ||
AMOUNT | NUMBER | Amount | ||
ADVANCE_PERIODS | NUMBER | Advance Periods | ||
INVOICE_OFFSET_DAYS | NUMBER | Invoice Offset Days | ||
INTERFACE_OFFSET_DAYS | NUMBER | Interface Offset Days | ||
COMMENTS | VARCHAR2 | (2000) | Comments | |
DUE_ARR_YN | VARCHAR2 | (1) | Due Arr Yn | |
LINES_DETAILED_YN | VARCHAR2 | (1) | Lines Detailed Yn | |
REQUEST_ID | NUMBER | Unique Identifier of a concurrent request. | ||
CREATED_BY | NUMBER | Yes | ID of the user whom created the record. | |
CREATION_DATE | DATE | Yes | Date the record was created. | |
LAST_UPDATED_BY | NUMBER | Yes | ID of the last user who updated the record. | |
LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated. | |
LAST_UPDATE_LOGIN | NUMBER | OS ID of the user who last updated the record. | ||
INTERFACED_STATUS_FLAG | VARCHAR2 | (1) | Interfaced Status Flag |
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;
OKS.OKS_CON_BILL_INT_ALL does not reference any database object
OKS.OKS_CON_BILL_INT_ALL is referenced by following:
|
|
|