DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_ORDER_LINES_V

Object Details
Object Name: OKX_ORDER_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ORDER_LINES_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
ID1 NUMBER
Yes System Generated Line Identifier.
ID2 CHAR (1)
(Multi-part) Primary Key
NAME VARCHAR2 (0)
Name
DESCRIPTION VARCHAR2 (0)
Description
END_DATE_ACTIVE VARCHAR2 (0)
Date record becomes inactive
START_DATE_ACTIVE DATE

Date record becomes active
STATUS CHAR (1)
Status
ORG_ID NUMBER

Operating Unit which performed this transaction.
HEADER_ID NUMBER
Yes Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs.
LINE_TYPE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes Line sequence number within the order
ORDERED_ITEM VARCHAR2 (2000)
Stores name of Ordered Item
SCHEDULE_SHIP_DATE DATE

Date Scheduled to ship item
ORDER_QUANTITY_UOM VARCHAR2 (3)
Ordered quantity Unit of measure
PRICING_QUANTITY NUMBER

PRICING_QUANTITY_UOM VARCHAR2 (3)
CANCELLED_QUANTITY NUMBER

Cancelled Quantity
SHIPPED_QUANTITY NUMBER

Shipped Quantity
ORDERED_QUANTITY NUMBER

Quantity Ordered
FULFILLED_QUANTITY NUMBER

Fulfilled Quantity
SHIPPING_QUANTITY NUMBER

Shipping Quantity
SHIPPING_QUANTITY_UOM VARCHAR2 (3)
Shipping Quantity UOM
DELIVERY_LEAD_TIME NUMBER

TAX_EXEMPT_FLAG VARCHAR2 (1)
It will decide the tax handling for the order line. Possible values can be S - Standard, E - Exempt, R - Required
TAX_EXEMPT_NUMBER VARCHAR2 (80)
The Tax exemption Number
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
The reason code for Tax exemption
SHIP_FROM_ORG_ID NUMBER

Ship from organization id -warehouse
SHIP_TO_ORG_ID NUMBER

Ship to Organization Id
INVOICE_TO_ORG_ID NUMBER

Invoice To Organization ID
DELIVER_TO_ORG_ID NUMBER

Deliver to Organization Id
SHIP_TO_CONTACT_ID NUMBER

Person to which line is to be shipped
DELIVER_TO_CONTACT_ID NUMBER

Deliver to Contact Id
INVOICE_TO_CONTACT_ID NUMBER

Invoice To Contact ID
SOLD_FROM_ORG_ID NUMBER

SOLD_TO_ORG_ID NUMBER

Customer to whom the item is sold to
CUST_PO_NUMBER VARCHAR2 (50)
SHIP_TOLERANCE_ABOVE NUMBER

Over Shipment/Return Tolerance
SHIP_TOLERANCE_BELOW NUMBER

Under Shipment/Return Tolerance
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Vehicle Id Number (VIN)
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID
TAX_DATE DATE

It will store the date for tax calculation
TAX_CODE VARCHAR2 (50)
Tax code for the line
TAX_RATE NUMBER

The tax rate in percentage
INVOICE_INTERFACE_STATUS_CODE VARCHAR2 (30)
To indicate whether the invoicing activity is complete
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand Class
PRICE_LIST_ID NUMBER

Price List
PRICING_DATE DATE

SHIPMENT_NUMBER NUMBER
Yes System generated identifer of a shipment within a line
AGREEMENT_ID NUMBER

Internal use only
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Shipment Priority Code
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight carrier for the order line.
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms, specifying the responsibility for Freight charges
FOB_POINT_CODE VARCHAR2 (30)
FOB Point Code
TAX_POINT_CODE VARCHAR2 (30)
For Future release
PAYMENT_TERM_ID NUMBER (15)
Payment Terms
INVOICING_RULE_ID NUMBER (15)
Invoicing rule used by AR for generating Invoice
ACCOUNTING_RULE_ID NUMBER (15)
Accounting rule used by AR for generating Invoice
SOURCE_DOCUMENT_LINE_ID NUMBER

REFERENCE_LINE_ID NUMBER

This column stores the sales order line id this return line references
REFERENCE_TYPE VARCHAR2 (30)
This column is now obsolete
REFERENCE_HEADER_ID NUMBER

This column stores the sales order header id this return line references
ITEM_REVISION VARCHAR2 (3)
This column stores the item revision for a return line
UNIT_SELLING_PRICE NUMBER

Actual price chaged to customer
UNIT_LIST_PRICE NUMBER

Price List price for the item
TAX_VALUE NUMBER

The Tax amount in order currency
REQUEST_ID NUMBER

Concurrent request that last changed row
TOP_MODEL_LINE_ID NUMBER

System-generated identifier of configuration top parent line
LINK_TO_LINE_ID NUMBER

System-generated identifier of immediate parent component line
COMPONENT_SEQUENCE_ID NUMBER

Bill of materials component (option) or bill (top model)
COMPONENT_CODE VARCHAR2 (1000)
Identifier of component within an exploded bill
CONFIG_DISPLAY_SEQUENCE NUMBER

Not used
SORT_ORDER VARCHAR2 (2000)
Sorting sequence for a component within ordered bill
ITEM_TYPE_CODE VARCHAR2 (30)
Type of item
OPTION_NUMBER NUMBER

System generated identifer for an option or a class within a model
OPTION_FLAG VARCHAR2 (1)
Not used
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
Departure Planning Required Flag possible values Y/N
VISIBLE_DEMAND_FLAG VARCHAR2 (1)
Indicated line is visible to planning as demand
LINE_CATEGORY_CODE VARCHAR2 (30) Yes
ACTUAL_SHIPPMENT_DATE DATE

Actual Shipment Date of the line
CUSTOMER_TRX_LINE_ID NUMBER

ACTUAL_ARRIVAL_DATE DATE

Date the item actually arrived at customer's site
ATO_LINE_ID NUMBER

System-generated identifier if ATO configuration top model line
AUTO_SELECTED_QUANTITY NUMBER

Not used
COMPONENT_NUMBER NUMBER

System Generated Identifier of the included item within a model or a class
EARLIEST_ACCEPTABLE_DATE DATE

Earliest Date the item is acceptable.
EXPLOSION_DATE DATE

Date when the included items were exploded and frozen
LATEST_ACCEPTABLE_DATE DATE

Latest Date the item is acceptable.
MODEL_GROUP_NUMBER NUMBER

Not used
SCHEDULE_ARRIVAL_DATE DATE

Date Scheduled for the item to arrive at the customer site
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Indicates whether line is in ship-complete configuration
SCHEDULE_STATUS_CODE VARCHAR2 (30)
Indicates if the line is scheduled
SOURCE_TYPE_CODE VARCHAR2 (30)
Sourcing indicator (internal or external)
CANCELLED_FLAG VARCHAR2 (1)
Indicates whether line is completely cancelled
OPEN_FLAG VARCHAR2 (1) Yes Indicates whether the line has been closed ('N') or not ('Y')
BOOKED_FLAG VARCHAR2 (1) Yes Indicates whether order line is booked ('Y') or not ('N')
SALESREP_ID NUMBER (15)
Sales person identifier
RETURN_REASON_CODE VARCHAR2 (30)
This column stores return reason code for a return line, and is required for a return line
ARRIVAL_SET_ID NUMBER

SHIP_SET_ID NUMBER

Ship Set Id; if the line belongs to a ship set
SPLIT_FROM_LINE_ID NUMBER

System generated identifier of original line which was split
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (50)
AUTHORIZED_TO_SHIP_FLAG VARCHAR2 (1)
OVER_SHIP_REASON_CODE VARCHAR2 (30)
Overshipment Reason Code
OVER_SHIP_RESOLVED_FLAG VARCHAR2 (1)
Overshipment Resolved Flag
ORDERED_ITEM_ID NUMBER

Stores Id of Ordered Item
ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
To distinguish different types of items (internal, customer. and generic items)
CONFIGURATION_ID NUMBER

COMMITMENT_ID NUMBER

Commitment to apply line against
SHIPPING_INTERFACED_FLAG VARCHAR2 (1)
Shipping Interfaced Flag to indicate whether a line has been interfaced to shipping or not
CREDIT_INVOICE_LINE_ID NUMBER

This column stores the invoice line id this return line applies credit to
ORDER_SOURCE_ID NUMBER

ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
DROP_SHIP_FLAG VARCHAR2 (1)
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
CUSTOMER_SHIPMENT_NUMBER VARCHAR2 (50)
CUSTOMER_ITEM_NET_PRICE NUMBER

SHIP_REASON_CODE VARCHAR2 (30)
Overshipment Reason Code
CUSTOMER_PAYMENT_TERM_ID NUMBER

FULFILLED_FLAG VARCHAR2 (1)
Fulfilled Flag to indicate whether the line has been fulfilled.
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
CONFIG_HEADER_ID NUMBER

System-generated identifier for Oracle Configurator reference
CONFIG_REV_NBR NUMBER

System-generated identifier for Oracle Configurator reference
MFG_COMPONENT_SEQUENCE_ID NUMBER

Not used
INVOICED_QUANTITY NUMBER

To indicate whether the invoicing activity is complete
REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER

This column stores the invoice line id this return line references
SPLIT_BY VARCHAR2 (30)
LINE_SET_ID NUMBER

Line Set id
SERVICE_TXN_REASON_CODE VARCHAR2 (30)
SERVICE_TXN_COMMENT VARCHAR2 (2000)
SERVICE_DURATION NUMBER

Internal use only
SERVICE_START_DATE DATE

SERVICE_END_DATE DATE

Internal use only
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
UNIT_LIST_PERCENT NUMBER

Price list percent of the item (percent-based pricing only)
UNIT_SELLING_PERCENT NUMBER

Percent actually charged to customer (percent based pricing only)
UNIT_PERCENT_BASE_PRICE NUMBER

Based price used for percent based pricing
SERVICE_NUMBER NUMBER

SERVICE_PERIOD VARCHAR2 (3)
SHIPPABLE_FLAG VARCHAR2 (1)
A flag to indicate whether a line is shippale or not.
MODEL_REMNANT_FLAG VARCHAR2 (1)
Indicates whether model has partially shipped components
FULFILLMENT_METHOD_CODE VARCHAR2 (30)
Fulfillment Method Code
MARKETING_SOURCE_CODE_ID NUMBER

SERVICE_REFERENCE_TYPE_CODE VARCHAR2 (30)
SERVICE_REFERENCE_LINE_ID NUMBER

SERVICE_REFERENCE_SYSTEM_ID NUMBER

CALCULATE_PRICE_FLAG VARCHAR2 (1)
REVENUE_AMOUNT NUMBER

FULFILLMENT_DATE DATE

Fulfillment Date for the Line
TOTAL_AMOUNT NUMBER

FLOW_STATUS_CODE VARCHAR2 (30)
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      END_DATE_ACTIVE
,      START_DATE_ACTIVE
,      STATUS
,      ORG_ID
,      HEADER_ID
,      LINE_TYPE_ID
,      LINE_NUMBER
,      ORDERED_ITEM
,      SCHEDULE_SHIP_DATE
,      ORDER_QUANTITY_UOM
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      SHIPPED_QUANTITY
,      ORDERED_QUANTITY
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      DELIVERY_LEAD_TIME
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      SOLD_FROM_ORG_ID
,      SOLD_TO_ORG_ID
,      CUST_PO_NUMBER
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      CUST_MODEL_SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      TAX_DATE
,      TAX_CODE
,      TAX_RATE
,      INVOICE_INTERFACE_STATUS_CODE
,      DEMAND_CLASS_CODE
,      PRICE_LIST_ID
,      PRICING_DATE
,      SHIPMENT_NUMBER
,      AGREEMENT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS_CODE
,      FOB_POINT_CODE
,      TAX_POINT_CODE
,      PAYMENT_TERM_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      SOURCE_DOCUMENT_LINE_ID
,      REFERENCE_LINE_ID
,      REFERENCE_TYPE
,      REFERENCE_HEADER_ID
,      ITEM_REVISION
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      TAX_VALUE
,      REQUEST_ID
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      CONFIG_DISPLAY_SEQUENCE
,      SORT_ORDER
,      ITEM_TYPE_CODE
,      OPTION_NUMBER
,      OPTION_FLAG
,      DEP_PLAN_REQUIRED_FLAG
,      VISIBLE_DEMAND_FLAG
,      LINE_CATEGORY_CODE
,      ACTUAL_SHIPPMENT_DATE
,      CUSTOMER_TRX_LINE_ID
,      ACTUAL_ARRIVAL_DATE
,      ATO_LINE_ID
,      AUTO_SELECTED_QUANTITY
,      COMPONENT_NUMBER
,      EARLIEST_ACCEPTABLE_DATE
,      EXPLOSION_DATE
,      LATEST_ACCEPTABLE_DATE
,      MODEL_GROUP_NUMBER
,      SCHEDULE_ARRIVAL_DATE
,      SHIP_MODEL_COMPLETE_FLAG
,      SCHEDULE_STATUS_CODE
,      SOURCE_TYPE_CODE
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      SALESREP_ID
,      RETURN_REASON_CODE
,      ARRIVAL_SET_ID
,      SHIP_SET_ID
,      SPLIT_FROM_LINE_ID
,      CUST_PRODUCTION_SEQ_NUM
,      AUTHORIZED_TO_SHIP_FLAG
,      OVER_SHIP_REASON_CODE
,      OVER_SHIP_RESOLVED_FLAG
,      ORDERED_ITEM_ID
,      ITEM_IDENTIFIER_TYPE
,      CONFIGURATION_ID
,      COMMITMENT_ID
,      SHIPPING_INTERFACED_FLAG
,      CREDIT_INVOICE_LINE_ID
,      ORDER_SOURCE_ID
,      ORIG_SYS_SHIPMENT_REF
,      DROP_SHIP_FLAG
,      CUSTOMER_LINE_NUMBER
,      CUSTOMER_SHIPMENT_NUMBER
,      CUSTOMER_ITEM_NET_PRICE
,      SHIP_REASON_CODE
,      CUSTOMER_PAYMENT_TERM_ID
,      FULFILLED_FLAG
,      END_ITEM_UNIT_NUMBER
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
,      MFG_COMPONENT_SEQUENCE_ID
,      INVOICED_QUANTITY
,      REFERENCE_CUSTOMER_TRX_LINE_ID
,      SPLIT_BY
,      LINE_SET_ID
,      SERVICE_TXN_REASON_CODE
,      SERVICE_TXN_COMMENT
,      SERVICE_DURATION
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      UNIT_LIST_PERCENT
,      UNIT_SELLING_PERCENT
,      UNIT_PERCENT_BASE_PRICE
,      SERVICE_NUMBER
,      SERVICE_PERIOD
,      SHIPPABLE_FLAG
,      MODEL_REMNANT_FLAG
,      FULFILLMENT_METHOD_CODE
,      MARKETING_SOURCE_CODE_ID
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      CALCULATE_PRICE_FLAG
,      REVENUE_AMOUNT
,      FULFILLMENT_DATE
,      TOTAL_AMOUNT
,      FLOW_STATUS_CODE
FROM APPS.OKX_ORDER_LINES_V;

Dependencies

[top of page]

APPS.OKX_ORDER_LINES_V references the following:

SchemaAPPS
PL/SQL PackageASO_ORDER_INT - show dependent code
SynonymOE_ORDER_LINES_ALL
APPS.OKX_ORDER_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKC_OC_INT_CONFIG_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_CONFIG_PVT - show dependent code
PL/SQL PackageOKC_OC_INT_PUB - show dependent code
ViewOKC_REL_OBJ_ORDER_LINES_V
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
Package BodyOKS_IBINT_PUB - show dependent code
Package BodyOKS_INTEGRATION_UTIL_PUB - show dependent code
Package BodyOKS_OCINT_PUB - show dependent code
ViewOKS_ORDER_V