VIEW: APPS.CSP_NOTIFICATION_DETAILS_V

Source

View Text - Preformatted

SELECT cnd.notification_Detail_id, cnd.notification_id, cnd.inventory_item_id, msik.concatenated_Segments item_Number, msik.description, cnd.available_quantity, cnd.order_by_Date, cnd.source_type, fl.meaning, cnd.source_organization_id, ood.organization_code, cnd.source_subinventory, cnd.created_by, cnd.creation_date, cnd.last_updated_by, cnd.last_update_date, cnd.last_update_login, cnd.attribute_Category, cnd.attribute1, cnd.attribute2, cnd.attribute3, cnd.attribute4, cnd.attribute5, cnd.attribute6, cnd.attribute7, cnd.attribute8, cnd.attribute9, cnd.attribute10, cnd.attribute11, cnd.attribute12, cnd.attribute13, cnd.attribute14, cnd.attribute15, cnd.repair_supplier_id, cnd.order_number from csp_notification_Details cnd, mtl_system_items_kfv msik, org_organization_definitions ood, fnd_lookups fl where ood.organization_id(+) = cnd.source_organization_id and msik.organization_id = nvl(cnd.source_organization_id,cs_std.get_item_valdn_orgzn_id) and msik.inventory_item_id = cnd.inventory_item_id and fl.lookup_code = cnd.source_type and fl.lookup_type = 'CSP_NOTIF_DTL_SRC_TYPE'

View Text - HTML Formatted

SELECT CND.NOTIFICATION_DETAIL_ID
, CND.NOTIFICATION_ID
, CND.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSIK.DESCRIPTION
, CND.AVAILABLE_QUANTITY
, CND.ORDER_BY_DATE
, CND.SOURCE_TYPE
, FL.MEANING
, CND.SOURCE_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, CND.SOURCE_SUBINVENTORY
, CND.CREATED_BY
, CND.CREATION_DATE
, CND.LAST_UPDATED_BY
, CND.LAST_UPDATE_DATE
, CND.LAST_UPDATE_LOGIN
, CND.ATTRIBUTE_CATEGORY
, CND.ATTRIBUTE1
, CND.ATTRIBUTE2
, CND.ATTRIBUTE3
, CND.ATTRIBUTE4
, CND.ATTRIBUTE5
, CND.ATTRIBUTE6
, CND.ATTRIBUTE7
, CND.ATTRIBUTE8
, CND.ATTRIBUTE9
, CND.ATTRIBUTE10
, CND.ATTRIBUTE11
, CND.ATTRIBUTE12
, CND.ATTRIBUTE13
, CND.ATTRIBUTE14
, CND.ATTRIBUTE15
, CND.REPAIR_SUPPLIER_ID
, CND.ORDER_NUMBER
FROM CSP_NOTIFICATION_DETAILS CND
, MTL_SYSTEM_ITEMS_KFV MSIK
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_LOOKUPS FL
WHERE OOD.ORGANIZATION_ID(+) = CND.SOURCE_ORGANIZATION_ID
AND MSIK.ORGANIZATION_ID = NVL(CND.SOURCE_ORGANIZATION_ID
, CS_STD.GET_ITEM_VALDN_ORGZN_ID)
AND MSIK.INVENTORY_ITEM_ID = CND.INVENTORY_ITEM_ID
AND FL.LOOKUP_CODE = CND.SOURCE_TYPE
AND FL.LOOKUP_TYPE = 'CSP_NOTIF_DTL_SRC_TYPE'