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

Object Details

Object Name:	CST_XLA_FLOW_SCHEDULE_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_XLA_FLOW_SCHEDULE_REF_V
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
FLO_SCH_WIP_ENTITY_ID	NUMBER		Yes
FLO_SCH_STATUS	NUMBER		Yes
FLO_SCH_NUMBER	VARCHAR2	(30)	Yes
FLO_SCH_SCHEDULED_FLAG	VARCHAR2	(1)
FLO_SCH_DEMAND_CLASS	VARCHAR2	(30)
FLO_SCH_SCHED_START_DATE	DATE		Yes
FLO_SCH_SCHED_COMP_DATE	DATE		Yes
FLO_SCH_CLOSE_DATE	DATE
FLO_SCH_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
FLO_SCH_ATTRIBUTE1	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE2	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE3	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE4	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE5	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE6	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE7	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE8	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE9	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE10	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE11	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE12	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE13	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE14	VARCHAR2	(150)
FLO_SCH_ATTRIBUTE15	VARCHAR2	(150)
FLO_SCH_BOM_REVISION	VARCHAR2	(3)
FLO_SCH_ROUTING_REVISION	VARCHAR2	(3)
FLO_SCH_ACCT_CLASS	VARCHAR2	(10)	Yes
FLO_SCH_LINE_ID	NUMBER
FLO_SCH_PROJECT_ID	NUMBER
FLO_SCH_TASK_ID	NUMBER
FLO_SCH_ACCT_CLASS_TYPE	NUMBER		Yes
FLO_SCH_ACCT_CLASS_DESCRIPTION	VARCHAR2	(240)
FLO_SCH_COMPLETION_COST_SOURCE	NUMBER
FLO_SCH_COMP_COST_TYPE_ID	NUMBER
FLO_SCH_COMPLETION_COST_TYPE	VARCHAR2	(10)
FLO_SCH_SYSTEM_OPTION_ID	NUMBER
FLO_SCH_ACCT_CLASS_ATTR_CAT	VARCHAR2	(30)
FLO_SCH_ACCT_CLASS_ATTRIBUTE1	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE2	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE3	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE4	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE5	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE6	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE7	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE8	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE9	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE10	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE11	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE12	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE13	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE14	VARCHAR2	(150)
FLO_SCH_ACCT_CLASS_ATTRIBUTE15	VARCHAR2	(150)
FLO_SCH_BRIDGING_ACCT	NUMBER
FLO_SCH_MATERIAL_ACCT	NUMBER
FLO_SCH_MAT_OVHD_ACCT	NUMBER
FLO_SCH_OUT_PROC_ACCT	NUMBER
FLO_SCH_OVERHEAD_ACCT	NUMBER
FLO_SCH_RESOURCE_ACCT	NUMBER

Query Text

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


SELECT FLO_SCH_WIP_ENTITY_ID
,      FLO_SCH_STATUS
,      FLO_SCH_NUMBER
,      FLO_SCH_SCHEDULED_FLAG
,      FLO_SCH_DEMAND_CLASS
,      FLO_SCH_SCHED_START_DATE
,      FLO_SCH_SCHED_COMP_DATE
,      FLO_SCH_CLOSE_DATE
,      FLO_SCH_ATTRIBUTE_CATEGORY
,      FLO_SCH_ATTRIBUTE1
,      FLO_SCH_ATTRIBUTE2
,      FLO_SCH_ATTRIBUTE3
,      FLO_SCH_ATTRIBUTE4
,      FLO_SCH_ATTRIBUTE5
,      FLO_SCH_ATTRIBUTE6
,      FLO_SCH_ATTRIBUTE7
,      FLO_SCH_ATTRIBUTE8
,      FLO_SCH_ATTRIBUTE9
,      FLO_SCH_ATTRIBUTE10
,      FLO_SCH_ATTRIBUTE11
,      FLO_SCH_ATTRIBUTE12
,      FLO_SCH_ATTRIBUTE13
,      FLO_SCH_ATTRIBUTE14
,      FLO_SCH_ATTRIBUTE15
,      FLO_SCH_BOM_REVISION
,      FLO_SCH_ROUTING_REVISION
,      FLO_SCH_ACCT_CLASS
,      FLO_SCH_LINE_ID
,      FLO_SCH_PROJECT_ID
,      FLO_SCH_TASK_ID
,      FLO_SCH_ACCT_CLASS_TYPE
,      FLO_SCH_ACCT_CLASS_DESCRIPTION
,      FLO_SCH_COMPLETION_COST_SOURCE
,      FLO_SCH_COMP_COST_TYPE_ID
,      FLO_SCH_COMPLETION_COST_TYPE
,      FLO_SCH_SYSTEM_OPTION_ID
,      FLO_SCH_ACCT_CLASS_ATTR_CAT
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE1
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE2
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE3
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE4
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE5
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE6
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE7
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE8
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE9
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE10
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE11
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE12
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE13
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE14
,      FLO_SCH_ACCT_CLASS_ATTRIBUTE15
,      FLO_SCH_BRIDGING_ACCT
,      FLO_SCH_MATERIAL_ACCT
,      FLO_SCH_MAT_OVHD_ACCT
,      FLO_SCH_OUT_PROC_ACCT
,      FLO_SCH_OVERHEAD_ACCT
,      FLO_SCH_RESOURCE_ACCT
FROM APPS.CST_XLA_FLOW_SCHEDULE_REF_V;

Dependencies

[top of page]

APPS.CST_XLA_FLOW_SCHEDULE_REF_V references the following:

APPS: CST_COST_TYPES; WIP_ACCOUNTING_CLASSES; WIP_FLOW_SCHEDULES

APPS.CST_XLA_FLOW_SCHEDULE_REF_V is referenced by following:

APPS: XLA_00707_AAD_S_000019_PKG - show dependent code; XLA_00707_AAD_S_000020_PKG - show dependent code