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

TABLE: MSC.MSC_PART_DEMANDS

Object Details
Object Name: MSC_PART_DEMANDS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_PART_DEMANDS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DESIGNATOR_TYPE NUMBER

ITEM_TYPE_VALUE NUMBER

DISPOSITION_ID NUMBER

FINAL_USE_DATE DATE

REQUEST_DATE DATE

USING_ASSEMBLY_ITEM_ID NUMBER
Yes
ORIG_DEMAND_ID NUMBER
Yes
DEMAND_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
QUANTITY NUMBER

ORIGINATION_TYPE NUMBER

DEMAND_TYPE NUMBER
Yes
PLAN_ID NUMBER
Yes
IMPLEMENT_DATE DATE

IMPLEMENT_EARLIEST_DATE DATE

IMPLEMENT_FIRM NUMBER

IMPLEMENT_INSTANCE_ID NUMBER

IMPLEMENT_ORG_ID NUMBER

IMPLEMENT_SHIP_DATE DATE

Query Text

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


SELECT DESIGNATOR_TYPE
,      ITEM_TYPE_VALUE
,      DISPOSITION_ID
,      FINAL_USE_DATE
,      REQUEST_DATE
,      USING_ASSEMBLY_ITEM_ID
,      ORIG_DEMAND_ID
,      DEMAND_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      ORIGINATION_TYPE
,      DEMAND_TYPE
,      PLAN_ID
,      IMPLEMENT_DATE
,      IMPLEMENT_EARLIEST_DATE
,      IMPLEMENT_FIRM
,      IMPLEMENT_INSTANCE_ID
,      IMPLEMENT_ORG_ID
,      IMPLEMENT_SHIP_DATE
FROM MSC.MSC_PART_DEMANDS;

Dependencies

[top of page]

MSC.MSC_PART_DEMANDS does not reference any database object

MSC.MSC_PART_DEMANDS is referenced by following:

SchemaMSC
ViewMSC_PART_DEMANDS#