IBE Views (59)

IBE - iStore — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`IBE_ADDRESSES_V`
`IBE_AR_CASH_RECEIPTS_V`	This view is used to get the Payment Information in Post-sales Interaciton with Customer in iStore. This view is based on ar_cash_receipts,a
`IBE_AR_PAYMENT_SCHEDULES_V`
`IBE_AR_RECEIVABLE_APPL_V`	This view is used to get the Payment Line Details in Post sales interaction with Customer in iStore.
`IBE_BIS_LIST_MSITES_V`	DBI view to get list of stores
`IBE_BI_CURRENCY_V`	This view returns the list of currencies supported by each Mini Site
`IBE_BI_MSITES_V`	DBI view to get list of stores
`IBE_BI_MSITE_DIMN_V`	DBI view to get list of stores
`IBE_CT_RELATED_ITEMS_V`
`IBE_DSP_AMV_ITEMS_V`
`IBE_DSP_ATTACHMENTS_V`
`IBE_DSP_CONTEXT_V`
`IBE_DSP_CONTEXT_VL`
`IBE_DSP_FEATURED_MEDIA_V`
`IBE_DSP_LGL_CTNT_V`
`IBE_DSP_LGL_PHYS_MAP_V`
`IBE_DSP_LGL_TEMPLATES_V`
`IBE_DSP_OBJ_LGL_CTNT_V`
`IBE_DSP_SECTIONS_VL`
`IBE_DSP_TPL_CONTEXT_V`
`IBE_DSP_TPL_CTG_V`
`IBE_DSP_TPL_ITEM_CTG_V`
`IBE_INVOICE_DETAIL_V`
`IBE_INVOICE_HEADER_V`
`IBE_MSITES_VL`
`IBE_MSITE_RESPS_VL`
`IBE_OE_CONTACTS_V`	This view is used to retrieve the Order's Billling or Shipping Contact name
`IBE_OE_ORDER_HEADERS_V`	This view is used to show the Order Summary and Order Header Detail in Post Sales Interaction with Customer. This view is based in aso_i_oe_
`IBE_OE_ORDER_LINES_V`	This view is used to get the Order Line Details. This view is based on aso_i_oe_order_headers_v and aso_i_oe_order_lines_v.
`IBE_OE_ORDER_SUMMARY_V`
`IBE_ORDER_DETAIL_V`	Stores information about details of an order line
`IBE_ORDER_HEADER_ADV_V`
`IBE_ORDER_HEADER_V`
`IBE_ORDER_ITEMS_ADV_V`
`IBE_ORDER_LINE_DTL_V`	Stores information about details of an order line
`IBE_ORDER_QUOTE_HEADERS_V`
`IBE_ORDER_QUOTE_LINE_V`
`IBE_ORDER_QUOTE_PAY_TAX_V`
`IBE_ORDER_SHIPMENTS_V`
`IBE_ORDER_SUM_V`
`IBE_PAYMENT_DETAIL_V`
`IBE_PAYMENT_HEADER_V`
`IBE_QUOTE_HEADERS_V`
`IBE_RA_CUSTOMER_TRX_LINES_V`	This view is used to get the Invoice Line Details in Post-sales interaction with Customer in iStore.
`IBE_RA_CUSTOMER_TRX_V`	This view is used to get the Invoice header details in Post sales interaction with Customer in iStore, this view is bases on ra_customrer_tr
`IBE_RETURNABLE_LINES_V`
`IBE_RETURNABLE_SERIAL_V`	Stores information about order line with the serial numbers of the ordered items
`IBE_RETURN_DETAIL_V`	Stores information about return order detail.
`IBE_RETURN_SUM_V`
`IBE_SHIPMENT_LINES_V`	This view is used to get the Shipment line information in Post sales interaction with customer in iStore. This view is based on wsh_delivery
`IBE_SHIP_DETAIL_V`
`IBE_SHIP_DLVY_DTL_V`	Store information about delivery details
`IBE_SHIP_DLVY_V`	Stores information about Delivery header
`IBE_SH_QLINES_SITEMS_V`
`IBE_SH_QUOTE_ACCESS_EMAIL_V`
`IBE_SH_QUOTE_ACCESS_V`
`IBE_SH_QUOTE_URL_V`
`IBE_SH_SHP_LIST_ITEMS_V`
`IBE_STORES_VL`