APPS.CSI_ITEM_INSTANCE_PUB dependencies on CZ_CONFIG_HDRS_V

Line 97: ,cz_config_hdrs_v h

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'
101: AND d.config_hdr_id = p_config_hdr_id

Line 1361: ,cz_config_hdrs_v h

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'
1365: AND d.config_hdr_id = p_config_hdr_id

Line 3524: ,cz_config_hdrs_v h

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'
3528: AND d.config_hdr_id = p_config_hdr_id