[Home] [Help] [Dependency Information]
Object Name: | EGO_GTIN_TP_ATTRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EGO.EGO_GTIN_TP_ATTRS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B | ||
ORGANIZATION_ID | NUMBER | Organization identifier.Foreign key to MTL_SYSTEM_ITEMS_B | ||
GLOBAL_TRADE_ITEM_NUMBER | VARCHAR2 | (14) | Yes | Global Trade Item Number |
GLOBAL_LOCATION_NUMBER | VARCHAR2 | (13) | Global Location Number | |
IS_TRADE_ITEM_AN_ORD_UNIT | NUMBER | Is item ordereable | ||
PUBLICATION_DATE | DATE | Publication Date | ||
END_AVAILABILITY_DATE_TIME | DATE | Date when item is no longer available | ||
START_AVAILABILITY_DATE_TIME | DATE | Date when item is available | ||
IS_TRADE_ITEM_A_DESPATCH_UNIT | NUMBER | Is the item a despatch unit | ||
IS_TRADE_ITEM_AN_INVOICE_UNIT | NUMBER | Is the item an invoice unit | ||
MIN_TRADE_ITEM_LIFE_ARR | NUMBER | Minimum life of item from time of arrival | ||
ORDER_QUANTITY_MAX | NUMBER | Maximum Order Quantity | ||
ORDER_QUANTITY_MIN | NUMBER | Minimum Order Quantity | ||
BATCH_ID | NUMBER | Yes | Unique identifier of the batch in which event is processed | |
SUBBATCH_ID | NUMBER | Unique identifier of sub-batch within the batch |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, GLOBAL_TRADE_ITEM_NUMBER
, GLOBAL_LOCATION_NUMBER
, IS_TRADE_ITEM_AN_ORD_UNIT
, PUBLICATION_DATE
, END_AVAILABILITY_DATE_TIME
, START_AVAILABILITY_DATE_TIME
, IS_TRADE_ITEM_A_DESPATCH_UNIT
, IS_TRADE_ITEM_AN_INVOICE_UNIT
, MIN_TRADE_ITEM_LIFE_ARR
, ORDER_QUANTITY_MAX
, ORDER_QUANTITY_MIN
, BATCH_ID
, SUBBATCH_ID
FROM APPS.EGO_GTIN_TP_ATTRS_V;
APPS.EGO_GTIN_TP_ATTRS_V is not referenced by any database object
|
|
|