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 Mandatory Comments
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

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
FROM APPS.OZF_CLAIM_OFFER_UTIL_V;

Dependencies

[top of page]

APPS.OZF_CLAIM_OFFER_UTIL_V references the following:

SchemaAPPS
SynonymAMS_ACT_PRODUCTS
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymOZF_FUNDS_UTILIZED_ALL_B
SynonymOZF_OFFERS

APPS.OZF_CLAIM_OFFER_UTIL_V is not referenced by any database object