[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPPLIES# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
TRANSACTION_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
SR_INSTANCE_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
SCHEDULE_DESIGNATOR_ID | NUMBER | |||
REVISION | VARCHAR2 | (10) | ||
UNIT_NUMBER | VARCHAR2 | (30) | ||
NEW_SCHEDULE_DATE | DATE | Yes | ||
OLD_SCHEDULE_DATE | DATE | |||
NEW_WIP_START_DATE | DATE | |||
OLD_WIP_START_DATE | DATE | |||
FIRST_UNIT_COMPLETION_DATE | DATE | |||
LAST_UNIT_COMPLETION_DATE | DATE | |||
FIRST_UNIT_START_DATE | DATE | |||
LAST_UNIT_START_DATE | DATE | |||
DISPOSITION_ID | NUMBER | |||
DISPOSITION_STATUS_TYPE | NUMBER | |||
ORDER_TYPE | NUMBER | Yes | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
NEW_ORDER_QUANTITY | NUMBER | |||
OLD_ORDER_QUANTITY | NUMBER | |||
NEW_ORDER_PLACEMENT_DATE | DATE | |||
OLD_ORDER_PLACEMENT_DATE | DATE | |||
RESCHEDULE_DAYS | NUMBER | |||
RESCHEDULE_FLAG | NUMBER | |||
SCHEDULE_COMPRESS_DAYS | NUMBER | |||
NEW_PROCESSING_DAYS | NUMBER | |||
PURCH_LINE_NUM | NUMBER | |||
QUANTITY_IN_PROCESS | NUMBER | |||
IMPLEMENTED_QUANTITY | NUMBER | |||
FIRM_PLANNED_TYPE | NUMBER | Yes | ||
FIRM_QUANTITY | NUMBER | |||
FIRM_DATE | DATE | |||
IMPLEMENT_DEMAND_CLASS | VARCHAR2 | (30) | ||
IMPLEMENT_DATE | DATE | |||
IMPLEMENT_QUANTITY | NUMBER | |||
IMPLEMENT_FIRM | NUMBER | |||
IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | (10) | ||
IMPLEMENT_JOB_NAME | VARCHAR2 | (240) | ||
IMPLEMENT_DOCK_DATE | DATE | |||
IMPLEMENT_STATUS_CODE | NUMBER | |||
IMPLEMENT_EMPLOYEE_ID | NUMBER | |||
IMPLEMENT_UOM_CODE | VARCHAR2 | (3) | ||
IMPLEMENT_LOCATION_ID | NUMBER | |||
IMPLEMENT_SOURCE_ORG_ID | NUMBER | |||
IMPLEMENT_SR_INSTANCE_ID | NUMBER | |||
IMPLEMENT_SUPPLIER_ID | NUMBER | |||
IMPLEMENT_SUPPLIER_SITE_ID | NUMBER | |||
IMPLEMENT_AS | NUMBER | |||
RELEASE_STATUS | NUMBER | |||
LOAD_TYPE | NUMBER | |||
PROCESS_SEQ_ID | NUMBER | |||
SCO_SUPPLY_FLAG | NUMBER | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | ||
OPERATION_SEQ_NUM | NUMBER | |||
BY_PRODUCT_USING_ASSY_ID | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_SR_INSTANCE_ID | NUMBER | |||
SOURCE_SUPPLIER_SITE_ID | NUMBER | |||
SOURCE_SUPPLIER_ID | NUMBER | |||
SHIP_METHOD | VARCHAR2 | (30) | ||
WEIGHT_CAPACITY_USED | NUMBER | |||
VOLUME_CAPACITY_USED | NUMBER | |||
NEW_SHIP_DATE | DATE | |||
NEW_DOCK_DATE | DATE | |||
OLD_DOCK_DATE | DATE | |||
LINE_ID | NUMBER | |||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
PLANNING_GROUP | VARCHAR2 | (30) | ||
IMPLEMENT_PROJECT_ID | NUMBER | (15) | ||
IMPLEMENT_TASK_ID | NUMBER | (15) | ||
IMPLEMENT_SCHEDULE_GROUP_ID | NUMBER | |||
IMPLEMENT_BUILD_SEQUENCE | NUMBER | |||
IMPLEMENT_ALTERNATE_BOM | VARCHAR2 | (10) | ||
IMPLEMENT_ALTERNATE_ROUTING | VARCHAR2 | (10) | ||
IMPLEMENT_UNIT_NUMBER | VARCHAR2 | (30) | ||
IMPLEMENT_LINE_ID | NUMBER | |||
RELEASE_ERRORS | VARCHAR2 | (250) | ||
NUMBER1 | NUMBER | |||
SOURCE_ITEM_ID | NUMBER | |||
ORDER_NUMBER | VARCHAR2 | (240) | ||
SCHEDULE_GROUP_ID | NUMBER | |||
BUILD_SEQUENCE | NUMBER | |||
WIP_ENTITY_NAME | VARCHAR2 | (240) | ||
IMPLEMENT_PROCESSING_DAYS | NUMBER | |||
DELIVERY_PRICE | NUMBER | |||
LATE_SUPPLY_DATE | DATE | |||
LATE_SUPPLY_QTY | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (80) | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
QTY_SCRAPPED | NUMBER | |||
EXPECTED_SCRAP_QTY | NUMBER | |||
QTY_COMPLETED | NUMBER | |||
DAILY_RATE | NUMBER | |||
SCHEDULE_GROUP_NAME | VARCHAR2 | (30) | ||
UPDATED | NUMBER | |||
SUBST_ITEM_FLAG | NUMBER | |||
STATUS | NUMBER | |||
APPLIED | NUMBER | |||
EXPIRATION_QUANTITY | NUMBER | |||
EXPIRATION_DATE | DATE | |||
NON_NETTABLE_QTY | NUMBER | |||
IMPLEMENT_WIP_START_DATE | DATE | |||
REFRESH_NUMBER | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
IMPLEMENT_DAILY_RATE | NUMBER | |||
NEED_BY_DATE | DATE | |||
SOURCE_SUPPLY_ID | NUMBER | |||
SR_MTL_SUPPLY_ID | NUMBER | |||
WIP_STATUS_CODE | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (34) | ||
FROM_ORGANIZATION_ID | NUMBER | |||
WIP_SUPPLY_TYPE | NUMBER | |||
PO_LINE_ID | NUMBER | |||
LOAD_FACTOR_RATE | NUMBER | |||
ROUTING_SEQUENCE_ID | NUMBER | |||
BILL_SEQUENCE_ID | NUMBER | |||
COPRODUCTS_SUPPLY | NUMBER | |||
CFM_ROUTING_FLAG | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
SHIP_TO_SITE_ID | NUMBER | |||
OLD_NEED_BY_DATE | DATE | |||
OLD_DAILY_RATE | NUMBER | |||
OLD_FIRST_UNIT_START_DATE | DATE | |||
OLD_LAST_UNIT_COMPLETION_DATE | DATE | |||
OLD_NEW_SCHEDULE_DATE | DATE | |||
OLD_QTY_COMPLETED | NUMBER | |||
OLD_NEW_ORDER_QUANTITY | NUMBER | |||
OLD_FIRM_QUANTITY | NUMBER | |||
OLD_FIRM_DATE | DATE | |||
PLANNING_PARTNER_SITE_ID | NUMBER | |||
PLANNING_TP_TYPE | NUMBER | |||
OWNING_PARTNER_SITE_ID | NUMBER | |||
OWNING_TP_TYPE | NUMBER | |||
VMI_FLAG | NUMBER | |||
EARLIEST_START_DATE | DATE | |||
EARLIEST_COMPLETION_DATE | DATE | |||
MIN_START_DATE | DATE | |||
SCHEDULED_DEMAND_ID | NUMBER | |||
EXPLOSION_DATE | DATE | |||
SCO_SUPPLY_DATE | DATE | |||
RECORD_SOURCE | NUMBER | |||
SUPPLY_IS_SHARED | NUMBER | |||
ULPSD | DATE | |||
ULPCD | DATE | |||
UEPSD | DATE | |||
UEPCD | DATE | |||
EACD | DATE | |||
ORIGINAL_NEED_BY_DATE | DATE | |||
ORIGINAL_QUANTITY | NUMBER | |||
ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | ||
PROMISED_DATE | DATE | |||
WIP_START_QUANTITY | NUMBER | |||
END_ORDER_NUMBER | VARCHAR2 | (240) | ||
END_ORDER_LINE_NUMBER | VARCHAR2 | (25) | ||
ORDER_LINE_NUMBER | VARCHAR2 | (25) | ||
QUANTITY_PER_ASSEMBLY | NUMBER | |||
QUANTITY_ISSUED | NUMBER | |||
UNBUCKETED_DEMAND_DATE | DATE | |||
SHIPMENT_ID | NUMBER | |||
JOB_OP_SEQ_NUM | NUMBER | |||
JUMP_OP_SEQ_NUM | NUMBER | |||
SHIP_CALENDAR | VARCHAR2 | (15) | ||
RECEIVING_CALENDAR | VARCHAR2 | (15) | ||
INTRANSIT_CALENDAR | VARCHAR2 | (15) | ||
INTRANSIT_LEAD_TIME | NUMBER | |||
OLD_SHIP_DATE | VARCHAR2 | (240) | ||
IMPLEMENT_SHIP_DATE | DATE | |||
ORIG_SHIP_METHOD | VARCHAR2 | (30) | ||
ORIG_INTRANSIT_LEAD_TIME | NUMBER | |||
PARENT_ID | NUMBER | |||
DAYS_LATE | NUMBER | |||
SCHEDULE_PRIORITY | NUMBER | |||
PO_LINE_LOCATION_ID | NUMBER | |||
PO_DISTRIBUTION_ID | NUMBER | |||
WSM_FAULTY_NETWORK | NUMBER | |||
IMPLEMENT_DEST_ORG_ID | NUMBER | |||
IMPLEMENT_DEST_INST_ID | NUMBER | |||
REQUESTED_START_DATE | DATE | |||
REQUESTED_COMPLETION_DATE | DATE | |||
ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | ||
ASSET_ITEM_ID | NUMBER | |||
TOP_TRANSACTION_ID | NUMBER | |||
UNBUCKETED_NEW_SCHED_DATE | DATE | |||
IMPLEMENT_SHIP_METHOD | VARCHAR2 | (30) | ||
ACTUAL_START_DATE | DATE | |||
FIRM_SHIP_DATE | DATE | |||
SCHEDULE_ORIGINATION_TYPE | NUMBER | |||
UNBUCKETED_START_DATE | DATE | |||
SR_CUSTOMER_ACCT_ID | NUMBER | |||
ITEM_TYPE_ID | NUMBER | |||
CUSTOMER_PRODUCT_ID | NUMBER | (15) | ||
RO_STATUS_CODE | VARCHAR2 | (30) | ||
SR_REPAIR_GROUP_ID | NUMBER | |||
SR_REPAIR_TYPE_ID | NUMBER | (15) | ||
ITEM_TYPE_VALUE | NUMBER | |||
ZONE_ID | NUMBER | |||
RO_CREATION_DATE | DATE | |||
REPAIR_LEAD_TIME | NUMBER | |||
FIRM_START_DATE | DATE | |||
REQ_LINE_ID | NUMBER | |||
INTRANSIT_OWNING_ORG_ID | NUMBER | |||
RELEASABLE | NUMBER | |||
BATCH_ID | NUMBER | |||
OTM_ARRIVAL_DATE | DATE | |||
PS_SUPPLY_FLAG | NUMBER | |||
CTB_FLAG | VARCHAR2 | (1) | ||
CTB_COMP_AVAIL_PERCENT | NUMBER | |||
RTB_ORDER_QTY_PERCENT | NUMBER | |||
CTB_EXPECTED_DATE | DATE | |||
POTENTIAL_RTB_PERCENT | NUMBER | |||
CTB_PRIORITY | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
MAINTENANCE_OBJECT_SOURCE | NUMBER | |||
PRODUCTION_SCHEDULE_ID | NUMBER | |||
VISIT_ID | NUMBER | |||
PRODUCES_TO_STOCK | NUMBER | |||
PRODUCT_CLASSIFICATION | VARCHAR2 | (150) | ||
MAINTENANCE_REQT | VARCHAR2 | (80) | ||
ACTIVITY_TYPE | NUMBER | |||
ACTIVITY_NAME | VARCHAR2 | (250) | ||
CLASS_CODE | VARCHAR2 | (10) | ||
SHUTDOWN_TYPE | NUMBER | |||
TO_BE_EXPLODED | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (3) | ||
MAINTENANCE_TYPE_CODE | VARCHAR2 | (30) | ||
ACTIVITY_ITEM_ID | NUMBER | |||
ORIG_FIRM_DATE | DATE | |||
ORIG_FIRM_QUANTITY | NUMBER | |||
USE_WO_SUBSTITUTE | NUMBER | |||
ASSET_NUMBER | VARCHAR2 | (30) | ||
MAINTENANCE_OBJECT_ID | NUMBER | |||
MAINTENANCE_OBJECT_TYPE | NUMBER | |||
OPERATING_FLEET | NUMBER | |||
MAINTENANCE_REQUIREMENT | VARCHAR2 | (22) | ||
COLL_ORDER_TYPE | NUMBER |
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
, FIRM_SHIP_DATE
, SCHEDULE_ORIGINATION_TYPE
, UNBUCKETED_START_DATE
, SR_CUSTOMER_ACCT_ID
, ITEM_TYPE_ID
, CUSTOMER_PRODUCT_ID
, RO_STATUS_CODE
, SR_REPAIR_GROUP_ID
, SR_REPAIR_TYPE_ID
, ITEM_TYPE_VALUE
, ZONE_ID
, RO_CREATION_DATE
, REPAIR_LEAD_TIME
, FIRM_START_DATE
, REQ_LINE_ID
, INTRANSIT_OWNING_ORG_ID
, RELEASABLE
, BATCH_ID
, OTM_ARRIVAL_DATE
, PS_SUPPLY_FLAG
, CTB_FLAG
, CTB_COMP_AVAIL_PERCENT
, RTB_ORDER_QTY_PERCENT
, CTB_EXPECTED_DATE
, POTENTIAL_RTB_PERCENT
, CTB_PRIORITY
, DESCRIPTION
, MAINTENANCE_OBJECT_SOURCE
, PRODUCTION_SCHEDULE_ID
, VISIT_ID
, PRODUCES_TO_STOCK
, PRODUCT_CLASSIFICATION
, MAINTENANCE_REQT
, ACTIVITY_TYPE
, ACTIVITY_NAME
, CLASS_CODE
, SHUTDOWN_TYPE
, TO_BE_EXPLODED
, OBJECT_TYPE
, MAINTENANCE_TYPE_CODE
, ACTIVITY_ITEM_ID
, ORIG_FIRM_DATE
, ORIG_FIRM_QUANTITY
, USE_WO_SUBSTITUTE
, ASSET_NUMBER
, MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE
, OPERATING_FLEET
, MAINTENANCE_REQUIREMENT
, COLL_ORDER_TYPE
FROM MSC.MSC_SUPPLIES#;
|
|
|