[Home] [Help] [Dependency Information]
Object Name: | CSF_M_DEBRIEF_LABOR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This view contains the information about the amount of time the resource or agent has worked on the task.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | The Unique Access Identifier | ||
DEBRIEF_LINE_ID | NUMBER | The unique line identifier for each field service report line | ||
INVENTORY_ITEM_ID | NUMBER | The inventory item identifier | ||
TXN_BILLING_TYPE_ID | NUMBER | The transaction billing type identifier | ||
TASK_ASSIGNMENT_ID | NUMBER | The Task Assignment Identifier | ||
RESOURCE_ID | NUMBER | The Resource or agent identifier | ||
LABOR_START_DATE | DATE | The Labor Start Date | ||
LABOR_END_DATE | DATE | The Labor End Date | ||
BUSINESS_PROCESS_ID | NUMBER | Business Process Identifier | ||
LAST_UPDATE_DATE | DATE | Standard WHO Information | ||
QUANTITY | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
SERVICE_DATE | DATE | |||
ITEM_NAME | VARCHAR2 | (4000) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
TRANSACTION_TYPE_ID | NUMBER | |||
LABOR_REASON_CODE | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
DEBRIEF_HEADER_ID | NUMBER | Header id | ||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
SERVER_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, DEBRIEF_LINE_ID
, INVENTORY_ITEM_ID
, TXN_BILLING_TYPE_ID
, TASK_ASSIGNMENT_ID
, RESOURCE_ID
, LABOR_START_DATE
, LABOR_END_DATE
, BUSINESS_PROCESS_ID
, LAST_UPDATE_DATE
, QUANTITY
, UOM_CODE
, SERVICE_DATE
, ITEM_NAME
, ITEM_DESCRIPTION
, TRANSACTION_TYPE_ID
, LABOR_REASON_CODE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, DEBRIEF_HEADER_ID
, CREATED_BY
, LAST_UPDATED_BY
, SERVER_LAST_UPDATE_DATE
FROM APPS.CSF_M_DEBRIEF_LABOR_V;
APPS.CSF_M_DEBRIEF_LABOR_V is not referenced by any database object
|
|
|