DBA Data[Home] [Help]

APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on CZ_CONFIG_ITEMS_V

Line 123: from cz_config_items_v cz

119: -- get the display order for the subject
120: Begin
121: Select to_number(substr(cz.bom_sort_order,length(bom_sort_order)-3,4))
122: into p_txn_ii_rltns_rec.display_order
123: from cz_config_items_v cz
124: where cz.instance_hdr_id = p_txn_ii_rltns_rec.sub_config_inst_hdr_id
125: and cz.instance_rev_nbr = p_txn_ii_rltns_rec.sub_config_inst_rev_num
126: and cz.config_item_id = p_txn_ii_rltns_rec.sub_config_inst_item_id;
127: Exception when others then

Line 631: from cz_config_items_v cz

627: -- get the display order for the subject
628: Begin
629: Select to_number(substr(cz.bom_sort_order,length(bom_sort_order)-3,4))
630: into l_iir_rec.display_order
631: from cz_config_items_v cz
632: where cz.instance_hdr_id = p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id
633: and cz.instance_rev_nbr= p_txn_ii_rltns_tbl(l_ind).sub_config_inst_rev_num
634: and cz.config_item_id = p_txn_ii_rltns_tbl(l_ind).sub_config_inst_item_id;
635: Exception when others then