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 275: , oke_system_items_v i

271: , D.Direction
272: From oke_k_deliverables_b d
273: , pa_projects_all p
274: , pa_tasks t
275: , oke_system_items_v i
276: , oke_k_headers h
277: , okc_k_headers_b b
278: , okc_k_lines_b s
279: Where D.K_Line_Id = P_Id

Line 329: , oke_system_items_v i

325: , D.Direction
326: From oke_k_deliverables_b d
327: , pa_projects_all p
328: , pa_tasks t
329: , oke_system_items_v i
330: , oke_k_headers h
331: , okc_k_headers_b b
332: , okc_k_lines_b s
333: Where D.Deliverable_Id = P_Id

Line 375: , oke_system_items_v i

371: , D.Direction
372: From oke_k_deliverables_b d
373: , pa_projects_all p
374: , pa_tasks t
375: , oke_system_items_v i
376: , oke_k_headers h
377: , okc_k_headers_b b
378: , okc_k_lines_b s
379: Where D.K_Header_Id = P_Id

Line 426: , oke_system_items_v i

422: , D.Direction
423: From oke_k_deliverables_b d
424: , pa_projects_all p
425: , pa_tasks t
426: , oke_system_items_v i
427: , oke_k_headers h
428: , okc_k_headers_b b
429: , okc_k_lines_b s
430: Where D.K_Line_Id = P_Id

Line 477: , oke_system_items_v i

473: , D.Direction
474: From oke_k_deliverables_b d
475: , pa_projects_all p
476: , pa_tasks t
477: , oke_system_items_v i
478: , oke_k_headers h
479: , okc_k_headers_b b
480: , okc_k_lines_b s
481: Where D.Deliverable_Id = P_Id

Line 523: , oke_system_items_v i

519: , D.Direction
520: From oke_k_deliverables_b d
521: , pa_projects_all p
522: , pa_tasks t
523: , oke_system_items_v i
524: , oke_k_headers h
525: , okc_k_headers_b b
526: , okc_k_lines_b s
527: Where D.K_Header_Id = P_Id

Line 570: , oke_system_items_v i

566: , D.Direction
567: From oke_k_deliverables_b d
568: , pa_projects_all p
569: , pa_tasks t
570: , oke_system_items_v i
571: , oke_k_headers h
572: , okc_k_headers_b b
573: , okc_k_lines_b s
574: Where D.K_Line_Id = P_Id

Line 617: , oke_system_items_v i

613: , D.Direction
614: From oke_k_deliverables_b d
615: , pa_projects_all p
616: , pa_tasks t
617: , oke_system_items_v i
618: , oke_k_headers h
619: , okc_k_headers_b b
620: , okc_k_lines_b s
621: Where D.Deliverable_Id = P_Id