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

VIEW: APPS.CSTFV_PAC_PERIODS

Object Details
Object Name: CSTFV_PAC_PERIODS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CSTFV_PAC_PERIODS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about periodic costing open and closed periods for each legal entity and cost groups combination.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PAC_PERIOD_ID NUMBER
Yes Periodic Costing Period Identifier
PERIOD_SET_NAME VARCHAR2 (15) Yes Calendar associated with Set of books
PERIOD_START_DATE DATE
Yes Period Start Date
PERIOD_END_DATE DATE
Yes Period End date
OPEN_FLAG VARCHAR2 (1) Yes Flag to denote whether period is in open, close or error status
PERIOD_YEAR NUMBER
Yes Period Year
PERIOD_NUM NUMBER
Yes Period Number
PERIOD_NAME VARCHAR2 (15) Yes Period Name
PERIOD_CLOSE_DATE DATE

Period Close date
LEGAL_ENTITY_NAME VARCHAR2 (240) Yes Legal Entity Name
COST_TYPE_NAME VARCHAR2 (10) Yes Cost Type Name
LEGAL_ENTITY NUMBER (15) Yes Legal Entity Identifier
COST_TYPE_ID NUMBER
Yes Cost type identifier
CREATION_DATE DATE
Yes Creation date
CREATED_BY NUMBER
Yes Created by
LAST_UPDATE_DATE DATE
Yes Last update date
UPDATED_BY NUMBER
Yes Updated by
Query Text

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


SELECT PAC_PERIOD_ID
,      PERIOD_SET_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      OPEN_FLAG
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_NAME
,      PERIOD_CLOSE_DATE
,      LEGAL_ENTITY_NAME
,      COST_TYPE_NAME
,      LEGAL_ENTITY
,      COST_TYPE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.CSTFV_PAC_PERIODS;

Dependencies

[top of page]

APPS.CSTFV_PAC_PERIODS references the following:

SchemaAPPS
SynonymCST_COST_TYPES
SynonymCST_PAC_PERIODS
ViewXLE_FIRSTPARTY_INFORMATION_V

APPS.CSTFV_PAC_PERIODS is not referenced by any database object