[Home] [Help]
View: WIP_LINE_OPERATIONS_V
View Text
SELECT WL.LINE_CODE ||':'|| BSO.OPERATION_CODE "NODE_LABEL"
, OOD.ORGANIZATION_CODE
, OOD.ORGANIZATION_ID
, WL.LINE_CODE
, WL.LINE_ID
, BSO.OPERATION_CODE
, BSO.STANDARD_OPERATION_ID
, BSO.MINIMUM_TRANSFER_QUANTITY
, BSO.OPERATION_DESCRIPTION
, WL.DESCRIPTION "LINE_DESCRIPTION"
FROM BOM_STANDARD_OPERATIONS BSO
, ORG_ORGANIZATION_DEFINITIONS OOD
, WIP_LINES WL
WHERE OOD.ORGANIZATION_ID = WL.ORGANIZATION_ID
AND BSO.LINE_ID = WL.LINE_ID
AND BSO.ORGANIZATION_ID = WL.ORGANIZATION_ID
AND BSO.OPERATION_TYPE = 3 /* LINE OP */
Columns
Name |
NODE_LABEL |
ORGANIZATION_CODE |
ORGANIZATION_ID |
LINE_CODE |
LINE_ID |
OPERATION_CODE |
STANDARD_OPERATION_ID |
MINIMUM_TRANSFER_QUANTITY |
OPERATION_DESCRIPTION |
LINE_DESCRIPTION |