DBA Data[Home] [Help]

VIEW: APPS.EDW_ITEM_ITEM_ORG_CAT_LCV

Source

View Text - Preformatted

SELECT category_pk, substrb(instance,1,30), 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_org_cat_lcv
View Text - HTML Formatted

SELECT CATEGORY_PK
, SUBSTRB(INSTANCE
, 1
, 30)
, 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_ORG_CAT_LCV