APPS.PJM_PROJTASK_DELETION dependencies on MTL_MATERIAL_TRANSACTIONS

Line 93: FROM mtl_material_transactions mmt

89: FROM dual
90: WHERE
91: EXISTS (
92: SELECT 1
93: FROM mtl_material_transactions mmt
94: WHERE (mmt.source_project_id = l_project_id
95: AND mmt.source_task_Id = NVL(p_task_id, mmt.source_task_id)
96: ) );
97: CURSOR c6 IS

Line 155: FROM mtl_material_transactions mmt

151: FROM dual
152: WHERE
153: EXISTS (
154: SELECT 1
155: FROM mtl_material_transactions mmt
156: WHERE (mmt.project_id = l_project_id
157: AND mmt.task_id = NVL(p_task_id, mmt.task_id)
158: ));
159:

Line 166: FROM mtl_material_transactions mmt

162: FROM dual
163: WHERE
164: EXISTS (
165: SELECT 1
166: FROM mtl_material_transactions mmt
167: WHERE (mmt.project_id = l_project_id
168: AND mmt.to_task_id = NVL(p_task_id, mmt.to_task_id)
169: ));
170:

Line 356: FROM mtl_material_transactions mmt

352: AND loc.organization_id = p_org_id
353: ) OR
354: EXISTS (
355: SELECT 1
356: FROM mtl_material_transactions mmt
357: WHERE (mmt.project_id = p_project_id
358: AND mmt.organization_id = p_org_id
359: )
360: OR (mmt.to_project_id = p_project_id