View: OE_ORDER_LINES_AUDIT_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_ORDER_LINES_AUDIT_V

View Text

SELECT OLH.HIST_CREATED_BY
, OLH.RESPONSIBILITY_ID
, OLH.HIST_CREATION_DATE
, OLH.HEADER_ID
, OLH.LINE_ID
, OH.ORDER_NUMBER
, OH.ORDER_TYPE_ID
, OLH.LINE_NUMBER
, OLH.REASON_CODE REASON_CODE
, OLH.HIST_COMMENTS HIST_COMMENTS
, OLH.HIST_TYPE_CODE HIST_TYPE_CODE
, OLH.SOURCE_TYPE_CODE
, OLH.TASK_ID
, OLH.TAX_EXEMPT_FLAG
, OLH.TAX_CODE
, OLH.UNIT_LIST_PRICE
, OLH.OVER_SHIP_REASON_CODE
, OLH.PRICE_LIST_ID
, OLH.PRICING_QUANTITY
, OLH.PROMISE_DATE
, OLH.SHIP_TO_CONTACT_ID
, OLH.SHIP_TOLERANCE_ABOVE
, OLH.SHIP_FROM_ORG_ID
, OLH.SHIPPING_QUANTITY_UOM
, OLH.SHIPPING_METHOD_CODE
, OLH.SHIPMENT_NUMBER
, OLH.SCHEDULE_ARRIVAL_DATE
, OLH.RETURN_REASON_CODE
, OLH.REQUEST_DATE
, OLH.SHIP_SET_ID
, OLH.SHIPPING_QUANTITY
, OLH.SHIPPED_QUANTITY
, OLH.PRICING_QUANTITY_UOM
, OLH.OVER_SHIP_RESOLVED_FLAG
, OLH.ITEM_TYPE_CODE
, OLH.INVOICE_TO_ORG_ID
, OLH.FREIGHT_TERMS_CODE
, OLH.SHIP_MODEL_COMPLETE_FLAG
, OLH.LINE_TYPE_ID
, OLH.CALCULATE_PRICE_FLAG
, OLH.TAX_DATE
, OLH.SHIP_TOLERANCE_BELOW
, OLH.DEMAND_CLASS_CODE
, OLH.DELIVER_TO_CONTACT_ID
, OLH.CUSTOMER_TRX_LINE_ID
, OLH.AUTHORIZED_TO_SHIP_FLAG
, OLH.ACCOUNTING_RULE_ID
, OLH.DELIVER_TO_ORG_ID
, OLH.PREFERRED_GRADE
, OLH.ORDERED_QUANTITY_UOM2
, OLH.ORDERED_QUANTITY2
, OLH.SERVICE_REFERENCE_TYPE_CODE
, OLH.SERVICE_REFERENCE_SYSTEM_ID
, OLH.SERVICE_REFERENCE_LINE_ID
, OLH.FULFILLED_FLAG
, OLH.SCHEDULE_SHIP_DATE
, OLH.CREDIT_INVOICE_LINE_ID
, OLH.UNIT_SELLING_PRICE
, OLH.TAX_EXEMPT_REASON_CODE
, OLH.SHIPPING_INSTRUCTIONS
, OLH.PACKING_INSTRUCTIONS
, OLH.PLANNING_PRIORITY
, OLH.FIRST_ACK_CODE
, OLH.END_ITEM_UNIT_NUMBER
, OLH.CUST_PO_NUMBER
, OLH.ARRIVAL_SET_ID
, OLH.AGREEMENT_ID
, OLH.EARLIEST_ACCEPTABLE_DATE
, OLH.DEP_PLAN_REQUIRED_FLAG
, OLH.DELIVERY_LEAD_TIME
, OLH.CREATED_BY
, OLH.FULFILLED_QUANTITY
, OLH.SHIP_TO_ORG_ID
, OLH.SHIPMENT_PRIORITY_CODE
, OLH.SALESREP_ID
, OLH.INVENTORY_ITEM_ID
, OLH.FOB_POINT_CODE
, OLH.ORDERED_QUANTITY
, OLH.LINE_CATEGORY_CODE
, OLH.LATEST_ACCEPTABLE_DATE
, OLH.ITEM_REVISION
, OLH.INVOICING_RULE_ID
, OLH.INVOICE_TO_CONTACT_ID
, OLH.SOLD_TO_ORG_ID
, OLH.PROJECT_ID
, OLH.PRICING_DATE
, OLH.PAYMENT_TERM_ID
, OLH.ORDER_QUANTITY_UOM
, OLH.TAX_EXEMPT_NUMBER
, OLH.ORG_ID
, OLH.CREATION_DATE
, OLH.LAST_UPDATE_DATE
, OLH.LAST_UPDATED_BY
, OLH.PROGRAM_APPLICATION_ID
, OLH.PROGRAM_ID
, OLH.PROGRAM_UPDATE_DATE
, OLH.OPTION_NUMBER
, OLH.OPTION_FLAG
, OLH.BOOKED_FLAG
, OLH.CANCELLED_FLAG
, OLH.OPEN_FLAG
, OLH.USER_ITEM_DESCRIPTION
FROM OE_ORDER_LINES_HISTORY OLH
, OE_ORDER_HEADERS_ALL OH
, OE_REASONS ORE
WHERE OLH.HEADER_ID = OH.HEADER_ID
AND NVL(OLH.AUDIT_FLAG
, 'Y') = 'Y'
AND OLH.REASON_ID = ORE.REASON_ID (+) ORDER BY HIST_CREATION_DATE ASC
, REASON_CODE ASC

Columns