APPS.OKE_DTS_WORKFLOW dependencies on OKE_K_HEADERS

Line 110: , OKE_K_HEADERS_FULL_V H

106: , W.WF_PROCESS
107: FROM OKE_K_DELIVERABLES_VL D
108: , OKE_WORKFLOWS W
109: , OKC_K_HEADERS_B B
110: , OKE_K_HEADERS_FULL_V H
111: , OKC_K_LINES_B S
112: , OKE_SYSTEM_ITEMS_V I
113: WHERE D.DELIVERABLE_ID = P_DELIVERABLE_ID
114: AND W.SOURCE_CODE = 'DTS'

Line 147: select authoring_org_id from oke_k_headers_v where

143: L_WF_User_Key VARCHAR2(240);
144: L_org_id NUMBER;
145:
146: CURSOR c_org is
147: select authoring_org_id from oke_k_headers_v where
148: k_header_id=p_k_header_id;
149: BEGIN
150:
151: open c_org;

Line 369: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1

365: -- WHERE A. K_HEADER_ID = P_K_HEADER_ID
366: -- AND A.ROLE_ID = P_ROLE_ID
367: -- AND R.ORIG_SYSTEM = 'PER'
368: -- AND R.ORIG_SYSTEM_ID = A.PERSON_ID
369: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1
370: -- ,'SITE',2
371: -- ,3)
372: -- ;
373:

Line 607: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1

603: -- WHERE A. K_HEADER_ID = P_K_HEADER_ID
604: -- AND A.ROLE_ID = P_ROLE_ID
605: -- AND R.ORIG_SYSTEM = 'PER'
606: -- AND R.ORIG_SYSTEM_ID = A.PERSON_ID
607: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1
608: -- ,'SITE',2
609: -- ,3)
610: -- ;
611:

Line 1467: , oke_k_headers h

1463: From oke_k_deliverables_b d
1464: , pa_projects_all p
1465: , pa_tasks t
1466: , oke_system_items_v i
1467: , oke_k_headers h
1468: , okc_k_headers_b b
1469: , okc_k_lines_b s
1470: Where D.Deliverable_Id = P_Id
1471: And B.Id = D.K_Header_Id

Line 1673: , oke_k_headers h

1669: From oke_k_deliverables_b d
1670: , pa_projects_all p
1671: , pa_tasks t
1672: , oke_system_items_v i
1673: , oke_k_headers h
1674: , okc_k_headers_b b
1675: , okc_k_lines_b s
1676: Where D.Deliverable_Id = P_Id
1677: And B.Id = D.K_Header_Id

Line 1877: , oke_k_headers h

1873: From oke_k_deliverables_b d
1874: , pa_projects_all p
1875: , pa_tasks t
1876: , oke_system_items_v i
1877: , oke_k_headers h
1878: , okc_k_headers_b b
1879: , okc_k_lines_b s
1880: Where D.Deliverable_Id = P_Id
1881: And B.Id = D.K_Header_Id

Line 2429: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1

2425: -- WHERE A. K_HEADER_ID = P_K_HEADER_ID
2426: -- AND A.ROLE_ID = P_ROLE_ID
2427: -- AND R.ORIG_SYSTEM = 'PER'
2428: -- AND R.ORIG_SYSTEM_ID = A.PERSON_ID
2429: -- ORDER BY DECODE(ASSIGNMENT_LEVEL,'OKE_K_HEADERS',1
2430: -- ,'SITE',2
2431: -- ,3)
2432: -- ;
2433: