View: WSH_LOOKUP_PRIVILEGES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_LOOKUP_PRIVILEGES_V

View Text

SELECT LOOKUP_CODE
, MEANING
, LOOKUP_TYPE
, DECODE(LOOKUP_CODE
, 'TRIP_FREIGHT_COSTS'
, 10
, 'TRIP_CALC_WV'
, 20
, 'TRIP_LAUNCH_PR'
, 40
, 'TRIP_PR_FORM'
, 50
, 'TRIP_PLAN'
, 60
, 'TRIP_PRINT_DS'
, 70
, 'TRIP_RESOLVE_EXC'
, 80
, 'TRIP_SHIP_CONFIRM'
, 90
, 'TRIP_UNPLAN'
, 100
, 'STOP_FREIGHT_COSTS'
, 120
, 'STOP_CALC_WV'
, 130
, 'STOP_LAUNCH_PR'
, 150
, 'STOP_PR_FORM'
, 160
, 'STOP_PLAN'
, 170
, 'STOP_PRINT_DS'
, 180
, 'STOP_RESOLVE_EXC'
, 190
, 'STOP_UNPLAN'
, 200
, 'STOP_UPDATE_STATUS'
, 210
, 'DLVY_FREIGHT_COSTS'
, 230
, 'DLVY_ASSIGN_TRIP'
, 240
, 'DLVY_AUTOCREATE_TRIP'
, 250
, 'DLVY_AUTOPACK'
, 260
, 'DLVY_AUTOPACK_M'
, 270
, 'DLVY_CALC_WV'
, 280
, 'DLVY_CANCEL_SHIP_METHOD'
, 290
, 'DLVY_CLOSE'
, 300
, 'DLVY_GENERATE_BOL'
, 320
, 'DLVY_GENERATE_LS'
, 330
, 'DLVY_GENERATE_PS'
, 340
, 'DLVY_GET_FREIGHT_COSTS'
, 350
, 'DLVY_LAUNCH_PR'
, 360
, 'DLVY_PACK'
, 370
, 'DLVY_PR_FORM'
, 380
, 'DLVY_PICK_SHIP'
, 390
, 'DLVY_PICK_PACK_SHIP'
, 400
, 'DLVY_PLAN'
, 410
, 'DLVY_PRINT_DS'
, 420
, 'DLVY_REOPEN'
, 430
, 'DLVY_RESOLVE_EXC'
, 440
, 'DLVY_SELECT_CARRIER'
, 450
, 'DLVY_OUTBOUND_DOCUMENT'
, 460
, 'DLVY_SHIP_CONFIRM'
, 470
, 'DLVY_UNASSIGN_TRIP'
, 510
, 'DLVY_UNPLAN'
, 520
, 'DLVY_VW_TRANS_HISTORY'
, 540
, 'DLVY_VIEW_STATUS'
, 550
, 'DLVB_FREIGHT_COSTS'
, 560
, 'DLVB_ASSIGN_DLVY'
, 570
, 'DLVB_AUTOCREATE_DLVY'
, 580
, 'DLVB_AUTOCREATE_TRIP'
, 590
, 'DLVB_AUTOPACK'
, 600
, 'DLVB_AUTOPACK_M'
, 610
, 'DLVB_CALC_WV'
, 620
, 'DLVB_CREATE_CONTS'
, 630
, 'DLVB_CYCLE_COUNT'
, 640
, 'DLVB_LAUNCH_PR'
, 660
, 'DLVB_PACK'
, 670
, 'DLVB_PACKING_CALC'
, 680
, 'DLVB_PACKING_WB'
, 690
, 'DLVB_PR_FORM'
, 700
, 'DLVB_PICK_SHIP'
, 710
, 'DLVB_PICK_PACK_SHIP'
, 720
, 'DLVB_RESOLVE_EXC'
, 730
, 'DLVB_SPLIT_LINE'
, 740
, 'DLVB_UNASSIGN_DLVY'
, 790
, 'DLVB_UNPACK'
, 800
, 'DLVB_IGNORE_PLAN'
, 820
, 'DLVB_INCLUDE_PLAN'
, 830
, 'DLVY_IGNORE_PLAN'
, 840
, 'DLVY_INCLUDE_PLAN'
, 850
, 'DLVY_FIRM'
, 860
, 'TRIP_FIRM'
, 870
, 'TRIP_IGNORE_PLAN'
, 880
, 'TRIP_INCLUDE_PLAN'
, 890
, 'DLVB_LOG_EXCEP'
, 900
, 'DLVY_LOG_EXCEP'
, 910
, 'STOP_LOG_EXCEP'
, 920
, 'TRIP_LOG_EXCEP'
, 930
, 'TRIP_PRINT_MBOL'
, 940
, -99) ACTION_ID
FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 665
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)
AND LV.LOOKUP_TYPE IN ('TRIP_PRIVILEGE'
, 'STOP_PRIVILEGE'
, 'DLVY_PRIVILEGE'
, 'DLVB_PRIVILEGE')

Columns