DBA Data[Home] [Help]

VIEW: APPS.EDW_ITEM_ITEM_CAT_LCV

Source

View Text - Preformatted

SELECT category_pk, instance, all_fk, category_dp, substrb(name,1,320), substrb(description,1,240), category_set_name, category_set_id, category_id, creation_date, last_update_date, operation_code, NULL , NULL , NULL , NULL , NULL from edwbv_item_item_cat_lcv
View Text - HTML Formatted

SELECT CATEGORY_PK
, INSTANCE
, ALL_FK
, CATEGORY_DP
, SUBSTRB(NAME
, 1
, 320)
, SUBSTRB(DESCRIPTION
, 1
, 240)
, CATEGORY_SET_NAME
, CATEGORY_SET_ID
, CATEGORY_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEM_CAT_LCV