VIEW: APPS.EDW_ITEM_ONETIME_ITEM_LCV

Source

View Text - Preformatted

SELECT substrb(l.ITEM_DESCRIPTION || '-' || cat.category_id || '-' || l.org_id ,1,1000) item_number_pk, null INSTANCE , cat.category_id catset_category_fk , 'NA_EDW' PRODUCT_GROUP_FK , substrb(l.ITEM_DESCRIPTION || '(' || cat.CONCATENATED_SEGMENTS|| ')',1,240) ITEM_NUMBER_DP , substrb(l.ITEM_DESCRIPTION || '(' || cat.CONCATENATED_SEGMENTS|| ')',1,320) NAME , ' Y' ONE_TIME_FLAG , substrb(l.item_description,1,240) DESCRIPTION , NVL(substrb(l.item_description,1,240),'NA_EDW') ITEM_NAME , min(l.creation_date) , max(l.last_update_date) , NULL , NULL , NULL , NULL , NULL , NULL From mtl_categories_kfv cat, po_lines_all l WHERE cat.category_id = l.category_id and l.item_id is null Group by l.ITEM_DESCRIPTION, l.org_id, cat.category_id, cat.concatenated_segments WITH READ ONLY

View Text - HTML Formatted

SELECT SUBSTRB(L.ITEM_DESCRIPTION || '-' || CAT.CATEGORY_ID || '-' || L.ORG_ID
, 1
, 1000) ITEM_NUMBER_PK
, NULL INSTANCE
, CAT.CATEGORY_ID CATSET_CATEGORY_FK
, 'NA_EDW' PRODUCT_GROUP_FK
, SUBSTRB(L.ITEM_DESCRIPTION || '(' || CAT.CONCATENATED_SEGMENTS|| ')'
, 1
, 240) ITEM_NUMBER_DP
, SUBSTRB(L.ITEM_DESCRIPTION || '(' || CAT.CONCATENATED_SEGMENTS|| ')'
, 1
, 320) NAME
, ' Y' ONE_TIME_FLAG
, SUBSTRB(L.ITEM_DESCRIPTION
, 1
, 240) DESCRIPTION
, NVL(SUBSTRB(L.ITEM_DESCRIPTION
, 1
, 240)
, 'NA_EDW') ITEM_NAME
, MIN(L.CREATION_DATE)
, MAX(L.LAST_UPDATE_DATE)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_CATEGORIES_KFV CAT
, PO_LINES_ALL L
WHERE CAT.CATEGORY_ID = L.CATEGORY_ID
AND L.ITEM_ID IS NULL GROUP BY L.ITEM_DESCRIPTION
, L.ORG_ID
, CAT.CATEGORY_ID
, CAT.CONCATENATED_SEGMENTS WITH READ ONLY