DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.QP_LOOKUPS

Object Details
Object Name: QP_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QP_LOOKUPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Oracle Pricing lookup codes


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Lookup Type
LOOKUP_CODE VARCHAR2 (30) Yes Lookup Code
MEANING VARCHAR2 (80) Yes Meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
START_DATE_ACTIVE DATE

Date from which this lookup type is active.
END_DATE_ACTIVE DATE

Date from which this lookup type becomes inactive.
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.QP_LOOKUPS;

Dependencies

[top of page]

APPS.QP_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.QP_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyAR_INVOICE_UTILS - show dependent code
Package BodyOE_CNCL_VALIDATE_HEADER_ADJ - show dependent code
Package BodyOE_CNCL_VALIDATE_LINE_ADJ - show dependent code
Package BodyOE_OE_AVAILABILITY - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
Package BodyOE_PRICE_ORDER_PVT - show dependent code
Package BodyOE_PRICE_ORDER_PVT_OBSOLETE - show dependent code
ViewOE_PRICING_CONTRACTS_V
Package BodyOE_VALIDATE_AGREEMENT - show dependent code
Package BodyOE_VALIDATE_HEADER_ADJ - show dependent code
Package BodyOE_VALIDATE_LINE_ADJ - show dependent code
Package BodyOKI_DBI_LOAD_CLEB_PVT - show dependent code
Package BodyONT_CHARGE_UTIL - show dependent code
Package BodyONT_OEXOEASR_XMLP_PKG - show dependent code
Package BodyOZF_UTILITY_PVT - show dependent code
Package BodyQP_ATM_UPGRADE - show dependent code
PL/SQL PackageQP_ATM_UPGRADE - show dependent code
Package BodyQP_BULK_VALIDATE - show dependent code
ViewQP_ENTITY_PARAMETERS_V
Package BodyQP_ID_TO_VALUE - show dependent code
Package BodyQP_LIMIT_BALANCE_CHECK_PVT - show dependent code
Package BodyQP_PARAM_UTIL - show dependent code
Package BodyQP_PRICE_BOOK_UTIL - show dependent code
ViewQP_PTE_CONTEXT_TYPES_V
Package BodyQP_PTE_UTIL - show dependent code
Package BodyQP_QP_FORM_PRICING_ATTR - show dependent code
PL/SQL PackageQP_QP_FORM_PRICING_ATTR - show dependent code
Package BodyQP_VALIDATE - show dependent code
Package BodyQP_VALIDATE_CURR_DETAILS - show dependent code
Package BodyQP_VALIDATE_CURR_LISTS - show dependent code
Package BodyQP_VALIDATE_MODIFIERS - show dependent code
Package BodyQP_VALIDATE_PLL_PRICING_ATTR - show dependent code
Package BodyQP_VALIDATE_QUALIFIERS - show dependent code
Package BodyQP_VALUE_TO_ID - show dependent code