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

Object Details

Object Name:	PSBFV_DATA_EXTRACTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSBFV_DATA_EXTRACTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

PSBFV_DATA_EXTRACTS displays the data extract information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATA_EXTRACT_NAME	VARCHAR2	(30)	Yes	Data extract name
DATA_EXTRACT_METHOD	VARCHAR2	(30)	Yes	Data extract method. Indicates if this is a new extract or a refresh of an existing extract. Values are Create and Refresh.
SET_OF_BOOKS_NAME	VARCHAR2	(30)	Yes	Set of Books name associated with data extract
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	Business group name to which data extract is confined
POSITION_STRUCTURE	VARCHAR2	(30)	Yes	Structure of position definition flexfield
POPULATE_INTERFACE_FLAG	VARCHAR2	(1)		Indicates if data extract process should populate interface tables
POPULATE_DATA_FLAG	VARCHAR2	(1)		Indicates if data extract process should load data into base tables
COPY_DEFAULTS_FLAG	VARCHAR2	(1)		Indicates if data shoud be copied from some other data extract
VALIDATE_DATA_FLAG	VARCHAR2	(1)		Indicates if the data populated into the interface tables should be validated
APPLY_DEFAULTS_FLAG	VARCHAR2	(1)		Indicates if default rules should be applied to positions
POPULATE_INTERFACE_STATUS	VARCHAR2	(1)		Indicates if population of the interface tables is complete. C indicates Complete, I or null indicates Incomplete.
POPULATE_DATA_STATUS	VARCHAR2	(1)		Indicates if population of the base tables is complete. C indicates Complete, I or null indicates Incomplete.
COPY_DEFAULTS_STATUS	VARCHAR2	(1)		Indicates if data has been copied from some other data extract. C indicates Complete, I or null indicates Incomplete.
VALIDATE_DATA_STATUS	VARCHAR2	(1)		Indicates if data in the interface tables has been validated. C indicates Complete, I or null indicates Incomplete.
APPLY_DEFAULTS_STATUS	VARCHAR2	(1)		Indicates if default rules have been applied to positions. C indicates Complete, I or null indicates Incomplete.
DATA_EXTRACT_STATUS	VARCHAR2	(1)		Status of the complete data extract process. C indicates Complete, I or null indicates Incomplete.
REQUIRED_AS_OF_DATE	DATE		Yes	Date as of which the data extracted should be valid
DATA_EXTRACT_ID	NUMBER	(20)	Yes	Data extract unique identifier
SET_OF_BOOKS_ID	NUMBER	(20)	Yes	Set of Books unique identifier
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group unique identifier
POSITION_ID_FLEX_NUM	NUMBER	(15)	Yes	Position Key Flexfield structure identifier. Flexfield structure to be used for data extract.
COPY_DATA_EXTRACT_ID	NUMBER	(20)		Unique identifier of source data extract from which data has to be copied
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT DATA_EXTRACT_NAME
,      DATA_EXTRACT_METHOD
,      SET_OF_BOOKS_NAME
,      BUSINESS_GROUP_NAME
,      POSITION_STRUCTURE
,      POPULATE_INTERFACE_FLAG
,      POPULATE_DATA_FLAG
,      COPY_DEFAULTS_FLAG
,      VALIDATE_DATA_FLAG
,      APPLY_DEFAULTS_FLAG
,      POPULATE_INTERFACE_STATUS
,      POPULATE_DATA_STATUS
,      COPY_DEFAULTS_STATUS
,      VALIDATE_DATA_STATUS
,      APPLY_DEFAULTS_STATUS
,      DATA_EXTRACT_STATUS
,      REQUIRED_AS_OF_DATE
,      DATA_EXTRACT_ID
,      SET_OF_BOOKS_ID
,      BUSINESS_GROUP_ID
,      POSITION_ID_FLEX_NUM
,      COPY_DATA_EXTRACT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PSBFV_DATA_EXTRACTS;

Dependencies

[top of page]

APPS.PSBFV_DATA_EXTRACTS references the following:

APPS: FND_ID_FLEX_STRUCTURES_VL; GL_SETS_OF_BOOKS; PER_BUSINESS_GROUPS; PSB_DATA_EXTRACTS

APPS.PSBFV_DATA_EXTRACTS is not referenced by any database object