VIEW: APPS.CST_XLA_FLOW_SCHEDULE_REF_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)