DBA Data[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: ViewONT.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
Name Datatype Length Mandatory Comments
USER_ID NUMBER

RESPONSIBILITY_ID NUMBER

HIST_CREATION_DATE DATE

HEADER_ID NUMBER

LINE_ID NUMBER

ORDER_NUMBER NUMBER
Yes
ORDER_TYPE_ID NUMBER
Yes
LINE_NUMBER NUMBER

REASON_CODE VARCHAR2 (30)
HIST_COMMENTS VARCHAR2 (2000)
HIST_TYPE_CODE VARCHAR2 (30) Yes
SOURCE_TYPE_CODE VARCHAR2 (30)
TASK_ID NUMBER

TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_CODE VARCHAR2 (50)
UNIT_LIST_PRICE NUMBER

OVER_SHIP_REASON_CODE VARCHAR2 (30)
PRICE_LIST_ID NUMBER

PRICING_QUANTITY NUMBER

PROMISE_DATE DATE

SHIP_TO_CONTACT_ID NUMBER

SHIP_TOLERANCE_ABOVE NUMBER

SHIP_FROM_ORG_ID NUMBER

SHIPPING_QUANTITY_UOM VARCHAR2 (3)
SHIPPING_METHOD_CODE VARCHAR2 (30)
SHIPMENT_NUMBER NUMBER

SCHEDULE_ARRIVAL_DATE DATE

RETURN_REASON_CODE VARCHAR2 (30)
REQUEST_DATE DATE

SHIP_SET_ID NUMBER

SHIPPING_QUANTITY NUMBER

SHIPPED_QUANTITY NUMBER

PRICING_QUANTITY_UOM VARCHAR2 (3)
OVER_SHIP_RESOLVED_FLAG VARCHAR2 (1)
ITEM_TYPE_CODE VARCHAR2 (30)
INVOICE_TO_ORG_ID NUMBER

FREIGHT_TERMS_CODE VARCHAR2 (30)
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
LINE_TYPE_ID NUMBER

CALCULATE_PRICE_FLAG VARCHAR2 (1)
TAX_DATE DATE

SHIP_TOLERANCE_BELOW NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
DELIVER_TO_CONTACT_ID NUMBER

CUSTOMER_TRX_LINE_ID NUMBER

AUTHORIZED_TO_SHIP_FLAG VARCHAR2 (1)
ACCOUNTING_RULE_ID NUMBER

DELIVER_TO_ORG_ID NUMBER

PREFERRED_GRADE VARCHAR2 (150)
ORDERED_QUANTITY_UOM2 VARCHAR2 (3)
ORDERED_QUANTITY2 NUMBER

SERVICE_REFERENCE_TYPE_CODE VARCHAR2 (30)
SERVICE_REFERENCE_SYSTEM_ID NUMBER

SERVICE_REFERENCE_LINE_ID NUMBER

FULFILLED_FLAG VARCHAR2 (1)
SCHEDULE_SHIP_DATE DATE

CREDIT_INVOICE_LINE_ID NUMBER

UNIT_SELLING_PRICE NUMBER

TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
PACKING_INSTRUCTIONS VARCHAR2 (2000)
PLANNING_PRIORITY NUMBER

FIRST_ACK_CODE VARCHAR2 (30)
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
CUST_PO_NUMBER VARCHAR2 (50)
ARRIVAL_SET_ID NUMBER

AGREEMENT_ID NUMBER

EARLIEST_ACCEPTABLE_DATE DATE

DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
DELIVERY_LEAD_TIME NUMBER

CREATED_BY NUMBER

FULFILLED_QUANTITY NUMBER

SHIP_TO_ORG_ID NUMBER

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SALESREP_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER

FOB_POINT_CODE VARCHAR2 (30)
ORDERED_QUANTITY NUMBER

LINE_CATEGORY_CODE VARCHAR2 (30)
LATEST_ACCEPTABLE_DATE DATE

ITEM_REVISION VARCHAR2 (3)
INVOICING_RULE_ID NUMBER

INVOICE_TO_CONTACT_ID NUMBER

SOLD_TO_ORG_ID NUMBER

PROJECT_ID NUMBER

PRICING_DATE DATE

PAYMENT_TERM_ID NUMBER

ORDER_QUANTITY_UOM VARCHAR2 (3)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
ORG_ID NUMBER

CREATION_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

OPTION_NUMBER NUMBER

OPTION_FLAG VARCHAR2 (1)
BOOKED_FLAG VARCHAR2 (1)
CANCELLED_FLAG VARCHAR2 (1)
OPEN_FLAG VARCHAR2 (1)
USER_ITEM_DESCRIPTION VARCHAR2 (1000)
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_LINES_AUDIT_V references the following:

SchemaAPPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_HISTORY
SynonymOE_REASONS

APPS.OE_ORDER_LINES_AUDIT_V is not referenced by any database object