[Home] [Help] [Dependency Information]
Object Name: | MSC_COMPONENTS_SC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSC.MSC_COMPONENTS_SC_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
COMPONENT_NUMBER | VARCHAR2 | (250) | ||
USING_ASSEMBLY_NUMBER | VARCHAR2 | (250) | ||
ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (4000) | ||
PLAN_ID | NUMBER | |||
CHANGE_NOTICE | VARCHAR2 | (10) | ||
USING_ASSEMBLY_ID | NUMBER | |||
OPERATION_SEQ_NUM | VARCHAR2 | (4000) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
REVISION | VARCHAR2 | (3) | ||
EFFECTIVITY_DATE | DATE | |||
SUGGESTED_EFFECTIVITY_DATE | DATE | |||
USE_UP_CODE | NUMBER | |||
USAGE_QUANTITY | NUMBER | |||
OPERATION_OFFSET_PERCENT | NUMBER | |||
PLANNING_FACTOR | NUMBER | |||
DRIVING_ITEM_ID | NUMBER | |||
OPTIONAL_COMPONENT | NUMBER | |||
DISABLE_DATE | DATE | |||
WIP_SUPPLY_TYPE | VARCHAR2 | (4000) | ||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (40) | ||
FROM_UNIT_NUMBER | VARCHAR2 | (30) | ||
TO_UNIT_NUMBER | VARCHAR2 | (30) | ||
SR_INSTANCE_ID | NUMBER | |||
COMPONENT_DESC | VARCHAR2 | (4000) | ||
USING_ASSEMBLY_DESC | VARCHAR2 | (240) | ||
UOM_CODE | VARCHAR2 | (3) | ||
DRIVING_ITEM_SEGMENTS | VARCHAR2 | (250) | ||
BILL_SEQUENCE_ID | NUMBER | |||
COMPONENT_SEQUENCE_ID | NUMBER | |||
SCALE_MULTIPLE | NUMBER | |||
SCALE_ROUNDING_VARIANCE | NUMBER | |||
ROUNDING_DIRECTION | NUMBER | |||
CATEGORY_ID | NUMBER | |||
CATEGORY_SET_ID | NUMBER | |||
ENFORCE_INT_REQ | VARCHAR2 | (80) | ||
SUBSTITUTE_COMP | NUMBER | |||
SCALE_TYPE | VARCHAR2 | (4000) | ||
CONTRIBUTING_TO_YIELD | VARCHAR2 | (4000) | ||
COMPONENT_YIELD_FACTOR | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, COMPONENT_NUMBER
, USING_ASSEMBLY_NUMBER
, ORGANIZATION_ID
, ORGANIZATION_CODE
, PLAN_ID
, CHANGE_NOTICE
, USING_ASSEMBLY_ID
, OPERATION_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, REVISION
, EFFECTIVITY_DATE
, SUGGESTED_EFFECTIVITY_DATE
, USE_UP_CODE
, USAGE_QUANTITY
, OPERATION_OFFSET_PERCENT
, PLANNING_FACTOR
, DRIVING_ITEM_ID
, OPTIONAL_COMPONENT
, DISABLE_DATE
, WIP_SUPPLY_TYPE
, ALTERNATE_BOM_DESIGNATOR
, FROM_UNIT_NUMBER
, TO_UNIT_NUMBER
, SR_INSTANCE_ID
, COMPONENT_DESC
, USING_ASSEMBLY_DESC
, UOM_CODE
, DRIVING_ITEM_SEGMENTS
, BILL_SEQUENCE_ID
, COMPONENT_SEQUENCE_ID
, SCALE_MULTIPLE
, SCALE_ROUNDING_VARIANCE
, ROUNDING_DIRECTION
, CATEGORY_ID
, CATEGORY_SET_ID
, ENFORCE_INT_REQ
, SUBSTITUTE_COMP
, SCALE_TYPE
, CONTRIBUTING_TO_YIELD
, COMPONENT_YIELD_FACTOR
FROM APPS.MSC_COMPONENTS_SC_V;
|
|
|