[Home] [Help] [Dependency Information]
Object Name: | WIP_RES_INST_EQUIPMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_RES_INST_EQUIPMENTS_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 |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Yes | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Yes | |
ORGANIZATION_ID | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | Yes | ||
RESOURCE_CODE | VARCHAR2 | (10) | Yes | |
INSTANCE_ID | NUMBER | |||
INSTANCE_NAME | VARCHAR2 | (40) | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Yes | |
CAPACITY_UNITS | NUMBER | |||
RESOURCE_GROUP_NAME | VARCHAR2 | (30) | ||
CTP_FLAG | NUMBER | |||
EXCEPTION_SET_NAME | VARCHAR2 | (10) | ||
ATP_RULE_ID | NUMBER | |||
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | ||
SHARE_FROM_DEPARTMENT | VARCHAR2 | (10) | ||
COST_ELEMENT_ID | NUMBER | Yes | ||
PURCHASE_ITEM_ID | NUMBER | |||
COST_CODE_TYPE | NUMBER | Yes | ||
FUNCTIONAL_CURRENCY_FLAG | NUMBER | Yes | ||
UNIT_OF_MEASURE | VARCHAR2 | (3) | ||
DEFAULT_ACTIVITY_ID | NUMBER | |||
AUTOCHARGE_TYPE | NUMBER | |||
STANDARD_RATE_FLAG | NUMBER | |||
DEFAULT_BASIS_TYPE | NUMBER | |||
ABSORPTION_ACCOUNT | NUMBER | |||
ALLOW_COSTS_FLAG | NUMBER | Yes | ||
RATE_VARIANCE_ACCOUNT | NUMBER | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
RESOURCE_TYPE | VARCHAR2 | (80) | Yes | |
AVAILABLE_24_HRS_FLAG | VARCHAR2 | (80) | Yes | |
BASIS_TYPE | VARCHAR2 | (80) | Yes | |
NODE_LABEL | VARCHAR2 | (71) |
Cut, paste (and edit) the following text to query this object:
SELECT DEPARTMENT_ID
, DEPARTMENT_CODE
, ORGANIZATION_ID
, RESOURCE_ID
, RESOURCE_CODE
, INSTANCE_ID
, INSTANCE_NAME
, SERIAL_NUMBER
, CAPACITY_UNITS
, RESOURCE_GROUP_NAME
, CTP_FLAG
, EXCEPTION_SET_NAME
, ATP_RULE_ID
, RESOURCE_DESCRIPTION
, SHARE_FROM_DEPARTMENT
, COST_ELEMENT_ID
, PURCHASE_ITEM_ID
, COST_CODE_TYPE
, FUNCTIONAL_CURRENCY_FLAG
, UNIT_OF_MEASURE
, DEFAULT_ACTIVITY_ID
, AUTOCHARGE_TYPE
, STANDARD_RATE_FLAG
, DEFAULT_BASIS_TYPE
, ABSORPTION_ACCOUNT
, ALLOW_COSTS_FLAG
, RATE_VARIANCE_ACCOUNT
, EXPENDITURE_TYPE
, RESOURCE_TYPE
, AVAILABLE_24_HRS_FLAG
, BASIS_TYPE
, NODE_LABEL
FROM APPS.WIP_RES_INST_EQUIPMENTS_V;
APPS.WIP_RES_INST_EQUIPMENTS_V is not referenced by any database object
|
|
|