APPS.CSI_ITEM_INSTANCE_PUB dependencies on CZ_CONFIG_ITEMS_V

Line 807: FROM cz_config_items_v

803: ,config_rev_nbr
804: INTO l_component_ins_type
805: ,l_config_hdr_id
806: ,l_config_rev_nbr
807: FROM cz_config_items_v
808: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
809: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
810: AND config_item_id = p_instance_rec.config_inst_item_id;
811: EXCEPTION

Line 2695: FROM cz_config_items_v

2691: ,config_rev_nbr
2692: INTO l_component_ins_type
2693: ,l_config_hdr_id
2694: ,l_config_rev_nbr
2695: FROM cz_config_items_v
2696: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
2697: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
2698: AND config_item_id = p_instance_rec.config_inst_item_id;
2699: EXCEPTION

Line 3777: FROM cz_config_items_v

3773: ,config_rev_nbr
3774: INTO l_component_ins_type
3775: ,l_config_hdr_id
3776: ,l_config_rev_nbr
3777: FROM cz_config_items_v
3778: WHERE instance_hdr_id = p_instance_rec.config_inst_hdr_id
3779: AND instance_rev_nbr = p_instance_rec.config_inst_rev_num
3780: AND config_item_id = p_instance_rec.config_inst_item_id;
3781: EXCEPTION