eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OE_ORDER_LINES_RM_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
LINE_ID	NUMBER		Yes
HEADER_ID	NUMBER		Yes
DOCUMENT_TYPE_CODE	CHAR	(11)
ORG_ID	NUMBER
LINE_NUMBER	NUMBER		Yes
LINE_TYPE	VARCHAR2	(30)	Yes
FLOW_STATUS_CODE	VARCHAR2	(30)
INVENTORY_ITEM_ID	NUMBER		Yes
ORDERED_ITEM	VARCHAR2	(2000)
ORDER_QUANTITY_UOM	VARCHAR2	(3)
ORDERED_QUANTITY	NUMBER
UNIT_SELLING_PRICE	NUMBER
UNIT_LIST_PRICE	NUMBER
UNIT_SELLING_PERCENT	NUMBER
UNIT_LIST_PERCENT	NUMBER
UNIT_PERCENT_BASE_PRICE	NUMBER
LINE_AMOUNT	NUMBER
SCHEDULE_SHIP_DATE	DATE
CANCELLED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
FULFILLED_QUANTITY	NUMBER
SHIPPING_QUANTITY	NUMBER
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)
INVOICABLE_FLAG	VARCHAR2	(0)
SHIPPABLE_FLAG	VARCHAR2	(0)
SHIPPED_FLAG	VARCHAR2	(1)
INVOICED_FLAG	VARCHAR2	(1)
DELIVERY_LEAD_TIME	NUMBER
INVOICE_TO_ORG_ID	NUMBER
CUST_PO_NUMBER	VARCHAR2	(50)
PROJECT_ID	NUMBER
TASK_ID	NUMBER
INVOICE_INTERFACE_STATUS_CODE	VARCHAR2	(30)
FULFILLED_FLAG	VARCHAR2	(1)
CANCELLED_FLAG	VARCHAR2	(1)
SHIPMENT_NUMBER	NUMBER		Yes
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIPPING_METHOD_CODE	VARCHAR2	(30)
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
FOB_POINT_CODE	VARCHAR2	(30)
PAYMENT_TERM_ID	NUMBER	(15)
ACCOUNTING_RULE_ID	NUMBER	(15)
SOURCE_DOCUMENT_TYPE_ID	NUMBER
ORIG_SYS_DOCUMENT_REF	VARCHAR2	(50)
SOURCE_DOCUMENT_ID	NUMBER
ORIG_SYS_LINE_REF	VARCHAR2	(50)
SOURCE_DOCUMENT_LINE_ID	NUMBER
REFERENCE_LINE_ID	NUMBER
REFERENCE_HEADER_ID	NUMBER
ACTUAL_SHIPMENT_DATE	DATE
ACTUAL_ARRIVAL_DATE	DATE
EARLIEST_ACCEPTABLE_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
SCHEDULE_ARRIVAL_DATE	DATE
SCHEDULE_STATUS_CODE	VARCHAR2	(30)
RETURN_REASON_CODE	VARCHAR2	(30)
SHIPPING_INTERFACED_FLAG	VARCHAR2	(1)
CREDIT_INVOICE_LINE_ID	NUMBER
ORIG_SYS_SHIPMENT_REF	VARCHAR2	(50)
INVOICED_QUANTITY	NUMBER
REFERENCE_CUSTOMER_TRX_LINE_ID	NUMBER
FULFILLMENT_DATE	DATE
ACCOUNTING_RULE_DURATION	NUMBER	(15)
END_CUSTOMER_ID	NUMBER
END_CUSTOMER_CONTACT_ID	NUMBER
END_CUSTOMER_SITE_USE_ID	NUMBER
SERVICE_CREDIT_ELIGIBLE_CODE	VARCHAR2	(30)
ACTUAL_FULFILLMENT_DATE	DATE
CONTINGENCY_ID	NUMBER
REVREC_EVENT_CODE	VARCHAR2	(30)
REVREC_EXPIRATION_DAYS	NUMBER
SALESREP_ID	NUMBER	(15)
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
TOP_MODEL_LINE_ID	NUMBER
LINK_TO_LINE_ID	NUMBER
COMPONENT_NUMBER	NUMBER
OPTION_NUMBER	NUMBER
ATO_LINE_ID	NUMBER
COMPONENT_CODE	VARCHAR2	(1000)
PRICE_LIST	VARCHAR2	(240)
PRICE_LIST_ID	NUMBER
DEMAND_CLASS_CODE	VARCHAR2	(30)
BLANKET_NUMBER	NUMBER
SHIP_FROM_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
CONTEXT	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE16	VARCHAR2	(240)
ATTRIBUTE17	VARCHAR2	(240)
ATTRIBUTE18	VARCHAR2	(240)
ATTRIBUTE19	VARCHAR2	(240)
ATTRIBUTE20	VARCHAR2	(240)
OPEN_FLAG	VARCHAR2	(1)	Yes
RULE_START_DATE	DATE
RULE_END_DATE	DATE
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes
REVENUE_REVERSAL_METHOD	VARCHAR2	(30)
LAST_PERIOD_TO_CREDIT	VARCHAR2	(0)

Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      DOCUMENT_TYPE_CODE
,      ORG_ID
,      LINE_NUMBER
,      LINE_TYPE
,      FLOW_STATUS_CODE
,      INVENTORY_ITEM_ID
,      ORDERED_ITEM
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PERCENT
,      UNIT_LIST_PERCENT
,      UNIT_PERCENT_BASE_PRICE
,      LINE_AMOUNT
,      SCHEDULE_SHIP_DATE
,      CANCELLED_QUANTITY
,      SHIPPED_QUANTITY
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      INVOICABLE_FLAG
,      SHIPPABLE_FLAG
,      SHIPPED_FLAG
,      INVOICED_FLAG
,      DELIVERY_LEAD_TIME
,      INVOICE_TO_ORG_ID
,      CUST_PO_NUMBER
,      PROJECT_ID
,      TASK_ID
,      INVOICE_INTERFACE_STATUS_CODE
,      FULFILLED_FLAG
,      CANCELLED_FLAG
,      SHIPMENT_NUMBER
,      SHIPMENT_PRIORITY_CODE
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS_CODE
,      FOB_POINT_CODE
,      PAYMENT_TERM_ID
,      ACCOUNTING_RULE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SOURCE_DOCUMENT_ID
,      ORIG_SYS_LINE_REF
,      SOURCE_DOCUMENT_LINE_ID
,      REFERENCE_LINE_ID
,      REFERENCE_HEADER_ID
,      ACTUAL_SHIPMENT_DATE
,      ACTUAL_ARRIVAL_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      SCHEDULE_ARRIVAL_DATE
,      SCHEDULE_STATUS_CODE
,      RETURN_REASON_CODE
,      SHIPPING_INTERFACED_FLAG
,      CREDIT_INVOICE_LINE_ID
,      ORIG_SYS_SHIPMENT_REF
,      INVOICED_QUANTITY
,      REFERENCE_CUSTOMER_TRX_LINE_ID
,      FULFILLMENT_DATE
,      ACCOUNTING_RULE_DURATION
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      SERVICE_CREDIT_ELIGIBLE_CODE
,      ACTUAL_FULFILLMENT_DATE
,      CONTINGENCY_ID
,      REVREC_EVENT_CODE
,      REVREC_EXPIRATION_DAYS
,      SALESREP_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      COMPONENT_NUMBER
,      OPTION_NUMBER
,      ATO_LINE_ID
,      COMPONENT_CODE
,      PRICE_LIST
,      PRICE_LIST_ID
,      DEMAND_CLASS_CODE
,      BLANKET_NUMBER
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OPEN_FLAG
,      RULE_START_DATE
,      RULE_END_DATE
,      LINE_CATEGORY_CODE
,      REVENUE_REVERSAL_METHOD
,      LAST_PERIOD_TO_CREDIT
FROM APPS.OE_ORDER_LINES_RM_V;

Dependencies

[top of page]

APPS.OE_ORDER_LINES_RM_V references the following:

APPS: FND_LANGUAGES; OE_ORDER_LINES_ALL; OE_TRANSACTION_TYPES_ALL; OE_TRANSACTION_TYPES_TL; QP_LIST_HEADERS_TL

APPS.OE_ORDER_LINES_RM_V is not referenced by any database object