[Home] [Help] [Dependency Information]
Object Name: | IBE_ORDER_LINE_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBE.IBE_ORDER_LINE_DTL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Order Header Identifier | |
LINE_ID | NUMBER | Yes | Order System Generated Line Identifier. | |
ORDER_NUMBER | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | Yes | Line sequence number within the order | |
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 | ||
ITEM_NUMBER | VARCHAR2 | (40) | Part number of the item | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Product Description | |
PRODUCT_DESCRIPTION | VARCHAR2 | (240) | Descriptive flexfield attribute | |
LICENSING_UNIT | VARCHAR2 | (40) | Flex field | |
PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | ||
ITEM_TYPE_CODE | VARCHAR2 | (30) | Type of item. Ex: standard | |
ORDERED_QUANTITY | NUMBER | Quantity ordered | ||
SHIPPED_QUANTITY | NUMBER | Shipped Quantity | ||
CANCELLED_QUANTITY | NUMBER | Cancelled Quantity | ||
FULFILLED_QUANTITY | NUMBER | Fulfilled Quantity | ||
ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Order quantity Unit of measure | |
UOM_DESC | VARCHAR2 | (25) | Yes | Translation for Return order quantity Unit of measure |
UNIT_LIST_PRICE | NUMBER | List price for the item | ||
UNIT_SELLING_PRICE | NUMBER | Actual price charged to customer | ||
REQUEST_DATE | DATE | Ordered Item Request date | ||
PROMISE_DATE | DATE | Date promised to customer to receive item | ||
SCHEDULE_SHIP_DATE | DATE | Date Scheduled to ship item | ||
FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status for the line | |
LINE_STATUS | VARCHAR2 | (80) | Meaning for Workflow status for the line from oe_lookups | |
SHIPMENT_NUMBER | NUMBER | Yes | System generated identifier of a shipment within a line | |
OPTION_NUMBER | NUMBER | System generated identifier for an option or a class within a model | ||
COMPONENT_NUMBER | NUMBER | System Generated Identifier of the included item within a model or a class | ||
SERVICE_NUMBER | NUMBER | Unique number to identify the service lines | ||
REQ_SHIP_METHOD_CODE | VARCHAR2 | (30) | Initial ship method code from order line | |
REQ_SHIP_METHOD_DESC | VARCHAR2 | (80) | Initial ship method meaning from order line | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight Terms code, specifying the responsibility for Freight charges | |
FREIGHT_TERMS_DESC | VARCHAR2 | (80) | Freight Terms meaning,to be displayed in the UI | |
AGREEMENT_ID | NUMBER | Agreement Id for the order line | ||
AGREEMENT_NAME | VARCHAR2 | (240) | Agreement Name | |
FULL_AGREEMENT_NAME | VARCHAR2 | (345) | Full agreement name | |
PAYMENT_TERM_ID | NUMBER | (15) | Payment Terms identifier | |
PAYMENT_TERMS | VARCHAR2 | (15) | Payment Terms Meaning | |
CUST_ACCOUNT_ID | NUMBER | |||
PARTY_ID | NUMBER | (15) | Yes | |
CUSTOMER_NAME | VARCHAR2 | (360) | Yes | |
SOLD_TO_CONTACT_ID | NUMBER | |||
SOLD_TO_CONTACT_NAME | VARCHAR2 | (301) | ||
SOLD_TO_CONTACT_PHONE_EMAIL | VARCHAR2 | (4000) | ||
BILL_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
BILL_TO_CUSTOMER | VARCHAR2 | (360) | Bill to customer name | |
BILL_TO_CUST_ACCOUNT_ID | NUMBER | (15) | Cust account ID of bill to customer | |
BILL_TO_CONTACT_ID | NUMBER | Invoice to contact id | ||
BILL_TO_CONTACT | VARCHAR2 | (301) | Invoice to contact party name | |
BILL_TO_LOCATION | VARCHAR2 | (121) | Invoice to city and state as location | |
BILL_TO_ADDRESS1 | VARCHAR2 | (240) | First line for address | |
BILL_TO_ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
BILL_TO_ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
BILL_TO_ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
BILL_TO_ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | Phonetic or Kana representation of the Kanji address lines (used in Japan) | |
BILL_TO_CITY | VARCHAR2 | (60) | City | |
BILL_TO_STATE | VARCHAR2 | (60) | State | |
BILL_TO_POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
BILL_TO_COUNTY | VARCHAR2 | (60) | County | |
BILL_TO_PROVINCE | VARCHAR2 | (60) | Province | |
BILL_TO_COUNTRY | VARCHAR2 | (60) | Country code from the TERRITORY_CODE column in the FND_TERRITORY table | |
BILL_TO_COUNTRY_CODE | VARCHAR2 | (0) | Null - not populated | |
SHIP_TO_ORG_ID | NUMBER | ShipTo Organization ID | ||
SHIP_TO_CUSTOMER | VARCHAR2 | (360) | Ship to customer name | |
SHIP_TO_CUST_ACCOUNT_ID | NUMBER | (15) | Cust account ID of ship to customer | |
SHIP_TO_CONTACT_ID | NUMBER | Ship to contact id | ||
SHIP_TO_CONTACT | VARCHAR2 | (301) | Ship to contact party name | |
SHIP_TO_LOCATION | VARCHAR2 | (121) | Ship to city and state as location | |
SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | First line for address | |
SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
SHIP_TO_ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | Phonetic or Kana representation of the Kanji address lines (used in Japan) | |
SHIP_TO_CITY | VARCHAR2 | (60) | City | |
SHIP_TO_STATE | VARCHAR2 | (60) | State | |
SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Postal Code | |
SHIP_TO_COUNTY | VARCHAR2 | (60) | County | |
SHIP_TO_PROVINCE | VARCHAR2 | (60) | Province | |
SHIP_TO_COUNTRY | VARCHAR2 | (60) | Country code from the TERRITORY_CODE column in the FND_TERRITORY table | |
SHIP_TO_COUNTRY_CODE | VARCHAR2 | (0) | Null - not populated | |
END_CUSTOMER_ID | NUMBER | |||
END_CUSTOMER_NAME | VARCHAR2 | (360) | ||
END_CUSTOMER_CONTACT_ID | NUMBER | |||
ENDCUST_CONTACT_NAME | VARCHAR2 | (301) | ||
ENDCUST_LOCATION | VARCHAR2 | (121) | ||
ENDCUST_ADDRESS1 | VARCHAR2 | (240) | ||
ENDCUST_ADDRESS2 | VARCHAR2 | (240) | ||
ENDCUST_ADDRESS3 | VARCHAR2 | (240) | ||
ENDCUST_ADDRESS4 | VARCHAR2 | (240) | ||
ENDCUST_ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | ||
ENDCUST_CITY | VARCHAR2 | (60) | ||
ENDCUST_STATE | VARCHAR2 | (60) | ||
ENDCUST_POSTAL_CODE | VARCHAR2 | (60) | ||
ENDCUST_COUNTY | VARCHAR2 | (60) | ||
ENDCUST_PROVINCE | VARCHAR2 | (60) | ||
ENDCUST_COUNTRY | VARCHAR2 | (60) | ||
SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping Instructions for Line | |
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions for Line | |
COMMITMENT_ID | NUMBER | Commitment id to apply line against | ||
COMMITMENT_NAME | VARCHAR2 | (20) | Commitment meaning to show in the UI | |
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase Order Number | |
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | ||
SHIPMENT_PRIORITY_CODE_MNG | VARCHAR2 | (80) | ||
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) | ||
ORG_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, LINE_ID
, ORDER_NUMBER
, LINE_NUMBER
, TOP_MODEL_LINE_ID
, LINK_TO_LINE_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, PRODUCT_DESCRIPTION
, LICENSING_UNIT
, PRICING_ATTRIBUTE10
, ITEM_TYPE_CODE
, ORDERED_QUANTITY
, SHIPPED_QUANTITY
, CANCELLED_QUANTITY
, FULFILLED_QUANTITY
, ORDER_QUANTITY_UOM
, UOM_DESC
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, REQUEST_DATE
, PROMISE_DATE
, SCHEDULE_SHIP_DATE
, FLOW_STATUS_CODE
, LINE_STATUS
, SHIPMENT_NUMBER
, OPTION_NUMBER
, COMPONENT_NUMBER
, SERVICE_NUMBER
, REQ_SHIP_METHOD_CODE
, REQ_SHIP_METHOD_DESC
, FREIGHT_TERMS_CODE
, FREIGHT_TERMS_DESC
, AGREEMENT_ID
, AGREEMENT_NAME
, FULL_AGREEMENT_NAME
, PAYMENT_TERM_ID
, PAYMENT_TERMS
, CUST_ACCOUNT_ID
, PARTY_ID
, CUSTOMER_NAME
, SOLD_TO_CONTACT_ID
, SOLD_TO_CONTACT_NAME
, SOLD_TO_CONTACT_PHONE_EMAIL
, BILL_TO_ORG_ID
, BILL_TO_CUSTOMER
, BILL_TO_CUST_ACCOUNT_ID
, BILL_TO_CONTACT_ID
, BILL_TO_CONTACT
, BILL_TO_LOCATION
, BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4
, BILL_TO_ADDRESS_LINES_PHONETIC
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTY
, BILL_TO_PROVINCE
, BILL_TO_COUNTRY
, BILL_TO_COUNTRY_CODE
, SHIP_TO_ORG_ID
, SHIP_TO_CUSTOMER
, SHIP_TO_CUST_ACCOUNT_ID
, SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT
, SHIP_TO_LOCATION
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_ADDRESS_LINES_PHONETIC
, SHIP_TO_CITY
, SHIP_TO_STATE
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTY
, SHIP_TO_PROVINCE
, SHIP_TO_COUNTRY
, SHIP_TO_COUNTRY_CODE
, END_CUSTOMER_ID
, END_CUSTOMER_NAME
, END_CUSTOMER_CONTACT_ID
, ENDCUST_CONTACT_NAME
, ENDCUST_LOCATION
, ENDCUST_ADDRESS1
, ENDCUST_ADDRESS2
, ENDCUST_ADDRESS3
, ENDCUST_ADDRESS4
, ENDCUST_ADDRESS_LINES_PHONETIC
, ENDCUST_CITY
, ENDCUST_STATE
, ENDCUST_POSTAL_CODE
, ENDCUST_COUNTY
, ENDCUST_PROVINCE
, ENDCUST_COUNTRY
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, COMMITMENT_ID
, COMMITMENT_NAME
, CUST_PO_NUMBER
, SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY_CODE_MNG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM APPS.IBE_ORDER_LINE_DTL_V;
APPS.IBE_ORDER_LINE_DTL_V is not referenced by any database object
|
|
|