eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_RULES_V

Source

View Text - Preformatted


SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,wrvl.QTY_FUNCTION_PARAMETER_ID ,WMS_Parameter_PVT.GetFlexName( wpvl.NAME ,wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ) ,wpvl.DESCRIPTION ,wpvl.OBJECT_ID ,wovl.NAME ,wovl.DESCRIPTION ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG , DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , nvl(wrvl.allocation_mode_id,4) allocation_mode_id , m2.MEANING allocation_mode ,TO_NUMBER(NULL) activity_type_id , TO_CHAR(NULL) activity_type_name , TO_NUMBER(NULL) plan_type_id , TO_CHAR(NULL) plan_type_name FROM WMS_OBJECTS_VL wovl ,WMS_PARAMETERS_VL wpvl ,MFG_LOOKUPS ml ,WMS_RULES_VL wrvl ,MFG_LOOKUPS m2 WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE = wrvl.TYPE_CODE AND wpvl.PARAMETER_ID = wrvl.QTY_FUNCTION_PARAMETER_ID AND wovl.OBJECT_ID = wpvl.OBJECT_ID AND ml.LOOKUP_CODE = 2 AND (m2.LOOKUP_TYPE = 'WMS_RULE_ALLOCATION_MODE' AND m2.LOOKUP_CODE = nvl(wrvl.allocation_mode_id,4)) AND nvl(wrvl.wms_enabled_flag,'Y') = 'Y' UNION SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,wrvl.QTY_FUNCTION_PARAMETER_ID ,WMS_Parameter_PVT.GetFlexName( wpvl.NAME ,wpvl.DB_OBJECT_REF_TYPE_CODE ,wpvl.PARAMETER_TYPE_CODE ,wpvl.FLEXFIELD_USAGE_CODE ,wpvl.FLEXFIELD_APPLICATION_ID ,wpvl.FLEXFIELD_NAME ,wpvl.COLUMN_NAME ) ,wpvl.DESCRIPTION ,wpvl.OBJECT_ID ,wovl.NAME ,wovl.DESCRIPTION ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG , DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , wrvl.allocation_mode_id , '' allocation_mode ,TO_NUMBER(NULL) activity_type_id , TO_CHAR(NULL) activity_type_name , TO_NUMBER(NULL) plan_type_id , TO_CHAR(NULL) plan_type_name FROM WMS_OBJECTS_VL wovl ,WMS_PARAMETERS_VL wpvl ,MFG_LOOKUPS ml ,WMS_RULES_VL wrvl WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE = wrvl.TYPE_CODE AND wpvl.PARAMETER_ID = wrvl.QTY_FUNCTION_PARAMETER_ID AND wovl.OBJECT_ID = wpvl.OBJECT_ID AND ml.LOOKUP_CODE = 1 UNION SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,tt.OPERATION_CODE ,tt.OPERATION_DESCRIPTION ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG ,DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , wrvl.allocation_mode_id , '' allocation_mode ,TO_NUMBER(NULL) activity_type_id , TO_CHAR(NULL) activity_type_name , TO_NUMBER(NULL) plan_type_id , TO_CHAR(NULL) plan_type_name FROM MFG_LOOKUPS ml ,WMS_RULES_VL wrvl ,BOM_STANDARD_OPERATIONS tt WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE= wrvl.TYPE_CODE AND ml.LOOKUP_CODE = 3 AND wrvl.ORGANIZATION_ID = tt.ORGANIZATION_ID AND tt.WMS_TASK_TYPE IS NOT NULL AND wrvl.TYPE_HDR_ID = tt.STANDARD_OPERATION_ID UNION SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,wlf.LABEL_FORMAT_NAME ,wlf.FORMAT_DESCRIPTION ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG ,DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , wrvl.allocation_mode_id , '' allocation_mode ,TO_NUMBER(NULL) activity_type_id , TO_CHAR(NULL) activity_type_name , TO_NUMBER(NULL) plan_type_id , TO_CHAR(NULL) plan_type_name FROM MFG_LOOKUPS ml ,WMS_RULES_VL wrvl , WMS_LABEL_FORMATS wlf WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE= wrvl.TYPE_CODE AND ml.LOOKUP_CODE = 4 AND wrvl.TYPE_HDR_ID = wlf.LABEL_FORMAT_ID UNION SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,cg.COST_GROUP ,cg.DESCRIPTION ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG ,DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , wrvl.allocation_mode_id , '' allocation_mode ,TO_NUMBER(NULL) activity_type_id , TO_CHAR(NULL) activity_type_name , TO_NUMBER(NULL) plan_type_id , TO_CHAR(NULL) plan_type_name FROM MFG_LOOKUPS ml ,WMS_RULES_VL wrvl ,CST_COST_GROUPS cg WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE= wrvl.TYPE_CODE AND ml.LOOKUP_CODE = 5 AND wrvl.ORGANIZATION_ID = nvl(cg.ORGANIZATION_ID,wrvl.ORGANIZATION_ID) AND wrvl.TYPE_HDR_ID = cg.COST_GROUP_ID UNION SELECT wrvl.ROW_ID ,wrvl.RULE_ID ,wrvl.ORGANIZATION_ID ,wrvl.TYPE_CODE ,ml.MEANING ,ml.DESCRIPTION ,wrvl.NAME ,wrvl.DESCRIPTION ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,TO_CHAR(NULL) ,wrvl.ENABLED_FLAG ,wrvl.USER_DEFINED_FLAG ,wrvl.CREATED_BY ,wrvl.CREATION_DATE ,wrvl.LAST_UPDATED_BY ,wrvl.LAST_UPDATE_DATE ,wrvl.LAST_UPDATE_LOGIN ,wrvl.TYPE_HDR_ID ,op.OPERATION_plan_name ,op.description ,wrvl.RULE_WEIGHT ,wrvl.ATTRIBUTE1 ,wrvl.ATTRIBUTE2 ,wrvl.ATTRIBUTE3 ,wrvl.ATTRIBUTE4 ,wrvl.ATTRIBUTE5 ,wrvl.ATTRIBUTE6 ,wrvl.ATTRIBUTE7 ,wrvl.ATTRIBUTE8 ,wrvl.ATTRIBUTE9 ,wrvl.ATTRIBUTE10 ,wrvl.ATTRIBUTE11 ,wrvl.ATTRIBUTE12 ,wrvl.ATTRIBUTE13 ,wrvl.ATTRIBUTE14 ,wrvl.ATTRIBUTE15 ,wrvl.ATTRIBUTE_CATEGORY ,wrvl.MIN_PICK_TASKS_FLAG ,DECODE(wrvl.organization_id , -1, 'Y', 'N') COMMON_TO_ALL_ORGS_FLAG , wrvl.allocation_mode_id , '' allocation_mode ,op.activity_type_id activity_type_id , m3.meaning activity_type_name , op.plan_type_id plan_type_id , m4.meaning plan_type_name FROM MFG_LOOKUPS ml ,WMS_RULES_VL wrvl ,WMS_OP_PLANS_VL op , mfg_lookups m3 , mfg_lookups m4 WHERE ml.LOOKUP_TYPE = 'WMS_ACTION_TYPE' AND ml.LOOKUP_CODE= wrvl.TYPE_CODE AND ml.LOOKUP_CODE = 7 AND wrvl.ORGANIZATION_ID = Nvl(op.ORGANIZATION_ID, wrvl.ORGANIZATION_ID) AND wrvl.TYPE_HDR_ID = op.operation_plan_id AND (m3.LOOKUP_TYPE = 'WMS_ACTIVITY_TYPES' AND m3.LOOKUP_CODE = op.activity_type_id) AND (m4.LOOKUP_TYPE =DECODE(op.activity_type_id, 1, 'WMS_OP_INBOUND_TYPES', 2, 'WMS_OP_OUTBOUND_TYPES') AND m4.LOOKUP_CODE = op.plan_type_id)

View Text - HTML Formatted

SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.QTY_FUNCTION_PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, NVL(WRVL.ALLOCATION_MODE_ID
, 4) ALLOCATION_MODE_ID
, M2.MEANING ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, MFG_LOOKUPS M2
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WRVL.QTY_FUNCTION_PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND ML.LOOKUP_CODE = 2
AND (M2.LOOKUP_TYPE = 'WMS_RULE_ALLOCATION_MODE'
AND M2.LOOKUP_CODE = NVL(WRVL.ALLOCATION_MODE_ID
, 4))
AND NVL(WRVL.WMS_ENABLED_FLAG
, 'Y') = 'Y' UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.QTY_FUNCTION_PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WPVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WRVL.QTY_FUNCTION_PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND ML.LOOKUP_CODE = 1 UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, TT.OPERATION_CODE
, TT.OPERATION_DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, BOM_STANDARD_OPERATIONS TT
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 3
AND WRVL.ORGANIZATION_ID = TT.ORGANIZATION_ID
AND TT.WMS_TASK_TYPE IS NOT NULL
AND WRVL.TYPE_HDR_ID = TT.STANDARD_OPERATION_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, WLF.LABEL_FORMAT_NAME
, WLF.FORMAT_DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, WMS_LABEL_FORMATS WLF
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 4
AND WRVL.TYPE_HDR_ID = WLF.LABEL_FORMAT_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, CG.COST_GROUP
, CG.DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, TO_NUMBER(NULL) ACTIVITY_TYPE_ID
, TO_CHAR(NULL) ACTIVITY_TYPE_NAME
, TO_NUMBER(NULL) PLAN_TYPE_ID
, TO_CHAR(NULL) PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, CST_COST_GROUPS CG
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 5
AND WRVL.ORGANIZATION_ID = NVL(CG.ORGANIZATION_ID
, WRVL.ORGANIZATION_ID)
AND WRVL.TYPE_HDR_ID = CG.COST_GROUP_ID UNION SELECT WRVL.ROW_ID
, WRVL.RULE_ID
, WRVL.ORGANIZATION_ID
, WRVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WRVL.NAME
, WRVL.DESCRIPTION
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, WRVL.ENABLED_FLAG
, WRVL.USER_DEFINED_FLAG
, WRVL.CREATED_BY
, WRVL.CREATION_DATE
, WRVL.LAST_UPDATED_BY
, WRVL.LAST_UPDATE_DATE
, WRVL.LAST_UPDATE_LOGIN
, WRVL.TYPE_HDR_ID
, OP.OPERATION_PLAN_NAME
, OP.DESCRIPTION
, WRVL.RULE_WEIGHT
, WRVL.ATTRIBUTE1
, WRVL.ATTRIBUTE2
, WRVL.ATTRIBUTE3
, WRVL.ATTRIBUTE4
, WRVL.ATTRIBUTE5
, WRVL.ATTRIBUTE6
, WRVL.ATTRIBUTE7
, WRVL.ATTRIBUTE8
, WRVL.ATTRIBUTE9
, WRVL.ATTRIBUTE10
, WRVL.ATTRIBUTE11
, WRVL.ATTRIBUTE12
, WRVL.ATTRIBUTE13
, WRVL.ATTRIBUTE14
, WRVL.ATTRIBUTE15
, WRVL.ATTRIBUTE_CATEGORY
, WRVL.MIN_PICK_TASKS_FLAG
, DECODE(WRVL.ORGANIZATION_ID
, -1
, 'Y'
, 'N') COMMON_TO_ALL_ORGS_FLAG
, WRVL.ALLOCATION_MODE_ID
, '' ALLOCATION_MODE
, OP.ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID
, M3.MEANING ACTIVITY_TYPE_NAME
, OP.PLAN_TYPE_ID PLAN_TYPE_ID
, M4.MEANING PLAN_TYPE_NAME
FROM MFG_LOOKUPS ML
, WMS_RULES_VL WRVL
, WMS_OP_PLANS_VL OP
, MFG_LOOKUPS M3
, MFG_LOOKUPS M4
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE= WRVL.TYPE_CODE
AND ML.LOOKUP_CODE = 7
AND WRVL.ORGANIZATION_ID = NVL(OP.ORGANIZATION_ID
, WRVL.ORGANIZATION_ID)
AND WRVL.TYPE_HDR_ID = OP.OPERATION_PLAN_ID
AND (M3.LOOKUP_TYPE = 'WMS_ACTIVITY_TYPES'
AND M3.LOOKUP_CODE = OP.ACTIVITY_TYPE_ID)
AND (M4.LOOKUP_TYPE =DECODE(OP.ACTIVITY_TYPE_ID
, 1
, 'WMS_OP_INBOUND_TYPES'
, 2
, 'WMS_OP_OUTBOUND_TYPES')
AND M4.LOOKUP_CODE = OP.PLAN_TYPE_ID)