APPS.INV_UI_TASK_LOVS dependencies on PJM_TASKS_MTLL_V

Line 25: --Bug 12385456 Changing the view from pjm_tasks_mtll_v to pjm_tasks_v as the previous one will

21: p_project_id IN VARCHAR
22: )
23: IS
24: BEGIN
25: --Bug 12385456 Changing the view from pjm_tasks_mtll_v to pjm_tasks_v as the previous one will
26: --show all the tasks including some invalid ones.
27: OPEN x_tasks FOR
28: SELECT t.task_id,
29: NVL ( t.task_number, ' ' ),

Line 50: FROM pjm_tasks_mtll_v t

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

Line 76: FROM pjm_tasks_mtll_v t,

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

Line 94: FROM pjm_tasks_mtll_v t

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

Line 116: FROM pjm_tasks_mtll_v t,

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

Line 132: FROM pjm_tasks_mtll_v t

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

Line 163: FROM pjm_tasks_mtll_v t,

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

Line 218: FROM pjm_tasks_mtll_v t,

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

Line 250: FROM pjm_tasks_mtll_v t,

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

Line 291: FROM pjm_tasks_mtll_v t,

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

Line 316: FROM pjm_tasks_mtll_v t,

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