eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.WMS_WP_WWB_TASKS_V

Object Details

Object Name:	WMS_WP_WWB_TASKS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
TASK_ID	NUMBER
TO_LPN	VARCHAR2	(30)
TO_LPN_ID	NUMBER
TRANSACTION_TEMP_ID	NUMBER
TRANSACTION_TYPE_ID	NUMBER
TRANSACTION_ACTION_ID	NUMBER
TRANSACTION_SOURCE_TYPE_ID	NUMBER
TRANSACTION_SOURCE_ID	NUMBER
TRANSACTION_SOURCE_LINE_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
TO_ORGANIZATION_ID	NUMBER
TO_ORGANIZATION_CODE	VARCHAR2	(3)
TO_SUBINVENTORY	VARCHAR2	(10)
TO_LOCATOR_ID	NUMBER
TO_LOCATOR	CHAR	(1)
USER_TASK_TYPE_ID	NUMBER
USER_TASK_TYPE	VARCHAR2	(4)
PERSON_ID	NUMBER
PERSON_ID_ORIGINAL	NUMBER
PERSON	VARCHAR2	(240)
EFFECTIVE_START_DATE	DATE
EFFECTIVE_END_DATE	DATE
PERSON_RESOURCE_ID	NUMBER
PERSON_RESOURCE_CODE	VARCHAR2	(10)
STATUS_ID	NUMBER
STATUS_ID_ORIGINAL	NUMBER
STATUS	VARCHAR2	(80)
MMTT_LAST_UPDATE_DATE	DATE
MMTT_LAST_UPDATED_BY	NUMBER
WDT_LAST_UPDATE_DATE	DATE
WDT_LAST_UPDATED_BY	NUMBER
PRIORITY	NUMBER
PRIORITY_ORIGINAL	NUMBER
TASK_TYPE_ID	NUMBER
TASK_TYPE	VARCHAR2	(19)
IS_MODIFIED	CHAR	(1)
PLAN_TASK	VARCHAR2	(16)
RESULT	CHAR	(1)
ERROR	CHAR	(1)
SOURCE_HEADER	VARCHAR2	(150)
LINE_NUMBER	VARCHAR2	(150)
ITEM	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
REVISION	VARCHAR2	(3)
SUBINVENTORY	VARCHAR2	(10)
LOCATOR	CHAR	(1)
SECONDARY_QUANTITY	NUMBER
SECONDARY_UOM	VARCHAR2	(240)
OPERATION_PLAN_ID	NUMBER
OPERATION_PLAN	VARCHAR2	(255)
OPERATION_SEQUENCE	NUMBER
OPERATION_PLAN_INSTANCE	NUMBER
SHIP_METHOD	VARCHAR2	(30)
SHIPMENT_DATE	DATE
SHIPMENT_PRIORITY	VARCHAR2	(30)
DEPARTMENT	VARCHAR2	(40)
CHILD_TASKS	VARCHAR2	(1)
NUM_OF_CHILD_TASKS	NUMBER
ALLOCATED_LPN	VARCHAR2	(30)
CARTONIZED_LPN	VARCHAR2	(30)
CONTAINER_ITEM	VARCHAR2	(40)
CONTENT_LPN	VARCHAR2	(30)
DISPATCHED_TIME	DATE
EQUIPMENT	NUMBER
FROM_LPN	VARCHAR2	(30)
PARENT_LINE_ID	NUMBER
MOVE_ORDER_LINE_ID	NUMBER
PICK_SLIP_NUMBER	NUMBER
PICKED_LPN	VARCHAR2	(30)
TRANSACTION_UOM	VARCHAR2	(3)
TRANSACTION_QUANTITY	NUMBER
WAVE_HEADER_ID	NUMBER

Query Text

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


SELECT TASK_ID
,      TO_LPN
,      TO_LPN_ID
,      TRANSACTION_TEMP_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_LINE_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_SUBINVENTORY
,      TO_LOCATOR_ID
,      TO_LOCATOR
,      USER_TASK_TYPE_ID
,      USER_TASK_TYPE
,      PERSON_ID
,      PERSON_ID_ORIGINAL
,      PERSON
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PERSON_RESOURCE_ID
,      PERSON_RESOURCE_CODE
,      STATUS_ID
,      STATUS_ID_ORIGINAL
,      STATUS
,      MMTT_LAST_UPDATE_DATE
,      MMTT_LAST_UPDATED_BY
,      WDT_LAST_UPDATE_DATE
,      WDT_LAST_UPDATED_BY
,      PRIORITY
,      PRIORITY_ORIGINAL
,      TASK_TYPE_ID
,      TASK_TYPE
,      IS_MODIFIED
,      PLAN_TASK
,      RESULT
,      ERROR
,      SOURCE_HEADER
,      LINE_NUMBER
,      ITEM
,      ITEM_DESCRIPTION
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      OPERATION_PLAN_ID
,      OPERATION_PLAN
,      OPERATION_SEQUENCE
,      OPERATION_PLAN_INSTANCE
,      SHIP_METHOD
,      SHIPMENT_DATE
,      SHIPMENT_PRIORITY
,      DEPARTMENT
,      CHILD_TASKS
,      NUM_OF_CHILD_TASKS
,      ALLOCATED_LPN
,      CARTONIZED_LPN
,      CONTAINER_ITEM
,      CONTENT_LPN
,      DISPATCHED_TIME
,      EQUIPMENT
,      FROM_LPN
,      PARENT_LINE_ID
,      MOVE_ORDER_LINE_ID
,      PICK_SLIP_NUMBER
,      PICKED_LPN
,      TRANSACTION_UOM
,      TRANSACTION_QUANTITY
,      WAVE_HEADER_ID
FROM APPS.WMS_WP_WWB_TASKS_V;

Dependencies

[top of page]

APPS.WMS_WP_WWB_TASKS_V references the following:

APPS: BOM_RESOURCES; BOM_STANDARD_OPERATIONS; MFG_LOOKUPS; MTL_ITEM_LOCATIONS_KFV; MTL_MATERIAL_TRANSACTIONS; MTL_MATERIAL_TRANSACTIONS_TEMP; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; MTL_TXN_REQUEST_HEADERS; MTL_TXN_REQUEST_LINES; PER_ALL_PEOPLE_F; WMS_DISPATCHED_TASKS; WMS_DISPATCHED_TASKS_HISTORY; WMS_LICENSE_PLATE_NUMBERS; WMS_OP_OPERATION_INSTANCES; WMS_OP_PLANS_VL; WMS_REPLENISHMENT_DETAILS; WMS_WP_WAVE_LINES; WSH_DELIVERY_DETAILS

APPS.WMS_WP_WWB_TASKS_V is referenced by following:

APPS: WMS_WAVE_PLANNING_PVT - show dependent code