[Home] [Help] [Dependency Information]

VIEW: APPS.POBV_MC_PURCHASE_ORDERS

Object Details

Object Name:	POBV_MC_PURCHASE_ORDERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_MC_PURCHASE_ORDERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows Multiple Reporting Currencies functionality, which allows an alternative currency to be specified for a purchase order based on the Set of Books.

[View Source]

Columns

Query Text

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

SELECT SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      PURCHASE_ORDER_ID
,      DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      CURRENCY_CONVERSION_RATE_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_TYPE
,      AUTO_SOURCING_FLAG
,      UPDATE_SOURCING_RULES_FLAG
,      RETRO_PRICE_APPLY_UPDATES_FLAG
,      RETRO_PRICE_COMM_UPDATES_FLAG
,      EMAIL_ADDRESS
,      FAX
,      SUPPLIER_NOTIF_METHOD
,      SUPPLIER_AUTH_ENABLED_FLAG
,      CAT_ADMIN_AUTH_ENABLED_FLAG
,      STYLE_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POBV_MC_PURCHASE_ORDERS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS

PO_HEADERS_ALL

APPS.POBV_MC_PURCHASE_ORDERS is not referenced by any database object