Product: | BOM - Bills of Material |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CST_XLA_WIP_OP_RESOURCE_REF_V |
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