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.CZ_IB_TRANSACTIONS dependencies on CZ_CONFIG_ITEMS

Line 911: v_ib_trackable CZ_CONFIG_ITEMS.ib_trackable%TYPE;

907: t_cfg_hash int_array_tbl_type;
908: t_hash_changed_item_tbl int_array_tbl_type_idx_vc2; -- Bug 6892148;
909: t_hash_src_txn_flag_tbl char_array_tbl_type_idx_vc2; -- kdande; 27-Nov-2008; Bug 7599508;
910: t_tangible_item_flag_tbl char_array_tbl_type;
911: v_ib_trackable CZ_CONFIG_ITEMS.ib_trackable%TYPE;
912:
913: v_relationship_type_code VARCHAR2(255);
914: v_txn_line_ind NUMBER;
915: v_txn_line_dtls_ind NUMBER;

Line 946: FOR i IN(SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS_V

942: -- nontrackable items ( IB_TRACKABLE = '0' )
943: -- also will be collected here
944: --
945:
946: FOR i IN(SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS_V
947: WHERE instance_hdr_id=p_config_hdr_id AND
948: instance_rev_nbr=p_config_rev_nbr)
949: LOOP
950: LOG_REPORT(m_RUN_ID,'config_hdr_id='||TO_CHAR(i.config_hdr_id)||' config_rev_nbr='||TO_CHAR(i.config_rev_nbr));

Line 1002: (SELECT * FROM CZ_CONFIG_ITEMS ci

998: t_component_instance_type_tbl,
999: t_tangible_item_flag_tbl,
1000: t_name_tbl
1001: FROM
1002: (SELECT * FROM CZ_CONFIG_ITEMS ci
1003: START WITH ci.instance_hdr_id=p_config_hdr_id AND
1004: ci.instance_rev_nbr=p_config_rev_nbr AND component_instance_type='I' AND deleted_flag='0'
1005: CONNECT BY PRIOR ci.config_item_id=ci.parent_config_item_id AND
1006: ci.instance_hdr_id=p_config_hdr_id AND

Line 1032: SELECT NVL(ib_trackable,NO_FLAG) INTO v_ib_trackable FROM CZ_CONFIG_ITEMS_V

1028: LOOP
1029: IF t_target_item_tbl(i) IS NOT NULL THEN
1030: v_ib_trackable:=NO_FLAG;
1031: BEGIN
1032: SELECT NVL(ib_trackable,NO_FLAG) INTO v_ib_trackable FROM CZ_CONFIG_ITEMS_V
1033: WHERE instance_hdr_id = t_target_hdr_tbl(i) AND
1034: instance_rev_nbr = t_target_rev_nbr_tbl(i) AND
1035: config_item_id = t_target_item_tbl(i);
1036: EXCEPTION

Line 1069: FROM CZ_CONFIG_ITEMS_V

1065: BEGIN
1066: v_root_config_item_id:=NULL;
1067: SELECT instance_hdr_id,instance_rev_nbr,parent_config_item_id
1068: INTO v_root_instance_hdr_id,v_root_instance_rev_nbr,v_root_config_item_id
1069: FROM CZ_CONFIG_ITEMS_V
1070: WHERE instance_hdr_id=p_config_hdr_id AND
1071: instance_rev_nbr=p_config_rev_nbr AND
1072: config_item_id=p_config_item_id;
1073: EXCEPTION

Line 1208: FROM CZ_CONFIG_ITEMS_V

1204:
1205: BEGIN
1206: SELECT target_hdr_id,target_rev_nbr,target_config_item_id
1207: INTO v_target_hdr_id,v_target_rev_nbr,v_target_config_item_id
1208: FROM CZ_CONFIG_ITEMS_V
1209: WHERE instance_hdr_id=t_instance_hdr_tbl(i) AND instance_rev_nbr=v_baseline_rev_nbr AND
1210: config_item_id=t_config_item_tbl(i);
1211:
1212: IF NOT(v_target_hdr_id=t_target_hdr_tbl(i) AND v_target_config_item_id=t_target_item_tbl(i)) THEN

Line 1497: FROM CZ_CONFIG_ITEMS

1493: v_status VARCHAR2(255):='';
1494: BEGIN
1495: SELECT ext_activated_flag||config_delta
1496: INTO v_status
1497: FROM CZ_CONFIG_ITEMS
1498: WHERE instance_hdr_id = p_instance_hdr_id AND
1499: instance_rev_nbr = p_instance_rev_nbr AND
1500: component_instance_type='I' AND
1501: deleted_flag='0';

Line 1575: FROM CZ_CONFIG_ITEMS_V

1571: IF v_status NOT IN ('00','000','0000')THEN
1572:
1573: SELECT config_item_id
1574: BULK COLLECT INTO t_config_item_tbl
1575: FROM CZ_CONFIG_ITEMS_V
1576: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1577: instance_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND
1578: ib_trackable='1';
1579:

Line 1606: FROM CZ_CONFIG_ITEMS_V

1602: --
1603: -- collect all Connectors that we are passing
1604: --
1605: FOR k IN (SELECT target_hdr_id,target_rev_nbr,target_config_item_id,config_item_id
1606: FROM CZ_CONFIG_ITEMS_V
1607: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1608: instance_rev_nbr=p_config_instance_tbl(i).new_config_rev_nbr AND
1609: target_config_item_id IS NOT NULL)
1610: LOOP

Line 1615: FROM CZ_CONFIG_ITEMS_V

1611: BEGIN
1612: IF v_baseline_rev_nbr IS NOT NULL THEN
1613: SELECT target_hdr_id,target_rev_nbr,target_config_item_id
1614: INTO v_target_hdr_id,v_target_rev_nbr,v_target_config_item_id
1615: FROM CZ_CONFIG_ITEMS_V
1616: WHERE instance_hdr_id=p_config_instance_tbl(i).config_hdr_id AND
1617: instance_rev_nbr=v_baseline_rev_nbr AND config_item_id=k.config_item_id;
1618:
1619:

Line 1781: FOR t IN (SELECT config_item_id FROM cz_config_items

1777:
1778: v_cfg_item_id := t_expired_rltns_tbl(nn).sub_config_inst_item_id;
1779:
1780: -- find the nearest item which has a corresponding txn line
1781: FOR t IN (SELECT config_item_id FROM cz_config_items
1782: WHERE config_item_id<>v_cfg_item_id
1783: START WITH config_item_id=v_cfg_item_id AND
1784: instance_hdr_id=t_expired_rltns_tbl(nn).sub_config_inst_hdr_id AND
1785: instance_rev_nbr=t_expired_rltns_tbl(nn).sub_config_inst_rev_num

Line 2011: ' (SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS ' ||

2007: 'BEGIN ' ||
2008: ' UPDATE CSI_T_TRANSACTION_LINES ' ||
2009: ' SET config_valid_status = '||v_config_status ||
2010: ' WHERE (config_session_hdr_id,config_session_rev_num) IN ' ||
2011: ' (SELECT DISTINCT config_hdr_id,config_rev_nbr FROM CZ_CONFIG_ITEMS ' ||
2012: ' WHERE instance_hdr_id=:1 AND ' ||
2013: ' instance_rev_nbr IN(:2,:3) AND deleted_flag=''0''); ' ||
2014: ' END;' USING p_config_instance_tbl(i).config_hdr_id,p_config_instance_tbl(i).old_config_rev_nbr,p_config_instance_tbl(i).new_config_rev_nbr;
2015:

Line 2278: 'FROM CZ_CONFIG_ITEMS_V ' ||

2274: 'SELECT ' ||
2275: ' config_item_id ' ||
2276: 'BULK COLLECT INTO ' ||
2277: ' CZ_IB_TRANSACTIONS.m_config_item_tbl ' ||
2278: 'FROM CZ_CONFIG_ITEMS_V ' ||
2279: 'WHERE instance_hdr_id=:1 AND instance_rev_nbr=:2 ' ||
2280: ' AND CZ_UTILS.conv_num(item_val) IS NOT NULL AND ib_trackable=''1''; ' ||
2281: 'END;'
2282: USING p_config_hdr_id,p_config_rev_nbr;

Line 2761: FROM CZ_CONFIG_ITEMS

2757: -- collect all instances
2758: --
2759: SELECT instance_hdr_id,instance_rev_nbr,config_item_id
2760: BULK COLLECT INTO t_instance_hdr_tbl,t_instance_rev_nbr_tbl,t_config_item_tbl
2761: FROM CZ_CONFIG_ITEMS
2762: WHERE config_hdr_id = p_config_hdr_id AND
2763: config_rev_nbr= p_config_rev_nbr AND
2764: component_instance_type='I' AND
2765: ib_trackable=YES_FLAG AND deleted_flag=NO_FLAG;