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

Object Details

Object Name:	QP_FASS_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
ROW_ID	ROWID	(10)
PTE_SOURCESYSTEM_FNAREA_ID	NUMBER		Yes	Entity identifier
PTE_CODE	VARCHAR2	(30)	Yes	Indicates the Pricing Transaction Entity to which this Source System is attached to.
APPLICATION_SHORT_NAME	VARCHAR2	(30)	Yes	Indicates the application short name
FUNCTIONAL_AREA_ID	NUMBER		Yes	Indicates the functional area identifier
FUNCTIONAL_AREA_DESC	VARCHAR2	(80)	Yes	Functional area translated description
CATEGORY_SET_ID	NUMBER		Yes	Default Category Set identifier
CATEGORY_SET_NAME	VARCHAR2	(30)		Category set translated name
PTE_SOURCE_SYSTEM_ID	NUMBER		Yes	Indicates the PTE/Source System combination
ENABLED_FLAG	VARCHAR2	(1)		Indicates that the category set for the functional area is enabled and the pricing setups will allow category sets based on this functional area. Only categories belonging to category sets of enabeld functional areas will be sourced.
SEEDED_FLAG	VARCHAR2	(1)		Indicates if the mapping is seeded or not. Seeded flags are defauted to Y for seeded mappings and NOT for user created mappings. It is not updateable by the user.
CONTEXT	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who column

Query Text

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


SELECT ROW_ID
,      PTE_SOURCESYSTEM_FNAREA_ID
,      PTE_CODE
,      APPLICATION_SHORT_NAME
,      FUNCTIONAL_AREA_ID
,      FUNCTIONAL_AREA_DESC
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      PTE_SOURCE_SYSTEM_ID
,      ENABLED_FLAG
,      SEEDED_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM APPS.QP_FASS_V;

Dependencies

[top of page]

APPS.QP_FASS_V references the following:

APPS: MTL_DEFAULT_CATEGORY_SETS_FK_V; QP_PTE_SOURCE_SYSTEMS; QP_SOURCESYSTEM_FNAREA_MAP

APPS.QP_FASS_V is referenced by following:

APPS: QP_FNA_UTIL - show dependent code