[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WMS_CARTONIZATION_TEMP1 |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.WMS_CARTONIZATION_TEMP1
|
| Subobject Name: | |
| Status: | VALID |
INV.WMS_CARTONIZATION_TEMP1 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WMS_CARTONIZATION_TEMP_N1 | NORMAL | NONUNIQUE |
|
 TRANSACTION_HEADER_ID
|
| WMS_CARTONIZATION_TEMP_N2 | NORMAL | NONUNIQUE |
|
MOVE_ORDER_LINE_ID
|
| WMS_CARTONIZATION_TEMP_U1 | NORMAL | NONUNIQUE |
|
TRANSACTION_TEMP_ID
|
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_TXN_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
, 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
, TRANSACTION_BATCH_ID
, TRANSACTION_BATCH_SEQ
, OPERATION_PLAN_ID
, INTRANSIT_ACCOUNT
, FOB_POINT
, LOGICAL_TRX_TYPE_CODE
, MOVE_ORDER_HEADER_ID
, ORIGINAL_TRANSACTION_TEMP_ID
, SERIAL_ALLOCATED_FLAG
, TRX_FLOW_HEADER_ID
, FULFILLMENT_BASE
FROM INV.WMS_CARTONIZATION_TEMP1;
INV.WMS_CARTONIZATION_TEMP1 does not reference any database object
INV.WMS_CARTONIZATION_TEMP1 is referenced by following:
APPS
WMS_CARTONIZATION_TEMP1
|
|
|
|