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.IBE_ORDER_LINE_DTL_V

Object Details

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

* 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
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

Query Text

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;

Dependencies

[top of page]

APPS.IBE_ORDER_LINE_DTL_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; IBE_OE_CONTACTS_V; IBE_ORDER_UTIL_PVT - show dependent code; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE_TL; OE_AGREEMENTS_VL; OE_LOOKUPS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_PROFILE - show dependent code; OE_SHIP_METHODS_V; RA_CUSTOMER_TRX_ALL; RA_TERMS_TL

APPS.IBE_ORDER_LINE_DTL_V is not referenced by any database object