VIEW: APPS.WSH_LOOKUP_PRIVILEGES_V

Source

View Text - Preformatted

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 , 'DLVY_VW_CONSOL_DLVY',950, 'TRIP_UNASSIGN_ALL',960, 'TRIP_REMOVE_CONSOL',970, 'TRIP_SELECT_CARRIER',980, -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')

View Text - HTML Formatted

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
, 'DLVY_VW_CONSOL_DLVY'
, 950
, 'TRIP_UNASSIGN_ALL'
, 960
, 'TRIP_REMOVE_CONSOL'
, 970
, 'TRIP_SELECT_CARRIER'
, 980
, -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')