[Home] [Help] [Dependency Information]
Object Name: | WMS_MATERIAL_TXN_TRACE# |
---|---|
Object Type: | VIEW |
Owner: | WMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | Yes | ||
TRANSACTION_TEMP_ID | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (30) | ||
SOURCE_LINE_ID | NUMBER | |||
TRANSACTION_MODE | NUMBER | |||
LOCK_FLAG | VARCHAR2 | (1) | ||
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 | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
REVISION | VARCHAR2 | (3) | ||
ORGANIZATION_ID | NUMBER | Yes | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
TRANSACTION_QUANTITY | NUMBER | Yes | ||
PRIMARY_QUANTITY | NUMBER | Yes | ||
TRANSACTION_UOM | VARCHAR2 | (3) | Yes | |
TRANSACTION_COST | NUMBER | |||
TRANSACTION_TYPE_ID | NUMBER | Yes | ||
TRANSACTION_ACTION_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_ID | NUMBER | |||
TRANSACTION_SOURCE_NAME | VARCHAR2 | (30) | ||
TRANSACTION_DATE | DATE | Yes | ||
ACCT_PERIOD_ID | NUMBER | Yes | ||
DISTRIBUTION_ACCOUNT_ID | NUMBER | |||
TRANSACTION_REFERENCE | VARCHAR2 | (240) | ||
REQUISITION_LINE_ID | NUMBER | |||
REQUISITION_DISTRIBUTION_ID | NUMBER | |||
REASON_ID | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_EXPIRATION_DATE | DATE | |||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
RECEIVING_DOCUMENT | VARCHAR2 | (10) | ||
DEMAND_ID | NUMBER | |||
RCV_TRANSACTION_ID | NUMBER | |||
MOVE_TRANSACTION_ID | NUMBER | |||
COMPLETION_TRANSACTION_ID | NUMBER | |||
WIP_ENTITY_TYPE | NUMBER | |||
SCHEDULE_ID | NUMBER | |||
REPETITIVE_LINE_ID | NUMBER | |||
EMPLOYEE_CODE | VARCHAR2 | (10) | ||
PRIMARY_SWITCH | NUMBER | |||
SCHEDULE_UPDATE_CODE | NUMBER | |||
SETUP_TEARDOWN_CODE | NUMBER | |||
ITEM_ORDERING | NUMBER | |||
NEGATIVE_REQ_FLAG | NUMBER | |||
OPERATION_SEQ_NUM | NUMBER | |||
PICKING_LINE_ID | NUMBER | |||
TRX_SOURCE_LINE_ID | NUMBER | |||
TRX_SOURCE_DELIVERY_ID | NUMBER | |||
PHYSICAL_ADJUSTMENT_ID | NUMBER | |||
CYCLE_COUNT_ID | NUMBER | |||
RMA_LINE_ID | NUMBER | |||
CUSTOMER_SHIP_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (10) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
VENDOR_LOT_NUMBER | VARCHAR2 | (30) | ||
ENCUMBRANCE_ACCOUNT | NUMBER | |||
ENCUMBRANCE_AMOUNT | NUMBER | |||
SHIP_TO_LOCATION | NUMBER | |||
SHIPMENT_NUMBER | VARCHAR2 | (30) | ||
TRANSFER_COST | NUMBER | |||
TRANSPORTATION_COST | NUMBER | |||
TRANSPORTATION_ACCOUNT | NUMBER | |||
FREIGHT_CODE | VARCHAR2 | (25) | ||
CONTAINERS | NUMBER | |||
WAYBILL_AIRBILL | VARCHAR2 | (20) | ||
EXPECTED_ARRIVAL_DATE | DATE | |||
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | ||
TRANSFER_ORGANIZATION | NUMBER | |||
TRANSFER_TO_LOCATION | NUMBER | |||
NEW_AVERAGE_COST | NUMBER | |||
VALUE_CHANGE | NUMBER | |||
PERCENTAGE_CHANGE | NUMBER | |||
MATERIAL_ALLOCATION_TEMP_ID | NUMBER | |||
DEMAND_SOURCE_HEADER_ID | NUMBER | |||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | ||
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | ||
ITEM_SEGMENTS | VARCHAR2 | (240) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ITEM_TRX_ENABLED_FLAG | VARCHAR2 | (1) | ||
ITEM_LOCATION_CONTROL_CODE | NUMBER | |||
ITEM_RESTRICT_SUBINV_CODE | NUMBER | |||
ITEM_RESTRICT_LOCATORS_CODE | NUMBER | |||
ITEM_REVISION_QTY_CONTROL_CODE | NUMBER | |||
ITEM_PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
ITEM_UOM_CLASS | VARCHAR2 | (10) | ||
ITEM_SHELF_LIFE_CODE | NUMBER | |||
ITEM_SHELF_LIFE_DAYS | NUMBER | |||
ITEM_LOT_CONTROL_CODE | NUMBER | |||
ITEM_SERIAL_CONTROL_CODE | NUMBER | |||
ITEM_INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | ||
ALLOWED_UNITS_LOOKUP_CODE | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
DEPARTMENT_CODE | VARCHAR2 | (10) | ||
WIP_SUPPLY_TYPE | NUMBER | |||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | ||
SUPPLY_LOCATOR_ID | NUMBER | |||
VALID_SUBINVENTORY_FLAG | VARCHAR2 | (1) | ||
VALID_LOCATOR_FLAG | VARCHAR2 | (1) | ||
LOCATOR_SEGMENTS | VARCHAR2 | (240) | ||
CURRENT_LOCATOR_CONTROL_CODE | NUMBER | |||
NUMBER_OF_LOTS_ENTERED | NUMBER | |||
WIP_COMMIT_FLAG | VARCHAR2 | (1) | ||
NEXT_LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_ALPHA_PREFIX | VARCHAR2 | (30) | ||
NEXT_SERIAL_NUMBER | VARCHAR2 | (30) | ||
SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | ||
SHIPPABLE_FLAG | VARCHAR2 | (1) | ||
POSTING_FLAG | VARCHAR2 | (1) | ||
REQUIRED_FLAG | VARCHAR2 | (1) | ||
PROCESS_FLAG | VARCHAR2 | (1) | ||
ERROR_CODE | VARCHAR2 | (240) | ||
ERROR_EXPLANATION | VARCHAR2 | (240) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
MOVEMENT_ID | NUMBER | |||
RESERVATION_QUANTITY | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
TRANSACTION_LINE_NUMBER | NUMBER | |||
TASK_ID | NUMBER | (15) | ||
TO_TASK_ID | NUMBER | (15) | ||
SOURCE_TASK_ID | NUMBER | |||
PROJECT_ID | NUMBER | (15) | ||
SOURCE_PROJECT_ID | NUMBER | |||
PA_EXPENDITURE_ORG_ID | NUMBER | |||
TO_PROJECT_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
FINAL_COMPLETION_FLAG | VARCHAR2 | (1) | ||
TRANSFER_PERCENTAGE | NUMBER | |||
TRANSACTION_SEQUENCE_ID | NUMBER | |||
MATERIAL_ACCOUNT | NUMBER | |||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | |||
RESOURCE_ACCOUNT | NUMBER | |||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | |||
OVERHEAD_ACCOUNT | NUMBER | |||
FLOW_SCHEDULE | VARCHAR2 | (1) | ||
COST_GROUP_ID | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (30) | ||
QA_COLLECTION_ID | NUMBER | |||
KANBAN_CARD_ID | NUMBER | |||
OVERCOMPLETION_TRANSACTION_QTY | NUMBER | |||
OVERCOMPLETION_PRIMARY_QTY | NUMBER | |||
OVERCOMPLETION_TRANSACTION_ID | NUMBER | |||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (60) | ||
SCHEDULED_PAYBACK_DATE | DATE | |||
LINE_TYPE_CODE | NUMBER | |||
PARENT_TRANSACTION_TEMP_ID | NUMBER | |||
PUT_AWAY_STRATEGY_ID | NUMBER | |||
PUT_AWAY_RULE_ID | NUMBER | |||
PICK_STRATEGY_ID | NUMBER | |||
PICK_RULE_ID | NUMBER | |||
MOVE_ORDER_LINE_ID | NUMBER | |||
TASK_GROUP_ID | NUMBER | |||
PICK_SLIP_NUMBER | NUMBER | |||
RESERVATION_ID | NUMBER | |||
COMMON_BOM_SEQ_ID | NUMBER | |||
COMMON_ROUTING_SEQ_ID | NUMBER | |||
ORG_COST_GROUP_ID | NUMBER | |||
COST_TYPE_ID | NUMBER | |||
TRANSACTION_STATUS | NUMBER | |||
STANDARD_OPERATION_ID | NUMBER | |||
TASK_PRIORITY | NUMBER | |||
WMS_TASK_TYPE | NUMBER | |||
PARENT_LINE_ID | NUMBER | |||
SOURCE_LOT_NUMBER | VARCHAR2 | (80) | ||
TRANSFER_COST_GROUP_ID | NUMBER | |||
LPN_ID | NUMBER | |||
TRANSFER_LPN_ID | NUMBER | |||
WMS_TASK_STATUS | NUMBER | |||
CONTENT_LPN_ID | NUMBER | |||
CONTAINER_ITEM_ID | NUMBER | |||
CARTONIZATION_ID | NUMBER | |||
PICK_SLIP_DATE | DATE | |||
REBUILD_ITEM_ID | NUMBER | |||
REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | ||
REBUILD_ACTIVITY_ID | NUMBER | |||
REBUILD_JOB_NAME | VARCHAR2 | (240) | ||
ORGANIZATION_TYPE | NUMBER | |||
TRANSFER_ORGANIZATION_TYPE | NUMBER | |||
OWNING_ORGANIZATION_ID | NUMBER | |||
OWNING_TP_TYPE | NUMBER | |||
XFR_OWNING_ORGANIZATION_ID | NUMBER | |||
TRANSFER_OWNING_TP_TYPE | NUMBER | |||
PLANNING_ORGANIZATION_ID | NUMBER | |||
PLANNING_TP_TYPE | NUMBER | |||
XFR_PLANNING_ORGANIZATION_ID | NUMBER | |||
TRANSFER_PLANNING_TP_TYPE | NUMBER | |||
SECONDARY_UOM_CODE | VARCHAR2 | (240) | ||
SECONDARY_TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_GROUP_ID | NUMBER | |||
TRANSACTION_GROUP_SEQ | NUMBER | |||
ALLOCATED_LPN_ID | NUMBER | |||
SCHEDULE_NUMBER | VARCHAR2 | (30) | ||
SCHEDULED_FLAG | NUMBER | |||
CLASS_CODE | VARCHAR2 | (10) | ||
SCHEDULE_GROUP | NUMBER | |||
BUILD_SEQUENCE | NUMBER | |||
BOM_REVISION | VARCHAR2 | (3) | ||
ROUTING_REVISION | VARCHAR2 | (3) | ||
BOM_REVISION_DATE | DATE | |||
ROUTING_REVISION_DATE | DATE | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID
, SOURCE_CODE
, SOURCE_LINE_ID
, TRANSACTION_MODE
, LOCK_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, REVISION
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_COST
, TRANSACTION_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_NAME
, TRANSACTION_DATE
, ACCT_PERIOD_ID
, DISTRIBUTION_ACCOUNT_ID
, TRANSACTION_REFERENCE
, REQUISITION_LINE_ID
, REQUISITION_DISTRIBUTION_ID
, REASON_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, RECEIVING_DOCUMENT
, DEMAND_ID
, RCV_TRANSACTION_ID
, MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID
, WIP_ENTITY_TYPE
, SCHEDULE_ID
, REPETITIVE_LINE_ID
, EMPLOYEE_CODE
, PRIMARY_SWITCH
, SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE
, ITEM_ORDERING
, NEGATIVE_REQ_FLAG
, OPERATION_SEQ_NUM
, PICKING_LINE_ID
, TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID
, PHYSICAL_ADJUSTMENT_ID
, CYCLE_COUNT_ID
, RMA_LINE_ID
, CUSTOMER_SHIP_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, USSGL_TRANSACTION_CODE
, VENDOR_LOT_NUMBER
, ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT
, SHIP_TO_LOCATION
, SHIPMENT_NUMBER
, TRANSFER_COST
, TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT
, FREIGHT_CODE
, CONTAINERS
, WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE
, TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION
, TRANSFER_TO_LOCATION
, NEW_AVERAGE_COST
, VALUE_CHANGE
, PERCENTAGE_CHANGE
, MATERIAL_ALLOCATION_TEMP_ID
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, ITEM_SEGMENTS
, ITEM_DESCRIPTION
, ITEM_TRX_ENABLED_FLAG
, ITEM_LOCATION_CONTROL_CODE
, ITEM_RESTRICT_SUBINV_CODE
, ITEM_RESTRICT_LOCATORS_CODE
, ITEM_REVISION_QTY_CONTROL_CODE
, ITEM_PRIMARY_UOM_CODE
, ITEM_UOM_CLASS
, ITEM_SHELF_LIFE_CODE
, ITEM_SHELF_LIFE_DAYS
, ITEM_LOT_CONTROL_CODE
, ITEM_SERIAL_CONTROL_CODE
, ITEM_INVENTORY_ASSET_FLAG
, ALLOWED_UNITS_LOOKUP_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, VALID_SUBINVENTORY_FLAG
, VALID_LOCATOR_FLAG
, LOCATOR_SEGMENTS
, CURRENT_LOCATOR_CONTROL_CODE
, NUMBER_OF_LOTS_ENTERED
, WIP_COMMIT_FLAG
, NEXT_LOT_NUMBER
, LOT_ALPHA_PREFIX
, NEXT_SERIAL_NUMBER
, SERIAL_ALPHA_PREFIX
, SHIPPABLE_FLAG
, POSTING_FLAG
, REQUIRED_FLAG
, PROCESS_FLAG
, ERROR_CODE
, ERROR_EXPLANATION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MOVEMENT_ID
, RESERVATION_QUANTITY
, SHIPPED_QUANTITY
, TRANSACTION_LINE_NUMBER
, TASK_ID
, TO_TASK_ID
, SOURCE_TASK_ID
, PROJECT_ID
, SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID
, TO_PROJECT_ID
, EXPENDITURE_TYPE
, FINAL_COMPLETION_FLAG
, TRANSFER_PERCENTAGE
, TRANSACTION_SEQUENCE_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT
, FLOW_SCHEDULE
, COST_GROUP_ID
, DEMAND_CLASS
, QA_COLLECTION_ID
, KANBAN_CARD_ID
, OVERCOMPLETION_TRANSACTION_QTY
, OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_ID
, END_ITEM_UNIT_NUMBER
, SCHEDULED_PAYBACK_DATE
, LINE_TYPE_CODE
, PARENT_TRANSACTION_TEMP_ID
, PUT_AWAY_STRATEGY_ID
, PUT_AWAY_RULE_ID
, PICK_STRATEGY_ID
, PICK_RULE_ID
, MOVE_ORDER_LINE_ID
, TASK_GROUP_ID
, PICK_SLIP_NUMBER
, RESERVATION_ID
, COMMON_BOM_SEQ_ID
, COMMON_ROUTING_SEQ_ID
, ORG_COST_GROUP_ID
, COST_TYPE_ID
, TRANSACTION_STATUS
, STANDARD_OPERATION_ID
, TASK_PRIORITY
, WMS_TASK_TYPE
, PARENT_LINE_ID
, SOURCE_LOT_NUMBER
, TRANSFER_COST_GROUP_ID
, LPN_ID
, TRANSFER_LPN_ID
, WMS_TASK_STATUS
, CONTENT_LPN_ID
, CONTAINER_ITEM_ID
, CARTONIZATION_ID
, PICK_SLIP_DATE
, REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER
, REBUILD_ACTIVITY_ID
, REBUILD_JOB_NAME
, ORGANIZATION_TYPE
, TRANSFER_ORGANIZATION_TYPE
, OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE
, XFR_OWNING_ORGANIZATION_ID
, TRANSFER_OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE
, XFR_PLANNING_ORGANIZATION_ID
, TRANSFER_PLANNING_TP_TYPE
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, TRANSACTION_GROUP_ID
, TRANSACTION_GROUP_SEQ
, ALLOCATED_LPN_ID
, SCHEDULE_NUMBER
, SCHEDULED_FLAG
, CLASS_CODE
, SCHEDULE_GROUP
, BUILD_SEQUENCE
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
FROM WMS.WMS_MATERIAL_TXN_TRACE#;
|
|
|