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

VIEW: APPS.MTL_PENDING_TXN_DETAILS_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

Genealogy object identifier
OBJECT_TYPE NUMBER

Object Type for WIP transactions
TRANSACTION_ID NUMBER

Transaction line identifier
TRANSACTION_DATE DATE

Transaction date
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ORGANIZATION_ID NUMBER

Organization identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory name
LOCATOR_ID NUMBER

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

Quantity entered at transaction time
TRANSACTION_UOM VARCHAR2 (3)
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- Used By WMS Only
CREATED_BY NUMBER

Standard Who column
SOURCE_CODE VARCHAR2 (30)
Source identifier
SOURCE_LINE_ID NUMBER

Source line identifier
TRANSACTION_TYPE_ID NUMBER

Transaction type identifier
LPN_ID NUMBER

License Plate Number Identifier - used by WMS only
TRANSFER_LPN_ID NUMBER

Transfer License Plate Number Identifier - used by WMS only
CONTENT_LPN_ID NUMBER

Content License Plate Number Identifier - used by WMS only
LPN_NUMBER VARCHAR2 (30)
License Plate Number
TRANSFER_LPN_NUMBER VARCHAR2 (30)
Transfer License Plate Number - used by WMS only
CONTENT_LPN_NUMBER VARCHAR2 (30)
Content License Plate Number - used by WMS only
ORGINAL_TRANSACTION_TEMP_ID NUMBER

Original Transaction_temp_id in mtl_material_transactions_temp
SUPPLIER_LOT_NUMBER VARCHAR2 (30)
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
,      ORGINAL_TRANSACTION_TEMP_ID
,      SUPPLIER_LOT_NUMBER
,      TRANSACTION_LOT_NUMBER
,      TRANSACTION_STATUS
FROM APPS.MTL_PENDING_TXN_DETAILS_V;

Dependencies

[top of page]

APPS.MTL_PENDING_TXN_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageINV_OBJECT_GENEALOGY - show dependent code
SynonymMTL_LOT_NUMBERS
SynonymMTL_MATERIAL_TRANSACTIONS_TEMP
SynonymMTL_PARAMETERS
SynonymMTL_SERIAL_NUMBERS
SynonymMTL_TRANSACTION_LOTS_TEMP
SynonymMTL_TXN_SOURCE_TYPES
SynonymMTL_UNIT_TRANSACTIONS
PL/SQL PackagePA_TASK_UTILS - show dependent code
ViewPJM_TASKS_V
SynonymWMS_LICENSE_PLATE_NUMBERS
APPS.MTL_PENDING_TXN_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code