[Home] [Help] [Dependency Information]
Object Name: | MTL_ADJUSTMENT_SYNC_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_NUMBER | NUMBER | |||
TRANSACTION_DATE | DATE | |||
CATEGORY | VARCHAR2 | (163) | ||
CATEGORY_ID | NUMBER | Yes | ||
WAREHOUSE | VARCHAR2 | (240) | Yes | |
ORGANIZATION_ID | NUMBER | |||
ITEM | VARCHAR2 | (240) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
INVENTORY_ITEM_ID | NUMBER | |||
REVISION | VARCHAR2 | (3) | ||
SUBINVENTORY | VARCHAR2 | (10) | ||
LOCATOR | VARCHAR2 | (122) | ||
TRANSFER_WAREHOUSE | VARCHAR2 | (240) | ||
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | ||
TRANSFER_LOCATOR | VARCHAR2 | (122) | ||
LPN | VARCHAR2 | (30) | ||
TRANSFER_LPN | VARCHAR2 | (30) | ||
CONTENT_LPN | VARCHAR2 | (30) | ||
TRANSACTION_TYPE | VARCHAR2 | (80) | Yes | |
TRANSACTION_TYPE_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | |||
TRANSACTION_ACTION_ID | NUMBER | |||
TRANSACTION_SOURCE | VARCHAR2 | (240) | ||
CREATION_DATE | DATE | |||
TRANSACTION_EXTRACTED | VARCHAR2 | (1) | ||
XML_DOCUMENT_ID | NUMBER | |||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_UOM | VARCHAR2 | (25) | Yes | |
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UOM | VARCHAR2 | (25) | Yes | |
SECONDARY_QUANTITY | NUMBER | |||
SECONDARY_UOM | VARCHAR2 | (25) | ||
ENTITY_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_NUMBER
, TRANSACTION_DATE
, CATEGORY
, CATEGORY_ID
, WAREHOUSE
, ORGANIZATION_ID
, ITEM
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY
, LOCATOR
, TRANSFER_WAREHOUSE
, TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR
, LPN
, TRANSFER_LPN
, CONTENT_LPN
, TRANSACTION_TYPE
, TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE
, CREATION_DATE
, TRANSACTION_EXTRACTED
, XML_DOCUMENT_ID
, TRANSACTION_QUANTITY
, TRANSACTION_UOM
, PRIMARY_QUANTITY
, PRIMARY_UOM
, SECONDARY_QUANTITY
, SECONDARY_UOM
, ENTITY_ID
FROM INV.MTL_ADJUSTMENT_SYNC_TEMP#;
|
|
|