FND Design Data [Home] [Help]

View: CST_XLA_WIP_OP_RESOURCE_REF_V

Product: BOM - Bills of Material
Description:
Implementation/DBA Data: ViewAPPS.CST_XLA_WIP_OP_RESOURCE_REF_V
View Text

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

Columns

Name
RES_SEQ_NUM
OP_RES_OP_SEQ_NUM
OP_RES_WIP_ENTITY_ID
OP_RES_REP_SCHED_ID
RES_SCHEDULE_TYPE
RES_PHANTOM_FLAG
RES_PHANTOM_OP_SEQ_NUM
RES_PHANTOM_ITEM_ID
OP_RES_ATTRIBUTE_CATEGORY
OP_RES_ATTRIBUTE1
OP_RES_ATTRIBUTE2
OP_RES_ATTRIBUTE3
OP_RES_ATTRIBUTE4
OP_RES_ATTRIBUTE5
OP_RES_ATTRIBUTE6
OP_RES_ATTRIBUTE7
OP_RES_ATTRIBUTE8
OP_RES_ATTRIBUTE9
OP_RES_ATTRIBUTE10
OP_RES_ATTRIBUTE11
OP_RES_ATTRIBUTE12
OP_RES_ATTRIBUTE13
OP_RES_ATTRIBUTE14
OP_RES_ATTRIBUTE15