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

Object Details

Object Name:	OZF_CLAIM_OFFER_UTIL_V
Object Type:	VIEW
Owner:	APPS
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
QP_LIST_HEADER_ID	NUMBER
QUALIFIER_TYPE	VARCHAR2	(0)
QUALIFIER_ID	NUMBER
OFFER_TYPE	VARCHAR2	(30)
OFFER_CODE	VARCHAR2	(30)
STATUS_CODE	VARCHAR2	(30)
PLAN_TYPE	VARCHAR2	(30)
PLAN_ID	NUMBER
ACTIVITY_PRODUCT_ID	NUMBER
PRODUCT_LEVEL_TYPE	VARCHAR2	(30)
PRODUCT_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
AMOUNT	NUMBER
ACCTD_AMOUNT	NUMBER
AMOUNT_REMAINING	NUMBER
ACCTD_AMOUNT_REMAINING	NUMBER
CHANNEL_ID	NUMBER
ADJUSTMENT_FLAG	VARCHAR2	(1)
SCAN_VALUE	NUMBER
UOM_CODE	VARCHAR2	(3)
QUANTITY	NUMBER
SCAN_UNIT	NUMBER
SCAN_UNIT_REMAINING	NUMBER
HEADER_FLAG	CHAR	(1)
CONFIDENTIAL_FLAG	VARCHAR2	(1)
USER_STATUS_ID	NUMBER
YEAR_ID	NUMBER

Query Text

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


SELECT QP_LIST_HEADER_ID
,      QUALIFIER_TYPE
,      QUALIFIER_ID
,      OFFER_TYPE
,      OFFER_CODE
,      STATUS_CODE
,      PLAN_TYPE
,      PLAN_ID
,      ACTIVITY_PRODUCT_ID
,      PRODUCT_LEVEL_TYPE
,      PRODUCT_ID
,      CURRENCY_CODE
,      AMOUNT
,      ACCTD_AMOUNT
,      AMOUNT_REMAINING
,      ACCTD_AMOUNT_REMAINING
,      CHANNEL_ID
,      ADJUSTMENT_FLAG
,      SCAN_VALUE
,      UOM_CODE
,      QUANTITY
,      SCAN_UNIT
,      SCAN_UNIT_REMAINING
,      HEADER_FLAG
,      CONFIDENTIAL_FLAG
,      USER_STATUS_ID
,      YEAR_ID
FROM APPS.OZF_CLAIM_OFFER_UTIL_V;

Dependencies

[top of page]

APPS.OZF_CLAIM_OFFER_UTIL_V references the following:

APPS: AMS_ACT_PRODUCTS; MO_GLOBAL - show dependent code; OZF_FUNDS_UTILIZED_ALL_B; OZF_OFFERS

APPS.OZF_CLAIM_OFFER_UTIL_V is not referenced by any database object