[Home] [Help] [Dependency Information]

VIEW: APPS.IBE_ORDER_ITEMS_ADV_V

Object Details

Object Name:	IBE_ORDER_ITEMS_ADV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBE.IBE_ORDER_ITEMS_ADV_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

Query Text

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

SELECT LINE_ID
,      HEADER_ID
,      ORDER_NUMBER
,      CUST_PO_NUMBER
,      ORDER_CATEGORY_CODE
,      LINE_CATEGORY_CODE
,      LINE_NUMBER
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      SERVICE_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      CANCELLED_QUANTITY
,      UOM_CODE
,      UOM_NAME
,      LICENSING_UNIT
,      PRICING_ATTRIBUTE10
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      ORDER_CURR_CODE
,      ORDERED_DATE
,      BOOKED_DATE
,      SCHEDULE_SHIP_DATE
,      REQUEST_DATE
,      PROMISE_DATE
,      ITEM_TYPE_CODE
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      LINE_STATUS_CODE
,      LINE_STATUS
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      SHIPPABLE_FLAG
,      PRICING_AGREEMENT_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_ACCOUNT_ID_HDR
,      BILL_TO_ACCT_SITE_ID_HDR
,      BILL_TO_ACCOUNT_ID
,      SHIP_TO_ACCOUNT_ID
,      END_CUST_ACCOUNT_ID
,      CREATED_BY
,      ORG_ID
FROM APPS.IBE_ORDER_ITEMS_ADV_V;

Dependencies

[top of page]

APPS

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

MTL_SYSTEM_ITEMS_VL

MTL_UNITS_OF_MEASURE_TL

OE_LOOKUPS

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

OE_PROFILE - show dependent code

APPS.IBE_ORDER_ITEMS_ADV_V is not referenced by any database object