[Home] [Help] [Dependency Information]
Object Name: | OKS_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKS.OKS_LINES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_ID | NUMBER | Yes | FK to Contract Header. | |
LINE_ID | NUMBER | Yes | Contract Line Identifier (Extended Warraty) | |
SERVICE_NAME | VARCHAR2 | (150) | Name of the Contract Line | |
SERVICE_START_DATE | DATE | Effective Start date of the contract line | ||
SERVICE_END_DATE | DATE | Effective End date of the contract line | ||
CUSTOMER_ACCOUNT_NAME | VARCHAR2 | (360) | Customer Account Name | |
BILL2_ADDRESS1 | VARCHAR2 | (240) | Bill To Address | |
BILL2_ADDRESS2 | VARCHAR2 | (240) | Bill To Address | |
BILL2_COUNTRY | VARCHAR2 | (60) | Bill To Country | |
SHIP2_ADDRESS1 | VARCHAR2 | (0) | Ship To Address | |
SHIP2_ADDRESS2 | VARCHAR2 | (0) | Ship To Address | |
SHIP2_COUNTRY | VARCHAR2 | (0) | Ship to Country |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_ID
, LINE_ID
, SERVICE_NAME
, SERVICE_START_DATE
, SERVICE_END_DATE
, CUSTOMER_ACCOUNT_NAME
, BILL2_ADDRESS1
, BILL2_ADDRESS2
, BILL2_COUNTRY
, SHIP2_ADDRESS1
, SHIP2_ADDRESS2
, SHIP2_COUNTRY
FROM APPS.OKS_LINES_V;
APPS.OKS_LINES_V is not referenced by any database object
|
|
|