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.

APPS.OKE_K_SECURITY_PKG dependencies on OKE_K_HEADERS

Line 394: , oke_k_headers kh

390: This version somehow results in FTS
391:
392: SELECT project_role_id
393: FROM pa_project_parties pp
394: , oke_k_headers kh
395: WHERE kh.k_header_id = C_K_Header_ID
396: AND ( ( pp.object_type = 'OKE_K_HEADERS'
397: AND pp.object_id = kh.k_header_id
398: )

Line 396: AND ( ( pp.object_type = 'OKE_K_HEADERS'

392: SELECT project_role_id
393: FROM pa_project_parties pp
394: , oke_k_headers kh
395: WHERE kh.k_header_id = C_K_Header_ID
396: AND ( ( pp.object_type = 'OKE_K_HEADERS'
397: AND pp.object_id = kh.k_header_id
398: )
399: OR ( pp.object_type = 'OKE_PROGRAMS'
400: AND pp.object_id in (kh.program_id , 0)

Line 414: , decode(pp.object_type, 'OKE_K_HEADERS', 1, 3) Sort_Order

410: -- First part of the union retrieves contract level as well as
411: -- site level assignment
412: --
413: SELECT Project_Role_ID
414: , decode(pp.object_type, 'OKE_K_HEADERS', 1, 3) Sort_Order
415: FROM pa_project_parties pp
416: WHERE ( pp.object_type , pp.object_id ) IN
417: ( ( 'OKE_K_HEADERS' , C_K_Header_ID )
418: , ( 'OKE_PROGRAMS' , 0 )

Line 417: ( ( 'OKE_K_HEADERS' , C_K_Header_ID )

413: SELECT Project_Role_ID
414: , decode(pp.object_type, 'OKE_K_HEADERS', 1, 3) Sort_Order
415: FROM pa_project_parties pp
416: WHERE ( pp.object_type , pp.object_id ) IN
417: ( ( 'OKE_K_HEADERS' , C_K_Header_ID )
418: , ( 'OKE_PROGRAMS' , 0 )
419: )
420: AND pp.resource_type_id = 101
421: AND pp.resource_source_id = C_Emp_ID

Line 429: -- join to OKE_K_HEADERS and for some reason the combined SELECT

425: UNION ALL
426: --
427: -- Second part of the union retrieves program level assignment.
428: -- This is separated from the first part because it requires a
429: -- join to OKE_K_HEADERS and for some reason the combined SELECT
430: -- results in a FTS of PA_PROJECT_PARTIES.
431: --
432: SELECT Project_Role_ID
433: , 2

Line 435: , oke_k_headers kh

431: --
432: SELECT Project_Role_ID
433: , 2
434: FROM pa_project_parties pp
435: , oke_k_headers kh
436: WHERE kh.k_header_id = C_K_Header_ID
437: AND pp.object_type = 'OKE_PROGRAMS'
438: AND pp.object_id = kh.program_id
439: AND pp.resource_type_id = 101