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.

[Home] [Help]

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 590: FROM dual

586: retval NUMBER;
587: BEGIN
588: SELECT 1
589: INTO retval
590: FROM dual
591: WHERE EXISTS (
592: SELECT *
593: FROM CZ_NODE_NO_PROPERTIES_V lov
594: WHERE lov.ps_node_id = p_ps_node_id

Line 612: FROM dual

608: retval NUMBER;
609: BEGIN
610: SELECT 1
611: INTO retval
612: FROM dual
613: WHERE EXISTS (
614: SELECT *
615: FROM CZ_NODE_USER_PROPERTIES_V lov
616: WHERE lov.ps_node_id = p_ps_node_id

Line 635: FROM dual

631: retval NUMBER;
632: BEGIN
633: SELECT 1
634: INTO retval
635: FROM dual
636: WHERE EXISTS (
637: SELECT *
638: FROM CZ_NODE_CAPTION_PROPERTIES_V lov
639: WHERE lov.ps_node_id = p_ps_node_id