[Home] [Help] [Dependency Information]

VIEW: APPS.OE_ORDER_LINES_AUDIT_V

Object Details

Object Name:	OE_ORDER_LINES_AUDIT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_ORDER_LINES_AUDIT_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

APPS

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_HISTORY

OE_REASONS

APPS.OE_ORDER_LINES_AUDIT_V is not referenced by any database object