DBA Data[Home] [Help]

VIEW: MTH.MTH_ITEM_COST_I_STG#

Source

View Text - Preformatted

select DB_GLOBAL_NAME DB_GLOBAL_NAME, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE, COST COST, COST_ELEMENT COST_ELEMENT, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, FROM_DATE FROM_DATE, TO_DATE TO_DATE, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5 from "MTH"."MTH_ITEM_COST_I_STG"
View Text - HTML Formatted

SELECT DB_GLOBAL_NAME DB_GLOBAL_NAME
, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE
, COST COST
, COST_ELEMENT COST_ELEMENT
, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
FROM "MTH"."MTH_ITEM_COST_I_STG"