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

VIEW: APPS.MTL_MFG_LOTS_TRANS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

genealogy object ID
OBJECT_TYPE NUMBER

ORGANIZATION_ID NUMBER
Yes
TRANSACTION_DATE DATE
Yes
ORGANIZATION_CODE VARCHAR2 (3)
TRANSACTION_ID NUMBER

TRANSACTION_SOURCE_NAME VARCHAR2 (30) Yes
TRANSACTION_SOURCE VARCHAR2 (4000)
TRADING_PARTNER VARCHAR2 (0)
PROJECT VARCHAR2 (0)
TASK VARCHAR2 (0)
TRANSACTION_QUANTITY NUMBER
Yes
TRANSACTION_UOM VARCHAR2 (3) Yes
PRIMARY_QUANTITY NUMBER
Yes
CREATED_BY NUMBER
Yes
SOURCE_CODE VARCHAR2 (30)
SOURCE_LINE_ID NUMBER

TRANSACTION_TYPE_ID NUMBER
Yes
LPN_NUMBER VARCHAR2 (30)
TRANSFER_LPN_NUMBER VARCHAR2 (30)
CONTENT_LPN_NUMBER VARCHAR2 (30)
SUPPLIER_LOT_NUMBER VARCHAR2 (30)
TRANSACTION_LOT_NUMBER VARCHAR2 (0)
Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE
,      ORGANIZATION_ID
,      TRANSACTION_DATE
,      ORGANIZATION_CODE
,      TRANSACTION_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_SOURCE
,      TRADING_PARTNER
,      PROJECT
,      TASK
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      CREATED_BY
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      TRANSACTION_TYPE_ID
,      LPN_NUMBER
,      TRANSFER_LPN_NUMBER
,      CONTENT_LPN_NUMBER
,      SUPPLIER_LOT_NUMBER
,      TRANSACTION_LOT_NUMBER
FROM APPS.MTL_MFG_LOTS_TRANS_V;

Dependencies

[top of page]

APPS.MTL_MFG_LOTS_TRANS_V references the following:

SchemaAPPS
PL/SQL PackageINV_OBJECT_GENEALOGY - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_PARAMETERS
SynonymMTL_TXN_SOURCE_TYPES
SynonymWIP_ENTITIES
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.MTL_MFG_LOTS_TRANS_V is not referenced by any database object