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_RUNTIME dependencies on DUAL

Line 1036: FROM dual

1032: uipages.ui_def_id AS TARGET_UI_DEF_ID,
1033: uipages.page_id AS TARGET_PAGE_ID,
1034: (SELECT annotated_node_path(l_root_model_id,
1035: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,UIPAGES.persistent_node_id,p_root_model_expl_id)
1036: FROM dual
1037: ) AS TARGET_PAGE_ANN_PATH,
1038: uipages.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID,
1039: uipages.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP,
1040: uipages.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE,

Line 1047: FROM dual

1043: uiels.ui_def_id,
1044: uiels.page_id,
1045: (SELECT get_TARGET_PAGE_REF_DEPTH(l_root_model_id,
1046: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,p_root_model_expl_id)
1047: FROM dual
1048: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1049: '0' AS BOUND_VIA_PARENT_FLAG
1050: FROM
1051: CZ_UI_PAGES uipages,

Line 1065: FROM dual

1061: uipages.ui_def_id AS TARGET_UI_DEF_ID,
1062: uipages.page_id AS TARGET_PAGE_ID,
1063: (SELECT annotated_node_path(l_root_model_id,
1064: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,UIPAGES.persistent_node_id,p_root_model_expl_id)
1065: FROM dual
1066: ) AS TARGET_PAGE_ANN_PATH,
1067: uipages.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID,
1068: uipages.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP,
1069: uipages.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE,

Line 1076: FROM dual

1072: uiels.ui_def_id,
1073: uiels.page_id,
1074: (SELECT get_TARGET_PAGE_REF_DEPTH(l_root_model_id,
1075: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,p_root_model_expl_id)
1076: FROM dual
1077: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1078: '1' AS BOUND_VIA_PARENT_FLAG
1079: FROM
1080: CZ_UI_PAGES uipages,

Line 1090: (SELECT p_root_ui_def_id FROM dual

1086: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1087: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id
1088: )
1089: WHERE TARGET_UI_DEF_ID IN
1090: (SELECT p_root_ui_def_id FROM dual
1091: UNION
1092: SELECT ref_ui_def_id FROM cz_ui_refs
1093: START WITH ui_def_id=p_root_ui_def_id AND deleted_flag='0'
1094: CONNECT BY PRIOR ref_ui_def_id=ui_def_id AND deleted_flag='0') AND

Line 1124: FROM dual

1120: uipages.ui_def_id AS TARGET_UI_DEF_ID,
1121: uipages.page_id AS TARGET_PAGE_ID,
1122: (SELECT annotated_node_path(l_root_model_id,
1123: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,UIPAGES.persistent_node_id,p_root_model_expl_id)
1124: FROM dual
1125: ) AS TARGET_PAGE_ANN_PATH,
1126: uipages.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID,
1127: uipages.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP,
1128: uipages.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE,

Line 1135: FROM dual

1131: uiels.ui_def_id,
1132: uiels.page_id,
1133: (SELECT get_TARGET_PAGE_REF_DEPTH(l_root_model_id,
1134: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,p_root_model_expl_id)
1135: FROM dual
1136: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1137: '0' AS BOUND_VIA_PARENT_FLAG
1138: FROM
1139: CZ_UI_PAGES uipages,

Line 1153: FROM dual

1149: uipages.ui_def_id AS TARGET_UI_DEF_ID,
1150: uipages.page_id AS TARGET_PAGE_ID,
1151: (SELECT annotated_node_path(l_root_model_id,
1152: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,UIPAGES.persistent_node_id,p_root_model_expl_id)
1153: FROM dual
1154: ) AS TARGET_PAGE_ANN_PATH,
1155: uipages.DISPLAY_CONDITION_ID AS TARGET_PAGE_DISPCOND_ID,
1156: uipages.DISPLAY_CONDITION_COMP AS TARGET_PAGE_DISPCOND_COMP,
1157: uipages.DISPLAY_CONDITION_VALUE AS TARGET_PAGE_DISPCOND_VALUE,

Line 1164: FROM dual

1160: uiels.ui_def_id,
1161: uiels.page_id,
1162: (SELECT get_TARGET_PAGE_REF_DEPTH(l_root_model_id,
1163: UIPAGES.PAGEBASE_EXPL_NODE_ID,UIPAGES.ui_def_id,p_root_model_expl_id)
1164: FROM dual
1165: ) AS TARGET_PAGE_REFERENCE_DEPTH,
1166: '1' AS BOUND_VIA_PARENT_FLAG
1167: FROM
1168: CZ_UI_PAGES uipages,

Line 1177: (SELECT p_root_ui_def_id FROM dual

1173: els.target_page_ui_def_id= PRIOR els.ui_def_id AND
1174: els.target_page_id= PRIOR els.page_id AND deleted_flag='0' AND PRIOR deleted_flag='0') uiels
1175: WHERE uipages.page_id=uiels.page_id AND uipages.ui_def_id=uiels.ui_def_id )
1176: WHERE TARGET_UI_DEF_ID IN
1177: (SELECT p_root_ui_def_id FROM dual
1178: UNION
1179: SELECT ref_ui_def_id FROM cz_ui_refs
1180: START WITH ui_def_id=p_root_ui_def_id AND deleted_flag='0'
1181: CONNECT BY PRIOR ref_ui_def_id=ui_def_id AND deleted_flag='0') AND