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]

TABLE: WIP.WIP_LPN_COMPLETIONS

Object Details

Object Name:	WIP_LPN_COMPLETIONS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_LPN_COMPLETIONS
Subobject Name:
Status:	VALID

This table contains material for WIP Lpn completions (Mobile Apps)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_LPN_COMPLETIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID
WIP_LPN_COMPLETIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Unique row identifier. Used to join to WIP_LPN_COMPLETIONS_LOTS and WIP_LPN_COMPLETIONS_SERIALS.
SOURCE_ID	NUMBER			Transaction group identifier. For completions, this is the header_id of the assembly.
SOURCE_CODE	VARCHAR2	(30)		source code
COMPLETION_STATUS	VARCHAR2	(240)		completion status
LAST_UPDATE_DATE	DATE			standard who column
LAST_UPDATED_BY	NUMBER			standard who column
CREATION_DATE	DATE			standard who column
CREATED_BY	NUMBER		Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER			standard who column
PROGRAM_APPLICATION_ID	VARCHAR2	(240)		enhanced who column
PROGRAM_ID	NUMBER			enhanced who column
PROGRAM_UPDATE_DATE	DATE			enhanced who column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier for item
ORGANIZATION_ID	NUMBER		Yes	organization identifier
PRIMARY_QUANTITY	NUMBER		Yes	Transaction quantity in terms of the primary uom of the item
TRANSACTION_QUANTITY	NUMBER		Yes	Quantity entered at transaction time
TRANSACTION_UOM	VARCHAR2	(3)	Yes	UOM used at the time of transaction
TRANSACTION_DATE	DATE		Yes	Transaction date
TRANSACTION_ACTION_ID	NUMBER		Yes	Transaction action identifier
TRANSACTION_SOURCE_ID	NUMBER			Transaction source identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER			Transaction source type identifier
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction type identifier
TRANSACTION_MODE	NUMBER			Indicates whether transaction was online or background.
ACCT_PERIOD_ID	NUMBER		Yes	Account period identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory name
LOCATOR_ID	NUMBER			Locator identifier
WIP_ENTITY_ID	NUMBER			Wip entity identifier
WIP_ENTITY_TYPE	NUMBER			Wip entity type code.
SCHEDULE_ID	NUMBER			Schedule identifier
REPETITIVE_LINE_ID	NUMBER			Repetitive line identifier
OPERATION_SEQ_NUM	NUMBER			Operation sequence number
BOM_REVISION	VARCHAR2	(3)		BOM revision number
ROUTING_REVISION	VARCHAR2	(3)		Routing revision number
BOM_REVISION_DATE	DATE			BOM revision date
ROUTING_REVISION_DATE	DATE			Routing revision date
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate BOM designator
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(10)		Alternate routing designator
ACCOUNTING_CLASS	VARCHAR2	(10)		WIP accouting class
COST_GROUP_ID	NUMBER			Cost group identifier
KANBAN_CARD_ID	NUMBER			Kanban card identifier
QA_COLLECTION_ID	NUMBER			Quality collection identifier
LPN_ID	NUMBER			license plate number identifier
REASON_ID	NUMBER			Reason identifier
LOCK_FLAG	VARCHAR2	(1)		Lock flag
ERROR_CODE	VARCHAR2	(240)		Error code
FINAL_COMPLETION_FLAG	VARCHAR2	(1)		Final completion flag
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		End item unit number
COMPLETION_TRANSACTION_ID	NUMBER			Used in resource charging for work order-less completions.
ITEM_PROJECT_ID	NUMBER			Item project identifier
ITEM_TASK_ID	NUMBER			Item task identifier
SOURCE_PROJECT_ID	NUMBER			Source Project Identifier
SOURCE_TASK_ID	NUMBER			Source Task Identifier
DEMAND_SOURCE_HEADER_ID	NUMBER			Demand Source Header Identification
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Demand Source Line
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		Demand Source Delivery

Query Text

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


SELECT HEADER_ID
,      SOURCE_ID
,      SOURCE_CODE
,      COMPLETION_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_QUANTITY
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      TRANSACTION_DATE
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_MODE
,      ACCT_PERIOD_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_TYPE
,      SCHEDULE_ID
,      REPETITIVE_LINE_ID
,      OPERATION_SEQ_NUM
,      BOM_REVISION
,      ROUTING_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      ACCOUNTING_CLASS
,      COST_GROUP_ID
,      KANBAN_CARD_ID
,      QA_COLLECTION_ID
,      LPN_ID
,      REASON_ID
,      LOCK_FLAG
,      ERROR_CODE
,      FINAL_COMPLETION_FLAG
,      END_ITEM_UNIT_NUMBER
,      COMPLETION_TRANSACTION_ID
,      ITEM_PROJECT_ID
,      ITEM_TASK_ID
,      SOURCE_PROJECT_ID
,      SOURCE_TASK_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
FROM WIP.WIP_LPN_COMPLETIONS;

Dependencies

[top of page]

WIP.WIP_LPN_COMPLETIONS does not reference any database object

WIP.WIP_LPN_COMPLETIONS is referenced by following:

APPS: WIP_LPN_COMPLETIONS