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


VIEW: APPS.MTL_MFG_GENEALOGY_LOTATTR_V

Object Details
Object Name: MTL_MFG_GENEALOGY_LOTATTR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_MFG_GENEALOGY_LOTATTR_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
WIP_ENTITY_ID NUMBER
Yes Job or schedule Identifier
WIP_ENTITY_NAME VARCHAR2 (240) Yes WIP job or repetitive assembly name or flow schedule reference code
ORGANIZATION_ID NUMBER
Yes Organization Identifier
STATUS_TYPE VARCHAR2 (0)
Type of status
ITEM_NUMBER VARCHAR2 (40)
Item Number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
UOM VARCHAR2 (3)
Unit of measure
FIRM_PLANNED_FLAG VARCHAR2 (0)
Planned flag
CLASS_CODE VARCHAR2 (0)
Class code
SCHEDULED_START_DATE DATE
Yes Scheduled start date
RELEASE_DATE DATE

Release date
SCHEDULED_COMPLETION_DATE DATE
Yes Scheduled completion date
DATE_COMPLETED DATE

Completed date
DATE_CLOSED DATE

Closed date
START_QUANTITY NUMBER
Yes Stat quanity
QUANTITY_REMAINING VARCHAR2 (0)
Remaining quantity
QUANTITY_COMPLETED VARCHAR2 (40)
Completed quantity
QUANTITY_SCRAPPED VARCHAR2 (0)
Scrapped quantity
NET_QUANTITY VARCHAR2 (0)
Net quantity
COMPLETION_SUBINVENTORY VARCHAR2 (0)
Subinventory completion
JOB_TYPE VARCHAR2 (0)
Type of job
WORK_ORDER_TYPE CHAR (21)
Type of work order
LINE_TYPE NUMBER (5) Yes Type of line
Query Text

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


SELECT WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ORGANIZATION_ID
,      STATUS_TYPE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_ID
,      UOM
,      FIRM_PLANNED_FLAG
,      CLASS_CODE
,      SCHEDULED_START_DATE
,      RELEASE_DATE
,      SCHEDULED_COMPLETION_DATE
,      DATE_COMPLETED
,      DATE_CLOSED
,      START_QUANTITY
,      QUANTITY_REMAINING
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      NET_QUANTITY
,      COMPLETION_SUBINVENTORY
,      JOB_TYPE
,      WORK_ORDER_TYPE
,      LINE_TYPE
FROM APPS.MTL_MFG_GENEALOGY_LOTATTR_V;

Dependencies

[top of page]

APPS.MTL_MFG_GENEALOGY_LOTATTR_V references the following:

SchemaAPPS
SynonymGME_BATCH_HEADER
SynonymGME_MATERIAL_DETAILS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_ENTITIES
APPS.MTL_MFG_GENEALOGY_LOTATTR_V is referenced by following:

SchemaAPPS
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code