VIEW: APPS.OZF_SD_PRODUCTS_V

Source

View Text - Preformatted

SELECT REQLINES.REQUEST_HEADER_ID REQUEST_HEADER_ID, REQLINES.PRODUCT_COST PRODUCT_COST, 'Cost' COST_LABEL, REQLINES.PRODUCT_COST_CURRENCY PRODUCT_COST_CURRENCY, REQLINES.REQUESTED_DISCOUNT_TYPE REQUESTED_DISCOUNT_TYPE, REQLINES.REQUESTED_DISCOUNT_VALUE REQUESTED_DISCOUNT_VALUE, 'Requested cost' REQUEST_COST_LABEL, REQLINES.REQUESTED_DISCOUNT_CURRENCY DISCOUNT_CURRENCY, REQLINES.END_CUSTOMER_PRICE END_CUSTOMER_PRICE_VALUE, REQLINES.END_CUSTOMER_PRICE_TYPE END_CUSTOMER_PRICE_TYPE, 'Resale' RESALE_COST_LABEL, REQLINES.END_CUSTOMER_CURRENCY END_CUSTOMER_CURRENCY, REQLINES.REQUEST_LINE_ID REQUEST_LINE_ID, REQLINES.DESIGN_WIN DESIGN_WIN_NUMBER, REQLINES.ITEM_UOM UNIT_OF_MEASUREMENT, NVL(REQLINES.VENDOR_ITEM_CODE,'NA') VENDOR_PRODUCT_CODE, REQLINES.MAX_QTY MAX_QUANTITY, NVL(PROD.CONCATENATED_SEGMENTS,'NA') DIST_PRODUCT_CODE, REQLINES.PRODUCT_CONTEXT PRODUCT_LINE_TYPE, 'Product Supplier' GLB_PRT_R_CLASS_CODE, 'Manufacturer' GLB_PRT_CLASS_CODE FROM OZF_SD_REQUEST_LINES_ALL REQLINES, mtl_system_items_b_kfv PROD WHERE REQLINES.INVENTORY_ITEM_ID=PROD.INVENTORY_ITEM_ID AND REQLINES.ORG_ID=PROD.ORGANIZATION_ID UNION SELECT REQLINES.REQUEST_HEADER_ID REQUEST_HEADER_ID, REQLINES.PRODUCT_COST PRODUCT_COST, 'Cost' COST_LABEL, REQLINES.PRODUCT_COST_CURRENCY PRODUCT_COST_CURRENCY, REQLINES.REQUESTED_DISCOUNT_TYPE REQUESTED_DISCOUNT_TYPE, REQLINES.REQUESTED_DISCOUNT_VALUE REQUESTED_DISCOUNT_VALUE, 'Requested cost' REQUEST_COST_LABEL, REQLINES.REQUESTED_DISCOUNT_CURRENCY DISCOUNT_CURRENCY, REQLINES.END_CUSTOMER_PRICE END_CUSTOMER_PRICE_VALUE, REQLINES.END_CUSTOMER_PRICE_TYPE END_CUSTOMER_PRICE_TYPE, 'Resale' RESALE_COST_LABEL, REQLINES.END_CUSTOMER_CURRENCY END_CUSTOMER_CURRENCY, REQLINES.REQUEST_LINE_ID REQUEST_LINE_ID, REQLINES.DESIGN_WIN DESIGN_WIN_NUMBER, REQLINES.ITEM_UOM UNIT_OF_MEASUREMENT, NVL(REQLINES.VENDOR_ITEM_CODE,'NA') VENDOR_PRODUCT_CODE, REQLINES.MAX_QTY MAX_QUANTITY, NVL(D.category_desc,'NA') DIST_PRODUCT_CODE, REQLINES.PRODUCT_CONTEXT PRODUCT_LINE_TYPE, 'Product Supplier' GLB_PRT_R_CLASS_CODE, 'Manufacturer' GLB_PRT_CLASS_CODE FROM OZF_SD_REQUEST_LINES_ALL REQLINES, ENI_PROD_DEN_HRCHY_PARENTS_V D WHERE REQLINES.PROD_CATG_ID=D.CATEGORY_ID AND REQLINES.PRODUCT_CAT_SET_ID = D.CATEGORY_SET_ID UNION SELECT reqlines.request_header_id request_header_id, reqlines.product_cost product_cost, 'Cost' cost_label, reqlines.product_cost_currency product_cost_currency, reqlines.requested_discount_type requested_discount_type, reqlines.requested_discount_value requested_discount_value, 'Requested cost' request_cost_label, reqlines.requested_discount_currency discount_currency, reqlines.end_customer_price end_customer_price_value, reqlines.end_customer_price_type end_customer_price_type, 'Resale' resale_cost_label, reqlines.end_customer_currency end_customer_currency, reqlines.request_line_id request_line_id, reqlines.design_win design_win_number, reqlines.item_uom unit_of_measurement, nvl(reqlines.vendor_item_code, 'NA') vendor_product_code, reqlines.max_qty max_quantity, 'ALL' dist_product_code, reqlines.product_context product_line_type, 'Product Supplier' glb_prt_r_class_code, 'Manufacturer' glb_prt_class_code FROM ozf_sd_request_lines_all reqlines WHERE reqlines.product_context='ALL_ITEMS'

View Text - HTML Formatted

SELECT REQLINES.REQUEST_HEADER_ID REQUEST_HEADER_ID
, REQLINES.PRODUCT_COST PRODUCT_COST
, 'COST' COST_LABEL
, REQLINES.PRODUCT_COST_CURRENCY PRODUCT_COST_CURRENCY
, REQLINES.REQUESTED_DISCOUNT_TYPE REQUESTED_DISCOUNT_TYPE
, REQLINES.REQUESTED_DISCOUNT_VALUE REQUESTED_DISCOUNT_VALUE
, 'REQUESTED COST' REQUEST_COST_LABEL
, REQLINES.REQUESTED_DISCOUNT_CURRENCY DISCOUNT_CURRENCY
, REQLINES.END_CUSTOMER_PRICE END_CUSTOMER_PRICE_VALUE
, REQLINES.END_CUSTOMER_PRICE_TYPE END_CUSTOMER_PRICE_TYPE
, 'RESALE' RESALE_COST_LABEL
, REQLINES.END_CUSTOMER_CURRENCY END_CUSTOMER_CURRENCY
, REQLINES.REQUEST_LINE_ID REQUEST_LINE_ID
, REQLINES.DESIGN_WIN DESIGN_WIN_NUMBER
, REQLINES.ITEM_UOM UNIT_OF_MEASUREMENT
, NVL(REQLINES.VENDOR_ITEM_CODE
, 'NA') VENDOR_PRODUCT_CODE
, REQLINES.MAX_QTY MAX_QUANTITY
, NVL(PROD.CONCATENATED_SEGMENTS
, 'NA') DIST_PRODUCT_CODE
, REQLINES.PRODUCT_CONTEXT PRODUCT_LINE_TYPE
, 'PRODUCT SUPPLIER' GLB_PRT_R_CLASS_CODE
, 'MANUFACTURER' GLB_PRT_CLASS_CODE
FROM OZF_SD_REQUEST_LINES_ALL REQLINES
, MTL_SYSTEM_ITEMS_B_KFV PROD
WHERE REQLINES.INVENTORY_ITEM_ID=PROD.INVENTORY_ITEM_ID
AND REQLINES.ORG_ID=PROD.ORGANIZATION_ID UNION SELECT REQLINES.REQUEST_HEADER_ID REQUEST_HEADER_ID
, REQLINES.PRODUCT_COST PRODUCT_COST
, 'COST' COST_LABEL
, REQLINES.PRODUCT_COST_CURRENCY PRODUCT_COST_CURRENCY
, REQLINES.REQUESTED_DISCOUNT_TYPE REQUESTED_DISCOUNT_TYPE
, REQLINES.REQUESTED_DISCOUNT_VALUE REQUESTED_DISCOUNT_VALUE
, 'REQUESTED COST' REQUEST_COST_LABEL
, REQLINES.REQUESTED_DISCOUNT_CURRENCY DISCOUNT_CURRENCY
, REQLINES.END_CUSTOMER_PRICE END_CUSTOMER_PRICE_VALUE
, REQLINES.END_CUSTOMER_PRICE_TYPE END_CUSTOMER_PRICE_TYPE
, 'RESALE' RESALE_COST_LABEL
, REQLINES.END_CUSTOMER_CURRENCY END_CUSTOMER_CURRENCY
, REQLINES.REQUEST_LINE_ID REQUEST_LINE_ID
, REQLINES.DESIGN_WIN DESIGN_WIN_NUMBER
, REQLINES.ITEM_UOM UNIT_OF_MEASUREMENT
, NVL(REQLINES.VENDOR_ITEM_CODE
, 'NA') VENDOR_PRODUCT_CODE
, REQLINES.MAX_QTY MAX_QUANTITY
, NVL(D.CATEGORY_DESC
, 'NA') DIST_PRODUCT_CODE
, REQLINES.PRODUCT_CONTEXT PRODUCT_LINE_TYPE
, 'PRODUCT SUPPLIER' GLB_PRT_R_CLASS_CODE
, 'MANUFACTURER' GLB_PRT_CLASS_CODE
FROM OZF_SD_REQUEST_LINES_ALL REQLINES
, ENI_PROD_DEN_HRCHY_PARENTS_V D
WHERE REQLINES.PROD_CATG_ID=D.CATEGORY_ID
AND REQLINES.PRODUCT_CAT_SET_ID = D.CATEGORY_SET_ID UNION SELECT REQLINES.REQUEST_HEADER_ID REQUEST_HEADER_ID
, REQLINES.PRODUCT_COST PRODUCT_COST
, 'COST' COST_LABEL
, REQLINES.PRODUCT_COST_CURRENCY PRODUCT_COST_CURRENCY
, REQLINES.REQUESTED_DISCOUNT_TYPE REQUESTED_DISCOUNT_TYPE
, REQLINES.REQUESTED_DISCOUNT_VALUE REQUESTED_DISCOUNT_VALUE
, 'REQUESTED COST' REQUEST_COST_LABEL
, REQLINES.REQUESTED_DISCOUNT_CURRENCY DISCOUNT_CURRENCY
, REQLINES.END_CUSTOMER_PRICE END_CUSTOMER_PRICE_VALUE
, REQLINES.END_CUSTOMER_PRICE_TYPE END_CUSTOMER_PRICE_TYPE
, 'RESALE' RESALE_COST_LABEL
, REQLINES.END_CUSTOMER_CURRENCY END_CUSTOMER_CURRENCY
, REQLINES.REQUEST_LINE_ID REQUEST_LINE_ID
, REQLINES.DESIGN_WIN DESIGN_WIN_NUMBER
, REQLINES.ITEM_UOM UNIT_OF_MEASUREMENT
, NVL(REQLINES.VENDOR_ITEM_CODE
, 'NA') VENDOR_PRODUCT_CODE
, REQLINES.MAX_QTY MAX_QUANTITY
, 'ALL' DIST_PRODUCT_CODE
, REQLINES.PRODUCT_CONTEXT PRODUCT_LINE_TYPE
, 'PRODUCT SUPPLIER' GLB_PRT_R_CLASS_CODE
, 'MANUFACTURER' GLB_PRT_CLASS_CODE
FROM OZF_SD_REQUEST_LINES_ALL REQLINES
WHERE REQLINES.PRODUCT_CONTEXT='ALL_ITEMS'