[Home] [Help] [Dependency Information]
Object Name: | CSF_DEBRIEF_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSF.CSF_DEBRIEF_HEADERS_V |
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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
DEBRIEF_HEADER_ID | NUMBER | Yes | The unique identifier for the field service report header | |
DEBRIEF_NUMBER | VARCHAR2 | (50) | Yes | The unique number for the field service report |
DEBRIEF_DATE | DATE | Yes | Field service report date | |
DEBRIEF_STATUS_ID | NUMBER | Field service report status identifier | ||
TASK_ID | NUMBER | Yes | ||
TASK_ASSIGNMENT_ID | NUMBER | Yes | Task assignment identifier | |
PROCESSED_FLAG | VARCHAR2 | (40) | Debrief Status while being processed | |
SCHEDULED_START_DATE | DATE | Scheduled Start Date | ||
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 1 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 2 | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 3 | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 4 | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 5 | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 6 | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 7 | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 8 | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 9 | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 10 | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 11 | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 12 | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 13 | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 14 | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment for attribute 15 | |
TASK_NUMBER | VARCHAR2 | (30) | Yes | Task number |
TASK_SOURCE | VARCHAR2 | (30) | Task source | |
TASK_NAME | VARCHAR2 | (80) | Yes | Task name |
TASK_DESCRIPTION | VARCHAR2 | (4000) | Task description | |
TASK_STATUS | VARCHAR2 | (30) | Yes | Task status |
TASK_ASSIGNMENT_STATUS | VARCHAR2 | (30) | Yes | Task assignment status |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer number | |
ADDRESS | VARCHAR2 | (966) | Address | |
CITY_STATE_ZIP | VARCHAR2 | (185) | City zip code | |
RESOURCE_ID | NUMBER | Yes | Unique id for the engineer | |
RESOURCE_NAME | VARCHAR2 | (4000) | Resource name | |
RESOURCE_TYPE | VARCHAR2 | (30) | Yes | Resource type |
SOURCE_NUMBER | VARCHAR2 | (64) | Source number | |
INCIDENT_ID | NUMBER | (15) | Incident identifier | |
SOURCE_DATE | DATE | Source date | ||
PO_NUMBER | VARCHAR2 | (50) | Purchase order number | |
PRODUCT_NAME | VARCHAR2 | (40) | Product name | |
PRODUCT_ID | NUMBER | Product identifier | ||
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Product description | |
SOURCE_OBJECT_ID | NUMBER | Source object identifier | ||
CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
CUST_ACCOUNT_ID | NUMBER | Customer account identifier | ||
ORGANIZATION_ID | NUMBER | Organziation Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, DEBRIEF_HEADER_ID
, DEBRIEF_NUMBER
, DEBRIEF_DATE
, DEBRIEF_STATUS_ID
, TASK_ID
, TASK_ASSIGNMENT_ID
, PROCESSED_FLAG
, SCHEDULED_START_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TASK_NUMBER
, TASK_SOURCE
, TASK_NAME
, TASK_DESCRIPTION
, TASK_STATUS
, TASK_ASSIGNMENT_STATUS
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, ADDRESS
, CITY_STATE_ZIP
, RESOURCE_ID
, RESOURCE_NAME
, RESOURCE_TYPE
, SOURCE_NUMBER
, INCIDENT_ID
, SOURCE_DATE
, PO_NUMBER
, PRODUCT_NAME
, PRODUCT_ID
, PRODUCT_DESCRIPTION
, SOURCE_OBJECT_ID
, CUSTOMER_ID
, CUST_ACCOUNT_ID
, ORGANIZATION_ID
FROM APPS.CSF_DEBRIEF_HEADERS_V;
|
|
|