APPS.OKE_DTS_ACTION_PKG dependencies on OKE_SYSTEM_ITEMS_V

Line 87: From oke_system_items_v

83: Cursor Item_C(P_Inventory_Org_Id Number
84: , P_Item_Id Number) Is
85:
86: Select 'x'
87: From oke_system_items_v
88: Where Organization_Id = P_Inventory_Org_Id
89: And Inventory_Item_Id = P_Item_Id;
90:
91: L_Result Varchar2(1);

Line 221: , oke_system_items_v i

217: , D.Direction
218: From oke_k_deliverables_b d
219: , pa_projects_all p
220: , pa_tasks t
221: , oke_system_items_v i
222: , oke_k_headers h
223: , okc_k_headers_b b
224: , okc_k_lines_b s
225: Where D.K_Header_Id = P_Id

Line 267: , oke_system_items_v i

263: , D.Direction
264: From oke_k_deliverables_b d
265: , pa_projects_all p
266: , pa_tasks t
267: , oke_system_items_v i
268: , oke_k_headers h
269: , okc_k_headers_b b
270: , okc_k_lines_b s
271: Where D.K_Line_Id = P_Id

Line 313: , oke_system_items_v i

309: , D.Direction
310: From oke_k_deliverables_b d
311: , pa_projects_all p
312: , pa_tasks t
313: , oke_system_items_v i
314: , oke_k_headers h
315: , okc_k_headers_b b
316: , okc_k_lines_b s
317: Where D.Deliverable_Id = P_Id

Line 359: , oke_system_items_v i

355: , D.Direction
356: From oke_k_deliverables_b d
357: , pa_projects_all p
358: , pa_tasks t
359: , oke_system_items_v i
360: , oke_k_headers h
361: , okc_k_headers_b b
362: , okc_k_lines_b s
363: Where D.K_Header_Id = P_Id

Line 410: , oke_system_items_v i

406: , D.Direction
407: From oke_k_deliverables_b d
408: , pa_projects_all p
409: , pa_tasks t
410: , oke_system_items_v i
411: , oke_k_headers h
412: , okc_k_headers_b b
413: , okc_k_lines_b s
414: Where D.K_Line_Id = P_Id

Line 461: , oke_system_items_v i

457: , D.Direction
458: From oke_k_deliverables_b d
459: , pa_projects_all p
460: , pa_tasks t
461: , oke_system_items_v i
462: , oke_k_headers h
463: , okc_k_headers_b b
464: , okc_k_lines_b s
465: Where D.Deliverable_Id = P_Id

Line 507: , oke_system_items_v i

503: , D.Direction
504: From oke_k_deliverables_b d
505: , pa_projects_all p
506: , pa_tasks t
507: , oke_system_items_v i
508: , oke_k_headers h
509: , okc_k_headers_b b
510: , okc_k_lines_b s
511: Where D.K_Header_Id = P_Id

Line 554: , oke_system_items_v i

550: , D.Direction
551: From oke_k_deliverables_b d
552: , pa_projects_all p
553: , pa_tasks t
554: , oke_system_items_v i
555: , oke_k_headers h
556: , okc_k_headers_b b
557: , okc_k_lines_b s
558: Where D.K_Line_Id = P_Id

Line 601: , oke_system_items_v i

597: , D.Direction
598: From oke_k_deliverables_b d
599: , pa_projects_all p
600: , pa_tasks t
601: , oke_system_items_v i
602: , oke_k_headers h
603: , okc_k_headers_b b
604: , okc_k_lines_b s
605: Where D.Deliverable_Id = P_Id