VIEW: APPS.OE_ORDER_LINES_AUDIT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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