[Home] [Help] [Dependency Information]
Object Name: | MTL_MFG_GENEALOGY_LOTATTR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MTL_MFG_GENEALOGY_LOTATTR_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|