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.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 306: FROM AMW_CONTROL_ASSOCIATIONS ctrls,

302: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
303: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
304: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
305: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
306: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
307: AMW_CONTROLS_ALL_VL all_ctrls,
308: HR_ALL_ORGANIZATION_UNITS o,
309: HR_ALL_ORGANIZATION_UNITS_TL otl,
310: AMW_OPINIONS_LOG_V op

Line 353: from amw_control_associations aca

349: ,G_USER_ID
350: ,sysdate
351: ,G_USER_ID
352: ,G_LOGIN_ID
353: from amw_control_associations aca
354: ,amw_opinions_log_v aolv
355: ,amw_latest_revisions_v alrv
356: ,HR_ALL_ORGANIZATION_UNITS haou
357: ,HR_ALL_ORGANIZATION_UNITS_TL haout

Line 413: FROM amw_control_associations aca

409: bug 4862301 fix
410: **/
411: SELECT decode(count(aca.control_id),0,'N','Y')
412: into l_key_control
413: FROM amw_control_associations aca
414: ,amw_controls_b acb
415: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
416: AND aca.pk1 = r_load_cols.certification_id
417: AND aca.pk2 = r_load_cols.organization_id

Line 675: FROM amw_control_associations aca

671: bug 4862301 fix
672: **/
673: SELECT decode(count(aca.control_id),0,'N','Y')
674: into l_key_control
675: FROM amw_control_associations aca
676: ,amw_controls_b acb
677: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
678: AND aca.pk1 = r_load_cols.certification_id
679: AND aca.pk2 = r_load_cols.organization_id

Line 921: FROM AMW_CONTROL_ASSOCIATIONS ctrls,

917: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
918: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
919: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
920: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
921: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
922: AMW_CONTROLS_ALL_VL all_ctrls,
923: HR_ALL_ORGANIZATION_UNITS o,
924: HR_ALL_ORGANIZATION_UNITS_TL otl,
925: AMW_OPINIONS_LOG_V op

Line 960: FROM amw_control_associations aca

956: bug 4862301 fix
957: **/
958: SELECT decode(count(aca.control_id),0,'N','Y')
959: into l_key_control
960: FROM amw_control_associations aca
961: ,amw_controls_b acb
962: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
963: AND aca.pk1 = r_load_cols.certification_id
964: AND aca.pk2 = r_load_cols.organization_id

Line 1199: FROM amw_control_associations aca

1195: bug 4862301 fix
1196: **/
1197: SELECT decode(count(aca.control_id),0,'N','Y')
1198: into l_key_control
1199: FROM amw_control_associations aca
1200: ,amw_controls_b acb
1201: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
1202: AND aca.pk1 = r_load_cols.certification_id
1203: AND aca.pk2 = r_load_cols.organization_id