eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SUB_CG_UTIL dependencies on DUAL

Line 257: SELECT 'Y' INTO l_cannot_delete FROM dual

253: end if;
254:
255: IF p_organization_id IS NULL THEN
256: BEGIN
257: SELECT 'Y' INTO l_cannot_delete FROM dual
258: WHERE
259: exists
260: (SELECT organization_id
261: FROM mtl_parameters mp

Line 270: SELECT 'Y' INTO l_cannot_delete FROM dual

266: END;
267:
268: IF l_cannot_delete = 'N' THEN
269: BEGIN
270: SELECT 'Y' INTO l_cannot_delete FROM dual
271: WHERE
272: exists
273: (SELECT organization_id
274: FROM mtl_secondary_inventories msi

Line 284: SELECT 'Y' INTO l_cannot_delete FROM dual

280: END IF;
281:
282: IF l_cannot_delete = 'N' THEN
283: BEGIN
284: SELECT 'Y' INTO l_cannot_delete FROM dual
285: WHERE
286: exists
287: (SELECT organization_id
288: FROM mtl_material_transactions_temp mmtt

Line 300: SELECT 'Y' INTO l_cannot_delete FROM dual

296: END IF;
297:
298: IF l_cannot_delete = 'N' THEN
299: BEGIN
300: SELECT 'Y' INTO l_cannot_delete FROM dual
301: WHERE
302: exists
303: (SELECT organization_id
304: FROM MTL_ONHAND_QUANTITIES_DETAIL moq

Line 314: SELECT 'Y' INTO l_cannot_delete FROM dual

310: END IF;
311:
312: IF l_cannot_delete = 'N' THEN
313: BEGIN
314: SELECT 'Y' INTO l_cannot_delete FROM dual
315: WHERE
316: exists
317: (SELECT organization_id
318: FROM mtl_material_transactions mmt

Line 329: SELECT 'Y' INTO l_cannot_delete FROM dual

325: END;
326: END IF;
327: ELSE
328: BEGIN
329: SELECT 'Y' INTO l_cannot_delete FROM dual
330: WHERE
331: exists
332: (SELECT organization_id
333: FROM mtl_parameters mp

Line 343: SELECT 'Y' INTO l_cannot_delete FROM dual

339: END;
340:
341: IF l_cannot_delete = 'N' THEN
342: BEGIN
343: SELECT 'Y' INTO l_cannot_delete FROM dual
344: WHERE
345: exists
346: (select organization_id
347: from mtl_secondary_inventories msi

Line 358: SELECT 'Y' INTO l_cannot_delete FROM dual

354: END IF;
355:
356: IF l_cannot_delete = 'N' THEN
357: BEGIN
358: SELECT 'Y' INTO l_cannot_delete FROM dual
359: WHERE
360: exists
361: (SELECT organization_id
362: FROM mtl_material_transactions_temp mmtt

Line 375: SELECT 'Y' INTO l_cannot_delete FROM dual

371: END IF;
372:
373: IF l_cannot_delete = 'N' THEN
374: BEGIN
375: SELECT 'Y' INTO l_cannot_delete FROM dual
376: WHERE
377: exists
378: (SELECT organization_id
379: FROM MTL_ONHAND_QUANTITIES_DETAIL moq

Line 389: SELECT 'Y' INTO l_cannot_delete FROM dual

385: END IF;
386:
387: IF l_cannot_delete = 'N' THEN
388: BEGIN
389: SELECT 'Y' INTO l_cannot_delete FROM dual
390: WHERE
391: exists
392: (SELECT organization_id
393: FROM mtl_material_transactions mmt