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

VIEW: APPS.MTL_ADJ_SYNC_WRAPPER_V

Object Details
Object Name: MTL_ADJ_SYNC_WRAPPER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ADJ_SYNC_WRAPPER_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_NUMBER NUMBER

Transaction number
TRANSACTION_DATE DATE

Transaction Date
CATEGORY VARCHAR2 (163)
category
CATEGORY_ID NUMBER
Yes Category ID
WAREHOUSE VARCHAR2 (240) Yes Organization Name
ORGANIZATION_ID NUMBER

Organization ID
ITEM VARCHAR2 (40)
Item
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
REVISION VARCHAR2 (3)
Revision
SUBINVENTORY VARCHAR2 (10)
Subinventory Code
LOCATOR CHAR (1)
Locator
TRANSFER_WAREHOUSE VARCHAR2 (240)
Transfer Organization Name
TRANSFER_SUBINVENTORY VARCHAR2 (10)
Transfer Subinventory Code
TRANSFER_LOCATOR CHAR (1)
Transfer Locator
LPN VARCHAR2 (30)
License Plate Number
TRANSFER_LPN VARCHAR2 (30)
Transfer License Plate Number
CONTENT_LPN VARCHAR2 (30)
Content License Plate Number
TRANSACTION_TYPE VARCHAR2 (80) Yes Transaction Type
TRANSACTION_TYPE_ID NUMBER
Yes Transaction Type ID
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction Source Type ID
TRANSACTION_ACTION_ID NUMBER

Transaction Action ID
TRANSACTION_SOURCE VARCHAR2 (240)
Transaction Source
CREATION_DATE DATE

Creation Date
TRANSACTION_EXTRACTED VARCHAR2 (1)
Transaction Sync Status
XML_DOCUMENT_ID NUMBER

XML Document ID
TRANSACTION_QUANTITY NUMBER

Transaction Quantity
TRANSACTION_UOM VARCHAR2 (25) Yes Transaction Unit Of Measure
PRIMARY_QUANTITY NUMBER

Primary Quantity
PRIMARY_UOM VARCHAR2 (25) Yes Primary Unit Of Measure
SECONDARY_QUANTITY NUMBER

Secondary Quantity
SECONDARY_UOM VARCHAR2 (25)
Secondary Unit Of Measure
Query Text

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
FROM APPS.MTL_ADJ_SYNC_WRAPPER_V;

Dependencies

[top of page]

APPS.MTL_ADJ_SYNC_WRAPPER_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMTL_ADJUSTMENT_TXN_SYNC_V
APPS.MTL_ADJ_SYNC_WRAPPER_V is referenced by following:

SchemaAPPS
Package BodyINV_INVENTORY_ADJUSTMENT - show dependent code