VIEW: MSC.MSC_PART_SUPPLIES#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SOURCE_SUPPLIER_ID SOURCE_SUPPLIER_ID, SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_SITE_ID, SOURCE_SR_INSTANCE_ID SOURCE_SR_INSTANCE_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, ITEM_TYPE_VALUE ITEM_TYPE_VALUE, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, ORIG_TRANSACTION_ID ORIG_TRANSACTION_ID, TRANSACTION_ID TRANSACTION_ID, ORDER_TYPE ORDER_TYPE, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE, PLAN_ID PLAN_ID, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS, IMPLEMENT_DATE IMPLEMENT_DATE, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE, IMPLEMENT_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID, IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_SR_INSTANCE_ID, IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_ID, IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_SUPPLIER_SITE_ID, IMPLEMENT_AS IMPLEMENT_AS, LOAD_TYPE LOAD_TYPE, RELEASE_ERRORS RELEASE_ERRORS, RELEASABLE RELEASABLE, BATCH_ID BATCH_ID, NEW_DOCK_DATE NEW_DOCK_DATE, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID, IMPLEMENT_UNIT_NUMBER IMPLEMENT_UNIT_NUMBER, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE, IMPLEMENT_SHIP_METHOD IMPLEMENT_SHIP_METHOD, SHIP_METHOD SHIP_METHOD from "MSC"."MSC_PART_SUPPLIES"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SOURCE_SUPPLIER_ID SOURCE_SUPPLIER_ID
, SOURCE_SUPPLIER_SITE_ID SOURCE_SUPPLIER_SITE_ID
, SOURCE_SR_INSTANCE_ID SOURCE_SR_INSTANCE_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, ITEM_TYPE_VALUE ITEM_TYPE_VALUE
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, ORIG_TRANSACTION_ID ORIG_TRANSACTION_ID
, TRANSACTION_ID TRANSACTION_ID
, ORDER_TYPE ORDER_TYPE
, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY
, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE
, PLAN_ID PLAN_ID
, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY
, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE IMPLEMENT_DATE
, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY
, IMPLEMENT_FIRM IMPLEMENT_FIRM
, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME
, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE
, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE
, IMPLEMENT_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID
, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE
, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID
, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_SR_INSTANCE_ID IMPLEMENT_SR_INSTANCE_ID
, IMPLEMENT_SUPPLIER_ID IMPLEMENT_SUPPLIER_ID
, IMPLEMENT_SUPPLIER_SITE_ID IMPLEMENT_SUPPLIER_SITE_ID
, IMPLEMENT_AS IMPLEMENT_AS
, LOAD_TYPE LOAD_TYPE
, RELEASE_ERRORS RELEASE_ERRORS
, RELEASABLE RELEASABLE
, BATCH_ID BATCH_ID
, NEW_DOCK_DATE NEW_DOCK_DATE
, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID
, IMPLEMENT_UNIT_NUMBER IMPLEMENT_UNIT_NUMBER
, IMPLEMENT_SHIP_DATE IMPLEMENT_SHIP_DATE
, IMPLEMENT_SHIP_METHOD IMPLEMENT_SHIP_METHOD
, SHIP_METHOD SHIP_METHOD
FROM "MSC"."MSC_PART_SUPPLIES"