[Home] [Help] [Dependency Information]

VIEW: MSC.MSC_STORE_SUPPLIES#

Object Details

[View Source]

Columns

Query Text

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

SELECT PLAN_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SCHEDULE_DESIGNATOR_ID
,      REVISION
,      UNIT_NUMBER
,      NEW_SCHEDULE_DATE
,      OLD_SCHEDULE_DATE
,      NEW_WIP_START_DATE
,      OLD_WIP_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      DISPOSITION_ID
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      NEW_ORDER_QUANTITY
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_PLACEMENT_DATE
,      OLD_ORDER_PLACEMENT_DATE
,      RESCHEDULE_DAYS
,      RESCHEDULE_FLAG
,      SCHEDULE_COMPRESS_DAYS
,      NEW_PROCESSING_DAYS
,      PURCH_LINE_NUM
,      QUANTITY_IN_PROCESS
,      IMPLEMENTED_QUANTITY
,      FIRM_PLANNED_TYPE
,      FIRM_QUANTITY
,      FIRM_DATE
,      IMPLEMENT_DEMAND_CLASS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY
,      IMPLEMENT_FIRM
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_DOCK_DATE
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_EMPLOYEE_ID
,      IMPLEMENT_UOM_CODE
,      IMPLEMENT_LOCATION_ID
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_SR_INSTANCE_ID
,      IMPLEMENT_SUPPLIER_ID
,      IMPLEMENT_SUPPLIER_SITE_ID
,      IMPLEMENT_AS
,      RELEASE_STATUS
,      LOAD_TYPE
,      PROCESS_SEQ_ID
,      SCO_SUPPLY_FLAG
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      OPERATION_SEQ_NUM
,      BY_PRODUCT_USING_ASSY_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SR_INSTANCE_ID
,      SOURCE_SUPPLIER_SITE_ID
,      SOURCE_SUPPLIER_ID
,      SHIP_METHOD
,      WEIGHT_CAPACITY_USED
,      VOLUME_CAPACITY_USED
,      NEW_SHIP_DATE
,      NEW_DOCK_DATE
,      OLD_DOCK_DATE
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_BUILD_SEQUENCE
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      IMPLEMENT_UNIT_NUMBER
,      IMPLEMENT_LINE_ID
,      RELEASE_ERRORS
,      NUMBER1
,      SOURCE_ITEM_ID
,      ORDER_NUMBER
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      WIP_ENTITY_NAME
,      IMPLEMENT_PROCESSING_DAYS
,      DELIVERY_PRICE
,      LATE_SUPPLY_DATE
,      LATE_SUPPLY_QTY
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      QTY_SCRAPPED
,      EXPECTED_SCRAP_QTY
,      QTY_COMPLETED
,      DAILY_RATE
,      SCHEDULE_GROUP_NAME
,      UPDATED
,      SUBST_ITEM_FLAG
,      STATUS
,      APPLIED
,      EXPIRATION_QUANTITY
,      EXPIRATION_DATE
,      NON_NETTABLE_QTY
,      IMPLEMENT_WIP_START_DATE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      IMPLEMENT_DAILY_RATE
,      NEED_BY_DATE
,      SOURCE_SUPPLY_ID
,      SR_MTL_SUPPLY_ID
,      WIP_STATUS_CODE
,      DEMAND_CLASS
,      FROM_ORGANIZATION_ID
,      WIP_SUPPLY_TYPE
,      PO_LINE_ID
,      LOAD_FACTOR_RATE
,      ROUTING_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COPRODUCTS_SUPPLY
,      CFM_ROUTING_FLAG
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
,      OLD_NEED_BY_DATE
,      OLD_DAILY_RATE
,      OLD_FIRST_UNIT_START_DATE
,      OLD_LAST_UNIT_COMPLETION_DATE
,      OLD_NEW_SCHEDULE_DATE
,      OLD_QTY_COMPLETED
,      OLD_NEW_ORDER_QUANTITY
,      OLD_FIRM_QUANTITY
,      OLD_FIRM_DATE
,      PLANNING_PARTNER_SITE_ID
,      PLANNING_TP_TYPE
,      OWNING_PARTNER_SITE_ID
,      OWNING_TP_TYPE
,      VMI_FLAG
,      EARLIEST_START_DATE
,      EARLIEST_COMPLETION_DATE
,      MIN_START_DATE
,      SCHEDULED_DEMAND_ID
,      EXPLOSION_DATE
,      SCO_SUPPLY_DATE
,      RECORD_SOURCE
,      SUPPLY_IS_SHARED
,      ULPSD
,      ULPCD
,      UEPSD
,      UEPCD
,      EACD
,      ORIGINAL_NEED_BY_DATE
,      ORIGINAL_QUANTITY
,      ACCEPTANCE_REQUIRED_FLAG
,      PROMISED_DATE
,      WIP_START_QUANTITY
,      END_ORDER_NUMBER
,      END_ORDER_LINE_NUMBER
,      ORDER_LINE_NUMBER
,      QUANTITY_PER_ASSEMBLY
,      QUANTITY_ISSUED
,      UNBUCKETED_DEMAND_DATE
,      SHIPMENT_ID
,      JOB_OP_SEQ_NUM
,      JUMP_OP_SEQ_NUM
,      SHIP_CALENDAR
,      RECEIVING_CALENDAR
,      INTRANSIT_CALENDAR
,      INTRANSIT_LEAD_TIME
,      OLD_SHIP_DATE
,      IMPLEMENT_SHIP_DATE
,      ORIG_SHIP_METHOD
,      ORIG_INTRANSIT_LEAD_TIME
,      PARENT_ID
,      DAYS_LATE
,      SCHEDULE_PRIORITY
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      WSM_FAULTY_NETWORK
,      IMPLEMENT_DEST_ORG_ID
,      IMPLEMENT_DEST_INST_ID
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      ASSET_SERIAL_NUMBER
,      ASSET_ITEM_ID
,      TOP_TRANSACTION_ID
,      UNBUCKETED_NEW_SCHED_DATE
,      IMPLEMENT_SHIP_METHOD
,      ACTUAL_START_DATE
FROM MSC.MSC_STORE_SUPPLIES#;

Dependencies

[top of page]

MSC

MSC_STORE_SUPPLIES

APPS

MSC_STORE_SUPPLIES