VIEW: APPS.OKI_LICENSES_V

Source

View Text - Preformatted

SELECT oh.order_number , cii.instance_id ,cii.system_id ,cii.instance_type_code ,cii.last_oe_po_number ,cii.last_oe_order_line_id ,ol.line_id ,ol.unit_list_price ,ol.unit_selling_price ,ol.ordered_quantity ,ol.pricing_quantity ,ol.cust_po_number ,ol.salesrep_id FROM CSI_ITEM_INSTANCES CII,OE_ORDER_LINES_ALL OL,OE_ORDER_HEADERS_ALL OH WHERE ol.line_id = cii.last_oe_order_line_id and oh.header_id = ol.header_id

View Text - HTML Formatted

SELECT OH.ORDER_NUMBER
, CII.INSTANCE_ID
, CII.SYSTEM_ID
, CII.INSTANCE_TYPE_CODE
, CII.LAST_OE_PO_NUMBER
, CII.LAST_OE_ORDER_LINE_ID
, OL.LINE_ID
, OL.UNIT_LIST_PRICE
, OL.UNIT_SELLING_PRICE
, OL.ORDERED_QUANTITY
, OL.PRICING_QUANTITY
, OL.CUST_PO_NUMBER
, OL.SALESREP_ID
FROM CSI_ITEM_INSTANCES CII
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
WHERE OL.LINE_ID = CII.LAST_OE_ORDER_LINE_ID
AND OH.HEADER_ID = OL.HEADER_ID