APPS.CSI_ITEM_INSTANCE_PUB dependencies on CZ_CONFIG_HDRS

Line 96: ,cz_config_hdrs_v h

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

Line 115: ,cz_config_hdrs h

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

Line 1341: ,cz_config_hdrs_v h

1337: SELECT instance_hdr_id
1338: ,config_item_id
1339: ,has_failures
1340: FROM cz_config_details_v d
1341: ,cz_config_hdrs_v h
1342: WHERE d.instance_hdr_id = h.config_hdr_id
1343: AND d.instance_rev_nbr = h.config_rev_nbr
1344: AND d.component_instance_type = 'I'
1345: AND d.config_hdr_id = p_config_hdr_id

Line 1360: ,cz_config_hdrs h

1356: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is
1357: SELECT has_failures
1358: ,config_status
1359: FROM cz_config_details_v d
1360: ,cz_config_hdrs h
1361: WHERE d.instance_hdr_id = p_config_ins_hdr_id
1362: AND d.instance_rev_nbr = p_config_ins_rev_nbr
1363: -- AND d.component_instance_type = 'I'
1364: AND d.config_hdr_id = h.config_hdr_id

Line 3487: ,cz_config_hdrs_v h

3483: SELECT instance_hdr_id
3484: ,config_item_id
3485: ,has_failures
3486: FROM cz_config_details_v d
3487: ,cz_config_hdrs_v h
3488: WHERE d.instance_hdr_id = h.config_hdr_id
3489: AND d.instance_rev_nbr = h.config_rev_nbr
3490: AND d.component_instance_type = 'I'
3491: AND d.config_hdr_id = p_config_hdr_id

Line 3506: ,cz_config_hdrs h

3502: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is
3503: SELECT has_failures
3504: ,config_status
3505: FROM cz_config_details_v d
3506: ,cz_config_hdrs h
3507: WHERE d.instance_hdr_id = p_config_ins_hdr_id
3508: AND d.instance_rev_nbr = p_config_ins_rev_nbr
3509: -- AND d.component_instance_type = 'I'
3510: AND d.config_hdr_id = h.config_hdr_id