DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CSL_MTL_EXPENSE_LABOR_ITEMS_V

Object Details
Object Name: CSL_MTL_EXPENSE_LABOR_ITEMS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


no comments


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes No Comments
ORGANIZATION_ID NUMBER
Yes No Comments
ENABLED_FLAG VARCHAR2 (1) Yes No Comments
START_DATE_ACTIVE DATE

No Comments
END_DATE_ACTIVE DATE

No Comments
PRIMARY_UOM_CODE VARCHAR2 (3)
No Comments
SERVICE_ITEM_FLAG VARCHAR2 (1) Yes No Comments
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1) Yes No Comments
MATERIAL_BILLABLE_FLAG VARCHAR2 (30)
No Comments
RETURNABLE_FLAG VARCHAR2 (1)
No Comments
LIST_PRICE_PER_UNIT NUMBER

No Comments
MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2 (1) Yes No Comments
CONCATENATED_SEGMENTS VARCHAR2 (40)
No Comments
SERIAL_NUMBER_CONTROL_CODE NUMBER

No Comments
LOT_CONTROL_CODE NUMBER

No Comments
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes No Comments
PURCHASING_ENABLED_FLAG VARCHAR2 (1) Yes No Comments
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes No Comments
INTERNAL_ORDER_FLAG VARCHAR2 (1) Yes No Comments
PURCHASING_ITEM_FLAG VARCHAR2 (1) Yes No Comments
COMMS_NL_TRACKABLE_FLAG VARCHAR2 (1)
No Comments
SERV_REQ_ENABLED_CODE VARCHAR2 (30)
No Comments
DESCRIPTION VARCHAR2 (240)
No Comments
LANGUAGE VARCHAR2 (4) Yes No Comments
ATTRIBUTE1 VARCHAR2 (240)
No Comments
ATTRIBUTE2 VARCHAR2 (240)
No Comments
ATTRIBUTE3 VARCHAR2 (240)
No Comments
ATTRIBUTE4 VARCHAR2 (240)
No Comments
ATTRIBUTE5 VARCHAR2 (240)
No Comments
ATTRIBUTE6 VARCHAR2 (240)
No Comments
ATTRIBUTE7 VARCHAR2 (240)
No Comments
ATTRIBUTE8 VARCHAR2 (240)
No Comments
ATTRIBUTE9 VARCHAR2 (240)
No Comments
ATTRIBUTE10 VARCHAR2 (240)
No Comments
ATTRIBUTE11 VARCHAR2 (240)
No Comments
ATTRIBUTE12 VARCHAR2 (240)
No Comments
ATTRIBUTE13 VARCHAR2 (240)
No Comments
ATTRIBUTE14 VARCHAR2 (240)
No Comments
ATTRIBUTE15 VARCHAR2 (240)
No Comments
ATTRIBUTE_CATEGORY VARCHAR2 (30)
No Comments
ACCESS_ID NUMBER

No Comments
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PRIMARY_UOM_CODE
,      SERVICE_ITEM_FLAG
,      SERVICEABLE_PRODUCT_FLAG
,      MATERIAL_BILLABLE_FLAG
,      RETURNABLE_FLAG
,      LIST_PRICE_PER_UNIT
,      MTL_TRANSACTIONS_ENABLED_FLAG
,      CONCATENATED_SEGMENTS
,      SERIAL_NUMBER_CONTROL_CODE
,      LOT_CONTROL_CODE
,      INVENTORY_ASSET_FLAG
,      PURCHASING_ENABLED_FLAG
,      INTERNAL_ORDER_ENABLED_FLAG
,      INTERNAL_ORDER_FLAG
,      PURCHASING_ITEM_FLAG
,      COMMS_NL_TRACKABLE_FLAG
,      SERV_REQ_ENABLED_CODE
,      DESCRIPTION
,      LANGUAGE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ACCESS_ID
FROM APPS.CSL_MTL_EXPENSE_LABOR_ITEMS_V;

Dependencies

[top of page]

APPS.CSL_MTL_EXPENSE_LABOR_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCS_BILLING_TYPE_CATEGORIES
SynonymJTM_MTL_SYSTEM_ITEMS_ACC
SynonymMTL_SYSTEM_ITEMS_B
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_SYSTEM_ITEMS_TL

APPS.CSL_MTL_EXPENSE_LABOR_ITEMS_V is not referenced by any database object