APPS.INV_UI_TASK_LOVS dependencies on PJM_TASKS_MTLL_V

Line 29: FROM pjm_tasks_mtll_v t

25: OPEN x_tasks FOR
26: SELECT t.task_id,
27: NVL ( t.task_number, ' ' ),
28: NVL ( t.task_name, ' ' )
29: FROM pjm_tasks_mtll_v t
30: WHERE t.task_number LIKE ( p_restrict_tasks )
31: AND t.project_id = p_project_id
32: ORDER BY 2;
33: END GET_TASKS;

Line 48: FROM pjm_tasks_mtll_v t

44: OPEN x_tasks FOR
45: SELECT t.task_id,
46: NVL ( t.task_number, ' ' ),
47: NVL ( t.task_name, ' ' )
48: FROM pjm_tasks_mtll_v t
49: WHERE t.task_number LIKE ( p_restrict_tasks )
50: AND t.project_id = p_project_id
51: AND t.task_id IN (
52: SELECT mtrl.task_id

Line 74: FROM pjm_tasks_mtll_v t,

70: OPEN x_tasks FOR
71: SELECT DISTINCT t.task_id,
72: NVL ( t.task_number, ' ' ),
73: NVL ( t.task_name, ' ' )
74: FROM pjm_tasks_mtll_v t,
75: mtl_cycle_count_entries mcce,
76: mtl_item_locations mil
77: WHERE t.project_id = p_project_id
78: AND mcce.organization_id = mil.organization_id

Line 92: FROM pjm_tasks_mtll_v t

88: OPEN x_tasks FOR
89: SELECT t.task_id,
90: NVL ( t.task_number, ' ' ),
91: NVL ( t.task_name, ' ' )
92: FROM pjm_tasks_mtll_v t
93: WHERE t.task_number LIKE ( p_restrict_tasks )
94: AND t.project_id = p_project_id
95: ORDER BY 2;
96: END IF;

Line 114: FROM pjm_tasks_mtll_v t,

110: OPEN x_tasks FOR
111: SELECT t.task_id,
112: NVL ( t.task_number, ' ' ),
113: NVL ( t.task_name, ' ' )
114: FROM pjm_tasks_mtll_v t,
115: mtl_physical_inventory_tags mpi,
116: mtl_item_locations mil
117: WHERE t.project_id = p_project_id
118: AND mil.inventory_location_id = mpi.locator_id

Line 130: FROM pjm_tasks_mtll_v t

126: OPEN x_tasks FOR
127: SELECT t.task_id,
128: NVL ( t.task_number, ' ' ),
129: NVL ( t.task_name, ' ' )
130: FROM pjm_tasks_mtll_v t
131: WHERE t.task_number LIKE ( p_restrict_tasks )
132: AND t.project_id = p_project_id
133: ORDER BY 2;
134: END IF;

Line 161: FROM pjm_tasks_mtll_v t,

157: OPEN x_tasks FOR
158: SELECT DISTINCT t.task_id,
159: NVL ( t.task_number, ' ' ),
160: NVL ( t.task_name, ' ' )
161: FROM pjm_tasks_mtll_v t,
162: po_distributions_all pod,
163: po_line_locations_all poll
164: WHERE pod.task_id = t.task_id
165: AND pod.po_header_id = p_po_header_id

Line 216: FROM pjm_tasks_mtll_v t,

212: OPEN x_tasks FOR
213: SELECT DISTINCT t.task_id,
214: NVL ( t.task_number, ' ' ),
215: NVL ( t.task_name, ' ' )
216: FROM pjm_tasks_mtll_v t,
217: po_distributions_all pod
218: WHERE pod.task_id = t.task_id
219: AND pod.po_header_id = p_po_header_id
220: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )

Line 248: FROM pjm_tasks_mtll_v t,

244: OPEN x_tasks FOR
245: SELECT DISTINCT t.task_id,
246: NVL ( t.task_number, ' ' ),
247: NVL ( t.task_name, ' ' )
248: FROM pjm_tasks_mtll_v t,
249: po_requisition_lines_all prl,
250: po_req_distributions_all prd
251: WHERE prd.requisition_line_id = prl.requisition_line_id
252: AND prl.requisition_header_id = p_req_header_id

Line 289: FROM pjm_tasks_mtll_v t,

285: OPEN x_tasks FOR
286: SELECT DISTINCT t.task_id,
287: NVL ( t.task_number, ' ' ),
288: NVL ( t.task_name, ' ' )
289: FROM pjm_tasks_mtll_v t,
290: oe_order_lines_all oel
291: WHERE oel.project_id = t.project_id
292: AND t.project_id = p_project_id
293: AND oel.task_id = t.task_id

Line 314: FROM pjm_tasks_mtll_v t,

310: OPEN x_tasks FOR
311: SELECT DISTINCT t.task_id,
312: NVL ( t.task_number, ' ' ),
313: NVL ( t.task_name, ' ' )
314: FROM pjm_tasks_mtll_v t,
315: po_distributions_all pod,
316: rcv_shipment_lines rsl
317: WHERE rsl.shipment_header_id = p_shipment_id
318: AND rsl.po_header_id =