View: CST_XLA_FLOW_SCHEDULE_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_FLOW_SCHEDULE_REF_V

View Text

SELECT WFS.WIP_ENTITY_ID FLO_SCH_WIP_ENTITY_ID
, WFS.STATUS FLO_SCH_STATUS
, WFS.SCHEDULE_NUMBER FLO_SCH_NUMBER
, DECODE(WFS.SCHEDULED_FLAG
, 1
, 'Y'
, 'N') FLO_SCH_SCHEDULED_FLAG
, WFS.DEMAND_CLASS FLO_SCH_DEMAND_CLASS
, WFS.SCHEDULED_START_DATE FLO_SCH_SCHED_START_DATE
, WFS.SCHEDULED_COMPLETION_DATE FLO_SCH_SCHED_COMP_DATE
, WFS.DATE_CLOSED FLO_SCH_CLOSE_DATE
, WFS.ATTRIBUTE_CATEGORY FLO_SCH_ATTRIBUTE_CATEGORY
, WFS.ATTRIBUTE1 FLO_SCH_ATTRIBUTE1
, WFS.ATTRIBUTE2 FLO_SCH_ATTRIBUTE2
, WFS.ATTRIBUTE3 FLO_SCH_ATTRIBUTE3
, WFS.ATTRIBUTE4 FLO_SCH_ATTRIBUTE4
, WFS.ATTRIBUTE5 FLO_SCH_ATTRIBUTE5
, WFS.ATTRIBUTE6 FLO_SCH_ATTRIBUTE6
, WFS.ATTRIBUTE7 FLO_SCH_ATTRIBUTE7
, WFS.ATTRIBUTE8 FLO_SCH_ATTRIBUTE8
, WFS.ATTRIBUTE9 FLO_SCH_ATTRIBUTE9
, WFS.ATTRIBUTE10 FLO_SCH_ATTRIBUTE10
, WFS.ATTRIBUTE11 FLO_SCH_ATTRIBUTE11
, WFS.ATTRIBUTE12 FLO_SCH_ATTRIBUTE12
, WFS.ATTRIBUTE13 FLO_SCH_ATTRIBUTE13
, WFS.ATTRIBUTE14 FLO_SCH_ATTRIBUTE14
, WFS.ATTRIBUTE15 FLO_SCH_ATTRIBUTE15
, WFS.BOM_REVISION FLO_SCH_BOM_REVISION
, WFS.ROUTING_REVISION FLO_SCH_ROUTING_REVISION
, WFS.CLASS_CODE FLO_SCH_ACCT_CLASS
, WFS.LINE_ID FLO_SCH_LINE_ID
, WFS.PROJECT_ID FLO_SCH_PROJECT_ID
, WFS.TASK_ID FLO_SCH_TASK_ID
, WAC.CLASS_TYPE FLO_SCH_ACCT_CLASS_TYPE
, WAC.DESCRIPTION FLO_SCH_ACCT_CLASS_DESCRIPTION
, WAC.COMPLETION_COST_SOURCE FLO_SCH_COMPLETION_COST_SOURCE
, WAC.COST_TYPE_ID FLO_SCH_COMP_COST_TYPE_ID
, CCT.COST_TYPE FLO_SCH_COMPLETION_COST_TYPE
, WAC.SYSTEM_OPTION_ID FLO_SCH_SYSTEM_OPTION_ID
, WAC.ATTRIBUTE_CATEGORY FLO_SCH_ACCT_CLASS_ATTR_CAT
, WAC.ATTRIBUTE1 FLO_SCH_ACCT_CLASS_ATTRIBUTE1
, WAC.ATTRIBUTE2 FLO_SCH_ACCT_CLASS_ATTRIBUTE2
, WAC.ATTRIBUTE3 FLO_SCH_ACCT_CLASS_ATTRIBUTE3
, WAC.ATTRIBUTE4 FLO_SCH_ACCT_CLASS_ATTRIBUTE4
, WAC.ATTRIBUTE5 FLO_SCH_ACCT_CLASS_ATTRIBUTE5
, WAC.ATTRIBUTE6 FLO_SCH_ACCT_CLASS_ATTRIBUTE6
, WAC.ATTRIBUTE7 FLO_SCH_ACCT_CLASS_ATTRIBUTE7
, WAC.ATTRIBUTE8 FLO_SCH_ACCT_CLASS_ATTRIBUTE8
, WAC.ATTRIBUTE9 FLO_SCH_ACCT_CLASS_ATTRIBUTE9
, WAC.ATTRIBUTE10 FLO_SCH_ACCT_CLASS_ATTRIBUTE10
, WAC.ATTRIBUTE11 FLO_SCH_ACCT_CLASS_ATTRIBUTE11
, WAC.ATTRIBUTE12 FLO_SCH_ACCT_CLASS_ATTRIBUTE12
, WAC.ATTRIBUTE13 FLO_SCH_ACCT_CLASS_ATTRIBUTE13
, WAC.ATTRIBUTE14 FLO_SCH_ACCT_CLASS_ATTRIBUTE14
, WAC.ATTRIBUTE15 FLO_SCH_ACCT_CLASS_ATTRIBUTE15
, WAC.BRIDGING_ACCOUNT FLO_SCH_BRIDGING_ACCT
, WFS.MATERIAL_ACCOUNT FLO_SCH_MATERIAL_ACCT
, WFS.MATERIAL_OVERHEAD_ACCOUNT FLO_SCH_MAT_OVHD_ACCT
, WFS.OUTSIDE_PROCESSING_ACCOUNT FLO_SCH_OUT_PROC_ACCT
, WFS.OVERHEAD_ACCOUNT FLO_SCH_OVERHEAD_ACCT
, WFS.RESOURCE_ACCOUNT FLO_SCH_RESOURCE_ACCT
FROM WIP_FLOW_SCHEDULES WFS
, WIP_ACCOUNTING_CLASSES WAC
, CST_COST_TYPES CCT
WHERE WFS.CLASS_CODE = WAC.CLASS_CODE
AND WFS.ORGANIZATION_ID = WAC.ORGANIZATION_ID
AND WAC.COST_TYPE_ID = CCT.COST_TYPE_ID (+)

Columns