[Home] [Help] [Dependency Information]
Object Name: | MSC_PART_DEMANDS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|