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.CSI_ITEM_INSTANCE_PUB dependencies on CZ_CONFIG_DETAILS_V

Line 96: FROM cz_config_details_v d

92: CURSOR config_ins_key (p_config_hdr_id NUMBER, p_config_rev_nbr NUMBER) is
93: SELECT instance_hdr_id
94: ,config_item_id
95: ,has_failures
96: FROM cz_config_details_v d
97: ,cz_config_hdrs_v h
98: WHERE d.instance_hdr_id = h.config_hdr_id
99: AND d.instance_rev_nbr = h.config_rev_nbr
100: AND d.component_instance_type = 'I'

Line 115: FROM cz_config_details_v d

111:
112: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is
113: SELECT has_failures
114: ,config_status
115: FROM cz_config_details_v d
116: ,cz_config_hdrs h
117: WHERE d.instance_hdr_id = p_config_ins_hdr_id
118: AND d.instance_rev_nbr = p_config_ins_rev_nbr
119: -- AND d.component_instance_type = 'I'

Line 1360: FROM cz_config_details_v d

1356: CURSOR config_ins_key (p_config_hdr_id NUMBER, p_config_rev_nbr NUMBER) is
1357: SELECT instance_hdr_id
1358: ,config_item_id
1359: ,has_failures
1360: FROM cz_config_details_v d
1361: ,cz_config_hdrs_v h
1362: WHERE d.instance_hdr_id = h.config_hdr_id
1363: AND d.instance_rev_nbr = h.config_rev_nbr
1364: AND d.component_instance_type = 'I'

Line 1379: FROM cz_config_details_v d

1375:
1376: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is
1377: SELECT has_failures
1378: ,config_status
1379: FROM cz_config_details_v d
1380: ,cz_config_hdrs h
1381: WHERE d.instance_hdr_id = p_config_ins_hdr_id
1382: AND d.instance_rev_nbr = p_config_ins_rev_nbr
1383: -- AND d.component_instance_type = 'I'

Line 3523: FROM cz_config_details_v d

3519: CURSOR config_ins_key (p_config_hdr_id NUMBER, p_config_rev_nbr NUMBER) is
3520: SELECT instance_hdr_id
3521: ,config_item_id
3522: ,has_failures
3523: FROM cz_config_details_v d
3524: ,cz_config_hdrs_v h
3525: WHERE d.instance_hdr_id = h.config_hdr_id
3526: AND d.instance_rev_nbr = h.config_rev_nbr
3527: AND d.component_instance_type = 'I'

Line 3542: FROM cz_config_details_v d

3538:
3539: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is
3540: SELECT has_failures
3541: ,config_status
3542: FROM cz_config_details_v d
3543: ,cz_config_hdrs h
3544: WHERE d.instance_hdr_id = p_config_ins_hdr_id
3545: AND d.instance_rev_nbr = p_config_ins_rev_nbr
3546: -- AND d.component_instance_type = 'I'