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

VIEW: APPS.CN_ACC_PERIOD_STATUSES_V

Object Details
Object Name: CN_ACC_PERIOD_STATUSES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERIOD_ID NUMBER (15) Yes period id
PERIOD_NAME VARCHAR2 (30) Yes period name
PERIOD_STATUS VARCHAR2 (15) Yes period status
PROCESSING_STATUS_CODE VARCHAR2 (30) Yes processing status
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
ORG_ID NUMBER (15)
Organization identifier
QUARTER_NUM NUMBER (15)
quarter number
PERIOD_YEAR NUMBER (15)
period year
FORECAST_FLAG VARCHAR2 (1)
forecast flag
CALENDAR_ID NUMBER (15)
calendar id
PERIOD_SET_NAME VARCHAR2 (15) Yes period set name
PERIOD_TYPE VARCHAR2 (15)
period type
PERIOD_TYPE_ID NUMBER (15) Yes period type id
PERIOD_SET_ID NUMBER (15)
period set id
START_DATE DATE

start date
END_DATE DATE

end date
FREEZE_FLAG VARCHAR2 (1)
Query Text

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


SELECT PERIOD_ID
,      PERIOD_NAME
,      PERIOD_STATUS
,      PROCESSING_STATUS_CODE
,      PROGRAM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      QUARTER_NUM
,      PERIOD_YEAR
,      FORECAST_FLAG
,      CALENDAR_ID
,      PERIOD_SET_NAME
,      PERIOD_TYPE
,      PERIOD_TYPE_ID
,      PERIOD_SET_ID
,      START_DATE
,      END_DATE
,      FREEZE_FLAG
FROM APPS.CN_ACC_PERIOD_STATUSES_V;

Dependencies

[top of page]

APPS.CN_ACC_PERIOD_STATUSES_V references the following:

SchemaAPPS
SynonymCN_PERIOD_STATUSES
SynonymCN_REPOSITORIES
APPS.CN_ACC_PERIOD_STATUSES_V is referenced by following:

SchemaAPPS
ViewCN_ADJ_DETAIL_LINES_V
PL/SQL PackageCN_API - show dependent code
Package BodyCN_API - show dependent code
Package BodyCN_COMP_PLAN_XMLCOPY_PVT - show dependent code
Package BodyCN_GENERAL_UTILS - show dependent code
Package BodyCN_GET_COMM_SUMM_DATA - show dependent code
Package BodyCN_GET_TX_DATA_PUB - show dependent code
Package BodyCN_IMP_TRXAPI_PVT - show dependent code
Package BodyCN_MARK_EVENTS_PKG - show dependent code
ViewCN_NOTIFY_LOG_V
Package BodyCN_PERIOD_QUOTAS_GRP - show dependent code
ViewCN_PERIOD_QUOTAS_INTERVAL_V
Package BodyCN_PERIOD_QUOTAS_PKG - show dependent code
PL/SQL PackageCN_PERIOD_QUOTAS_PKG - show dependent code
ViewCN_PERIOD_QUOTAS_V
ViewCN_PERIOD_QUOTAS_YEAR_V
Package BodyCN_PLAN_ELEMENT_PUB - show dependent code
Package BodyCN_PRD_QUOTA_PUB - show dependent code
Package BodyCN_PROC_BATCHES_PKG - show dependent code
Package BodyCN_QUOTAS_PKG - show dependent code
Package BodyCN_SCA_CREDITS_BATCH_PUB - show dependent code
Package BodyCN_SRP_PERIODS_PVT - show dependent code
ViewCN_SRP_PERIOD_QUOTAS_INT_V
Package BodyCN_SRP_PERIOD_QUOTAS_PKG - show dependent code
PL/SQL PackageCN_SRP_PERIOD_QUOTAS_PKG - show dependent code
ViewCN_SRP_PERIOD_QUOTAS_YEAR_V
Package BodyCN_SRP_PLAN_ASSIGNS_PKG - show dependent code
Package BodyCN_TRANSACTION_LOAD_PKG - show dependent code
Package BodyCN_TRANSACTION_LOAD_PUB - show dependent code