[Home] [Help] [Dependency Information]
Object Name: | CSL_SR_CONTRACT_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Mobile view on CSL_SR_CONTRACT_HEADERS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Yes | Indentifier to CSL_SR_CONTRACT_HEADERS_ACC | |
INCIDENT_ID | NUMBER | Yes | Indentifier to CS_INCIDENTS_ALL_B | |
CONTRACT_SERVICE_ID | NUMBER | Yes | Indentifier to OKC_K_LINES_B.ID | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract (RFP,Proposal etc.) Legal Identifier. | |
SERVICE_NAME | VARCHAR2 | (150) | Item name | |
SERVICE_DESCRIPTION | VARCHAR2 | (2000) | This column contains Item translated description | |
AMOUNT_UOM_CODE | VARCHAR2 | (30) | Currency code as defined in FND_CURRENCIES. |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, INCIDENT_ID
, CONTRACT_SERVICE_ID
, CONTRACT_NUMBER
, SERVICE_NAME
, SERVICE_DESCRIPTION
, AMOUNT_UOM_CODE
FROM APPS.CSL_SR_CONTRACT_HEADERS_V;
APPS.CSL_SR_CONTRACT_HEADERS_V is not referenced by any database object
|
|
|