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

VIEW: APPS.MTL_PENDING_TXNS_MFG_LOTS_V

Object Details
Object Name: MTL_PENDING_TXNS_MFG_LOTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_PENDING_TXNS_MFG_LOTS_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
OBJECT_ID NUMBER

genealogy object ID
OBJECT_TYPE NUMBER

Object Type for WIP transactions
TRANSACTION_ID NUMBER

Transaction line identifier
TRANSACTION_DATE DATE
Yes Transaction date
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ORGANIZATION_ID NUMBER
Yes Organization identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
LOCATOR_ID NUMBER

Locator identifier
TRANSACTION_SOURCE_NAME VARCHAR2 (30) Yes Transaction source type name
TRANSACTION_SOURCE VARCHAR2 (4000)
Transaction source
TRADING_PARTNER VARCHAR2 (0)
Trading Partner
PROJECT VARCHAR2 (0)
Project identifier
TASK VARCHAR2 (0)
Task identifier
TRANSACTION_QUANTITY NUMBER

Quantity entered at transaction time
TRANSACTION_UOM VARCHAR2 (3) Yes UOM used at the time of transaction
PRIMARY_QUANTITY NUMBER

Transaction quantity in terms of the primary uom of the item
SECONDARY_QUANTITY NUMBER

Secondary quantity
GRADE_CODE VARCHAR2 (150)
Grade Code
CREATED_BY NUMBER
Yes Standard Who column
SOURCE_CODE VARCHAR2 (30)
Source identifier
SOURCE_LINE_ID NUMBER

Source line identifier
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier
LPN_ID NUMBER

License Plate Number Identifier
TRANSFER_LPN_ID NUMBER

Transfer License Plate Number Identifier
CONTENT_LPN_ID NUMBER

Content License Plate Number Identifier
LPN_NUMBER VARCHAR2 (30)
License Plate Number
TRANSFER_LPN_NUMBER VARCHAR2 (30)
Transfer License Plate Number
CONTENT_LPN_NUMBER VARCHAR2 (30)
Content License Plate Number
SUPPLIER_LOT_NUMBER VARCHAR2 (80)
Source lot number
TRANSACTION_LOT_NUMBER VARCHAR2 (80)
Transaction lot number
TRANSACTION_STATUS NUMBER

Indicates if it has to be processed or just saved. NULL or 1 is default behavior. 2 is save only. 3 is ready to process
Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE
,      TRANSACTION_ID
,      TRANSACTION_DATE
,      ORGANIZATION_CODE
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_SOURCE_NAME
,      TRANSACTION_SOURCE
,      TRADING_PARTNER
,      PROJECT
,      TASK
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      SECONDARY_QUANTITY
,      GRADE_CODE
,      CREATED_BY
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      TRANSACTION_TYPE_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      CONTENT_LPN_ID
,      LPN_NUMBER
,      TRANSFER_LPN_NUMBER
,      CONTENT_LPN_NUMBER
,      SUPPLIER_LOT_NUMBER
,      TRANSACTION_LOT_NUMBER
,      TRANSACTION_STATUS
FROM APPS.MTL_PENDING_TXNS_MFG_LOTS_V;

Dependencies

[top of page]

APPS.MTL_PENDING_TXNS_MFG_LOTS_V references the following:

SchemaAPPS
PL/SQL PackageINV_OBJECT_GENEALOGY - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymMTL_TXN_SOURCE_TYPES
SynonymWIP_ENTITIES
SynonymWMS_LICENSE_PLATE_NUMBERS
APPS.MTL_PENDING_TXNS_MFG_LOTS_V is referenced by following:

SchemaAPPS
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code