[Home] [Help] [Dependency Information]
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.OE_ORDER_LINES_RM_V is not referenced by any database object
|
|
|