VIEW: APPS.CST_XLA_WIP_OP_RESOURCE_REF_V

Source

View Text - Preformatted

SELECT resource_seq_num res_seq_num, operation_seq_num op_res_op_seq_num, wip_entity_id op_res_wip_entity_id, repetitive_schedule_id op_res_rep_sched_id, scheduled_flag res_schedule_type, DECODE(phantom_flag, 1, 'Y', 'N' ) res_phantom_flag, phantom_op_seq_num res_phantom_op_seq_num, phantom_item_id res_phantom_item_id, attribute_category op_res_attribute_category, attribute1 op_res_attribute1, attribute2 op_res_attribute2, attribute3 op_res_attribute3, attribute4 op_res_attribute4, attribute5 op_res_attribute5, attribute6 op_res_attribute6, attribute7 op_res_attribute7, attribute8 op_res_attribute8, attribute9 op_res_attribute9, attribute10 op_res_attribute10, attribute11 op_res_attribute11, attribute12 op_res_attribute12, attribute13 op_res_attribute13, attribute14 op_res_attribute14, attribute15 op_res_attribute15 FROM wip_operation_resources

View Text - HTML Formatted

SELECT RESOURCE_SEQ_NUM RES_SEQ_NUM
, OPERATION_SEQ_NUM OP_RES_OP_SEQ_NUM
, WIP_ENTITY_ID OP_RES_WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID OP_RES_REP_SCHED_ID
, SCHEDULED_FLAG RES_SCHEDULE_TYPE
, DECODE(PHANTOM_FLAG
, 1
, 'Y'
, 'N' ) RES_PHANTOM_FLAG
, PHANTOM_OP_SEQ_NUM RES_PHANTOM_OP_SEQ_NUM
, PHANTOM_ITEM_ID RES_PHANTOM_ITEM_ID
, ATTRIBUTE_CATEGORY OP_RES_ATTRIBUTE_CATEGORY
, ATTRIBUTE1 OP_RES_ATTRIBUTE1
, ATTRIBUTE2 OP_RES_ATTRIBUTE2
, ATTRIBUTE3 OP_RES_ATTRIBUTE3
, ATTRIBUTE4 OP_RES_ATTRIBUTE4
, ATTRIBUTE5 OP_RES_ATTRIBUTE5
, ATTRIBUTE6 OP_RES_ATTRIBUTE6
, ATTRIBUTE7 OP_RES_ATTRIBUTE7
, ATTRIBUTE8 OP_RES_ATTRIBUTE8
, ATTRIBUTE9 OP_RES_ATTRIBUTE9
, ATTRIBUTE10 OP_RES_ATTRIBUTE10
, ATTRIBUTE11 OP_RES_ATTRIBUTE11
, ATTRIBUTE12 OP_RES_ATTRIBUTE12
, ATTRIBUTE13 OP_RES_ATTRIBUTE13
, ATTRIBUTE14 OP_RES_ATTRIBUTE14
, ATTRIBUTE15 OP_RES_ATTRIBUTE15
FROM WIP_OPERATION_RESOURCES