eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSC.MSC_PART_DEMANDS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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