Product: | WMS - Warehouse Management |
---|---|
Description: | WMS parameter LOV view |
Implementation/DBA Data: | APPS.WMS_PARAMETERS_LOV_V |
SELECT WPVL.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
, WDO.TABLE_ALIAS
, WDO.TABLE_NAME
, NVL( WPVL.COLUMN_NAME
, 'EXPRESSION')
, WMS_PARAMETER_PVT.GETFLEXDATATYPECODE( WPVL.DATA_TYPE_CODE
, 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.USE_FOR_PUT_SORT_FLAG
, WPVL.USE_FOR_PUT_REST_FLAG
, WPVL.USE_FOR_PUT_QTYF_FLAG
, WPVL.USE_FOR_PICK_SORT_FLAG
, WPVL.USE_FOR_PICK_REST_FLAG
, WPVL.USE_FOR_PICK_QTYF_FLAG
, WPVL.USE_FOR_TT_ASSN_FLAG
, WPVL.USE_FOR_LABEL_REST_FLAG
, WPVL.USE_FOR_CG_REST_FLAG
, WPVL.USE_FOR_PICK_CONSIST_FLAG
, WPVL.USE_FOR_OP_SELECTION_FLAG
FROM WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, WMS_DB_OBJECTS WDO
WHERE WMS_PARAMETER_PVT.IFFLEXTHENAVAILABLE( WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME ) = 'Y'
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND WPVL.DB_OBJECT_ID = WDO.DB_OBJECT_ID (+)