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

VIEW: APPS.MSC_PROCESS_EFFECTIVITY_V

Object Details
Object Name: MSC_PROCESS_EFFECTIVITY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_PROCESS_EFFECTIVITY_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
ORGANIZATION_CODE VARCHAR2 (7)
ITEM_ID NUMBER
Yes
ITEM_NAME VARCHAR2 (250)
PROCESS_SEQUENCE_ID NUMBER
Yes
EFFECTIVITY_DATE DATE
Yes
DISABLE_DATE DATE

MINIMUM_QUANTITY NUMBER

MAXIMUM_QUANTITY NUMBER

PREFERENCE NUMBER

ROUTING_SEQUENCE_ID NUMBER

ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (40)
BILL_SEQUENCE_ID NUMBER

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (40)
TOTAL_PRODUCT_CYCLE_TIME NUMBER

ITEM_PROCESS_COST NUMBER

LINE_ID NUMBER

LINE_CODE VARCHAR2 (10)
PRIMARY_LINE_FLAG NUMBER

PRODUCTION_LINE_RATE NUMBER

Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      ITEM_ID
,      ITEM_NAME
,      PROCESS_SEQUENCE_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      MINIMUM_QUANTITY
,      MAXIMUM_QUANTITY
,      PREFERENCE
,      ROUTING_SEQUENCE_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      BILL_SEQUENCE_ID
,      ALTERNATE_BOM_DESIGNATOR
,      TOTAL_PRODUCT_CYCLE_TIME
,      ITEM_PROCESS_COST
,      LINE_ID
,      LINE_CODE
,      PRIMARY_LINE_FLAG
,      PRODUCTION_LINE_RATE
FROM APPS.MSC_PROCESS_EFFECTIVITY_V;

Dependencies

[top of page]

APPS.MSC_PROCESS_EFFECTIVITY_V references the following:

SchemaAPPS
SynonymMSC_BOMS
SynonymMSC_DEPARTMENT_RESOURCES
SynonymMSC_PROCESS_EFFECTIVITY
SynonymMSC_ROUTINGS
SynonymMSC_SYSTEM_ITEMS

APPS.MSC_PROCESS_EFFECTIVITY_V is not referenced by any database object