CST_XLA_WO_OP_RESOURCES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

CST_WORK_ORDER_OPERATION_ID WO_OPERATION_RESOURCE_ID WO_OPERATION_ID RESOURCE_ID WO_OP_RES_ATTRIBUTE_CATEGORY WO_OP_RES_ATTRIBUTE_CHAR1 WO_OP_RES_ATTRIBUTE_CHAR2 WO_OP_RES_ATTRIBUTE_CHAR3 WO_OP_RES_ATTRIBUTE_CHAR4 WO_OP_RES_ATTRIBUTE_CHAR5 WO_OP_RES_ATTRIBUTE_CHAR6 WO_OP_RES_ATTRIBUTE_CHAR7 WO_OP_RES_ATTRIBUTE_CHAR8 WO_OP_RES_ATTRIBUTE_CHAR9 WO_OP_RES_ATTRIBUTE_CHAR10 WO_OP_RES_ATTRIBUTE_CHAR11 WO_OP_RES_ATTRIBUTE_CHAR12 WO_OP_RES_ATTRIBUTE_CHAR13 WO_OP_RES_ATTRIBUTE_CHAR14 WO_OP_RES_ATTRIBUTE_CHAR15 WO_OP_RES_ATTRIBUTE_CHAR16 WO_OP_RES_ATTRIBUTE_CHAR17 WO_OP_RES_ATTRIBUTE_CHAR18 WO_OP_RES_ATTRIBUTE_CHAR19 WO_OP_RES_ATTRIBUTE_CHAR20

Query

SQL_Statement

SELECT CWOP.WORK_ORDER_OPERATION_ID CST_WORK_ORDER_OPERATION_ID ,WWOP.WO_OPERATION_RESOURCE_ID WO_OPERATION_RESOURCE_ID ,WWOP.WO_OPERATION_ID WO_OPERATION_ID ,WWOP.RESOURCE_ID RESOURCE_ID ,WWOP.ATTRIBUTE_CATEGORY WO_OP_RES_ATTRIBUTE_CATEGORY ,WWOP.ATTRIBUTE_CHAR1 WO_OP_RES_ATTRIBUTE_CHAR1 ,WWOP.ATTRIBUTE_CHAR2 WO_OP_RES_ATTRIBUTE_CHAR2 ,WWOP.ATTRIBUTE_CHAR3 WO_OP_RES_ATTRIBUTE_CHAR3 ,WWOP.ATTRIBUTE_CHAR4 WO_OP_RES_ATTRIBUTE_CHAR4 ,WWOP.ATTRIBUTE_CHAR5 WO_OP_RES_ATTRIBUTE_CHAR5 ,WWOP.ATTRIBUTE_CHAR6 WO_OP_RES_ATTRIBUTE_CHAR6 ,WWOP.ATTRIBUTE_CHAR7 WO_OP_RES_ATTRIBUTE_CHAR7 ,WWOP.ATTRIBUTE_CHAR8 WO_OP_RES_ATTRIBUTE_CHAR8 ,WWOP.ATTRIBUTE_CHAR9 WO_OP_RES_ATTRIBUTE_CHAR9 ,WWOP.ATTRIBUTE_CHAR10 WO_OP_RES_ATTRIBUTE_CHAR10 ,WWOP.ATTRIBUTE_CHAR11 WO_OP_RES_ATTRIBUTE_CHAR11 ,WWOP.ATTRIBUTE_CHAR12 WO_OP_RES_ATTRIBUTE_CHAR12 ,WWOP.ATTRIBUTE_CHAR13 WO_OP_RES_ATTRIBUTE_CHAR13 ,WWOP.ATTRIBUTE_CHAR14 WO_OP_RES_ATTRIBUTE_CHAR14 ,WWOP.ATTRIBUTE_CHAR15 WO_OP_RES_ATTRIBUTE_CHAR15 ,WWOP.ATTRIBUTE_CHAR16 WO_OP_RES_ATTRIBUTE_CHAR16 ,WWOP.ATTRIBUTE_CHAR17 WO_OP_RES_ATTRIBUTE_CHAR17 ,WWOP.ATTRIBUTE_CHAR18 WO_OP_RES_ATTRIBUTE_CHAR18 ,WWOP.ATTRIBUTE_CHAR19 WO_OP_RES_ATTRIBUTE_CHAR19 ,WWOP.ATTRIBUTE_CHAR20 WO_OP_RES_ATTRIBUTE_CHAR20 FROM WIE_WO_OPERATION_RESOURCES_V WWOP, CST_WORK_ORDER_OPERATIONS CWOP WHERE WWOP.WO_OPERATION_ID = CWOP.WORK_ORDER_OPERATION_ID