VIEW: APPS.EDW_POA_SPIM_SPLRITEM_LCV

Source

View Text - Preformatted

SELECT supplier_item_pk, all_fk, supplier_site_item_dp, supplier_item_dp, name, supplier_site_code, supplier_name, instance, max(creation_date), max(last_update_date), user_attribute1, user_attribute2, user_attribute3, user_attribute4, user_attribute5 FROM (SELECT pov.vendor_name || '-' || pvs.vendor_site_code || '-' || pol.vendor_product_num supplier_item_pk, 'ALL' all_fk, pov.vendor_name || '-' || pvs.vendor_site_code || '-' || pol.vendor_product_num supplier_site_item_dp, pov.vendor_name || '-' || pol.vendor_product_num supplier_item_dp, pol.vendor_product_num name, pvs.vendor_site_code supplier_site_code, pov.vendor_name supplier_name, inst.instance_code instance, pol.creation_date creation_date, greatest(pvs.last_update_date, pov.last_update_date, pol.last_update_date) last_update_date, NULL user_attribute1, NULL user_attribute2, NULL user_attribute3, NULL user_attribute4, NULL user_attribute5 FROM po_headers_all poh, po_vendors pov, po_lines_all pol, po_vendor_sites_all pvs, edw_local_instance inst WHERE pol.vendor_product_num is NOT NULL AND pol.po_header_id = poh.po_header_id AND pov.vendor_id = poh.vendor_id AND pvs.vendor_id = pov.vendor_id) group by supplier_item_pk, all_fk, supplier_site_item_dp, supplier_item_dp, name, supplier_site_code, supplier_name, instance, user_attribute1, user_attribute2, user_attribute3, user_attribute4, user_attribute5

View Text - HTML Formatted

SELECT SUPPLIER_ITEM_PK
, ALL_FK
, SUPPLIER_SITE_ITEM_DP
, SUPPLIER_ITEM_DP
, NAME
, SUPPLIER_SITE_CODE
, SUPPLIER_NAME
, INSTANCE
, MAX(CREATION_DATE)
, MAX(LAST_UPDATE_DATE)
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM (SELECT POV.VENDOR_NAME || '-' || PVS.VENDOR_SITE_CODE || '-' || POL.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_PK
, 'ALL' ALL_FK
, POV.VENDOR_NAME || '-' || PVS.VENDOR_SITE_CODE || '-' || POL.VENDOR_PRODUCT_NUM SUPPLIER_SITE_ITEM_DP
, POV.VENDOR_NAME || '-' || POL.VENDOR_PRODUCT_NUM SUPPLIER_ITEM_DP
, POL.VENDOR_PRODUCT_NUM NAME
, PVS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, POV.VENDOR_NAME SUPPLIER_NAME
, INST.INSTANCE_CODE INSTANCE
, POL.CREATION_DATE CREATION_DATE
, GREATEST(PVS.LAST_UPDATE_DATE
, POV.LAST_UPDATE_DATE
, POL.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM PO_HEADERS_ALL POH
, PO_VENDORS POV
, PO_LINES_ALL POL
, PO_VENDOR_SITES_ALL PVS
, EDW_LOCAL_INSTANCE INST
WHERE POL.VENDOR_PRODUCT_NUM IS NOT NULL
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_ID = POV.VENDOR_ID) GROUP BY SUPPLIER_ITEM_PK
, ALL_FK
, SUPPLIER_SITE_ITEM_DP
, SUPPLIER_ITEM_DP
, NAME
, SUPPLIER_SITE_CODE
, SUPPLIER_NAME
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5