VIEW: APPS.CST_XLA_WIP_OPERATION_REF_V

Source

View Text - Preformatted

SELECT operation_seq_num op_seq_num, wip_entity_id op_wip_entity_id, repetitive_schedule_id op_rep_sched_id, description op_description, count_point_type op_count_point_type, DECODE(operation_yield_enabled, 1, 'Y', 'N' ) op_yield_enabled, NVL(recommended, 'N') op_recommended, DECODE(skip_flag, 1, 'Y', 'N' ) op_skip_charge_flag, attribute_category op_attribute_category, attribute1 op_attribute1, attribute2 op_attribute2, attribute3 op_attribute3, attribute4 op_attribute4, attribute5 op_attribute5, attribute6 op_attribute6, attribute7 op_attribute7, attribute8 op_attribute8, attribute9 op_attribute9, attribute10 op_attribute10, attribute11 op_attribute11, attribute12 op_attribute12, attribute13 op_attribute13, attribute14 op_attribute14, attribute15 op_attribute15 FROM wip_operations

View Text - HTML Formatted

SELECT OPERATION_SEQ_NUM OP_SEQ_NUM
, WIP_ENTITY_ID OP_WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID OP_REP_SCHED_ID
, DESCRIPTION OP_DESCRIPTION
, COUNT_POINT_TYPE OP_COUNT_POINT_TYPE
, DECODE(OPERATION_YIELD_ENABLED
, 1
, 'Y'
, 'N' ) OP_YIELD_ENABLED
, NVL(RECOMMENDED
, 'N') OP_RECOMMENDED
, DECODE(SKIP_FLAG
, 1
, 'Y'
, 'N' ) OP_SKIP_CHARGE_FLAG
, ATTRIBUTE_CATEGORY OP_ATTRIBUTE_CATEGORY
, ATTRIBUTE1 OP_ATTRIBUTE1
, ATTRIBUTE2 OP_ATTRIBUTE2
, ATTRIBUTE3 OP_ATTRIBUTE3
, ATTRIBUTE4 OP_ATTRIBUTE4
, ATTRIBUTE5 OP_ATTRIBUTE5
, ATTRIBUTE6 OP_ATTRIBUTE6
, ATTRIBUTE7 OP_ATTRIBUTE7
, ATTRIBUTE8 OP_ATTRIBUTE8
, ATTRIBUTE9 OP_ATTRIBUTE9
, ATTRIBUTE10 OP_ATTRIBUTE10
, ATTRIBUTE11 OP_ATTRIBUTE11
, ATTRIBUTE12 OP_ATTRIBUTE12
, ATTRIBUTE13 OP_ATTRIBUTE13
, ATTRIBUTE14 OP_ATTRIBUTE14
, ATTRIBUTE15 OP_ATTRIBUTE15
FROM WIP_OPERATIONS