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.CZ_TYPES dependencies on DUAL

Line 122: SELECT '1' INTO l_flag FROM dual

118: RETURN TRUE;
119:
120: ELSIF (l.ps_node_type IN(PS_NODE_TYPE_REFERENCE) AND l.maximum_selected<>1) THEN
121: BEGIN
122: SELECT '1' INTO l_flag FROM dual
123: WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES
124: WHERE ps_node_id=l.reference_id AND
125: deleted_flag='0' AND ps_node_type=PS_NODE_TYPE_BOM_MODEL);
126: RETURN TRUE;

Line 585: FROM dual

581: retval NUMBER;
582: BEGIN
583: SELECT 1
584: INTO retval
585: FROM dual
586: WHERE EXISTS (
587: SELECT *
588: FROM CZ_NODE_NO_PROPERTIES_V lov
589: WHERE lov.ps_node_id = p_ps_node_id

Line 607: FROM dual

603: retval NUMBER;
604: BEGIN
605: SELECT 1
606: INTO retval
607: FROM dual
608: WHERE EXISTS (
609: SELECT *
610: FROM CZ_NODE_USER_PROPERTIES_V lov
611: WHERE lov.ps_node_id = p_ps_node_id

Line 630: FROM dual

626: retval NUMBER;
627: BEGIN
628: SELECT 1
629: INTO retval
630: FROM dual
631: WHERE EXISTS (
632: SELECT *
633: FROM CZ_NODE_CAPTION_PROPERTIES_V lov
634: WHERE lov.ps_node_id = p_ps_node_id