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_PB_MGR dependencies on CZ_ITEM_TYPES

Line 8: --TYPE t_itemtype_origsysref_tbl IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY VARCHAR2(4000);

4: TYPE varchar_type_32000_tbl IS TABLE OF VARCHAR2(32000) INDEX BY VARCHAR2(15);
5:
6: --Bug #5186307 - deferred.
7: --TYPE t_item_origsysref_tbl IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY VARCHAR2(4000);
8: --TYPE t_itemtype_origsysref_tbl IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY VARCHAR2(4000);
9:
10: v_application_id_tbl cz_pb_mgr.t_ref;
11: v_language_id_tbl cz_pb_mgr.t_lang_code;
12: v_usage_id_tbl cz_pb_mgr.t_ref;

Line 948: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPES'') THEN ';

944: v_insertstring := v_insertstring || ' = ( SELECT ITEM_TYPE_ID,DESC_TEXT,orig_sys_ref,REF_PART_NBR, ';
945: v_insertstring := v_insertstring || ' QUOTEABLE_FLAG ,LEAD_TIME,ITEM_STATUS,PRIMARY_UOM_CODE, DELETED_FLAG,DECIMAL_QTY_FLAG ';
946: v_insertstring := v_insertstring || ' FROM cz_item_masters WHERE cz_item_masters.item_id = ' || plsql_table_name || '(m) ';
947: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_id = ' || plsql_table_name || '(m); ';
948: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPES'') THEN ';
949: v_insertstring := v_insertstring || ' UPDATE cz_item_types' || cz_pb_mgr.v_db_link || ' t ';
950: v_insertstring := v_insertstring || ' SET (DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
951: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
952: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';

Line 949: v_insertstring := v_insertstring || ' UPDATE cz_item_types' || cz_pb_mgr.v_db_link || ' t ';

945: v_insertstring := v_insertstring || ' QUOTEABLE_FLAG ,LEAD_TIME,ITEM_STATUS,PRIMARY_UOM_CODE, DELETED_FLAG,DECIMAL_QTY_FLAG ';
946: v_insertstring := v_insertstring || ' FROM cz_item_masters WHERE cz_item_masters.item_id = ' || plsql_table_name || '(m) ';
947: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_id = ' || plsql_table_name || '(m); ';
948: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPES'') THEN ';
949: v_insertstring := v_insertstring || ' UPDATE cz_item_types' || cz_pb_mgr.v_db_link || ' t ';
950: v_insertstring := v_insertstring || ' SET (DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
951: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
952: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
953: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';

Line 954: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';

950: v_insertstring := v_insertstring || ' SET (DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
951: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
952: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
953: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
954: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
955: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
956: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
957: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
958: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';

Line 1285: insert_into_item_tables('cz_item_types'

1281: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array1';
1282: rec_count := rec_count + 1;
1283: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1284: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array3';
1285: insert_into_item_tables('cz_item_types'
1286: ,'item_type_id'
1287: ,cz_pb_mgr.v_db_link
1288: ,plsql_table_list
1289: ,'cz_pb_mgr.mm_source_array1'

Line 1297: insert_into_item_tables('cz_item_types'

1293: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_new_ref';
1294: rec_count := rec_count + 1;
1295: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1296: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_orig_ref';
1297: insert_into_item_tables('cz_item_types'
1298: ,'item_type_id'
1299: ,cz_pb_mgr.v_db_link
1300: ,plsql_table_list
1301: ,'cz_pb_mgr.v_item_types_new_ref'

Line 16107: v_target_item_type_name cz_item_types.name%TYPE;

16103: v_prop_id cz_properties.property_id%TYPE;
16104: v_error_flag PLS_INTEGER := 0;
16105: v_null PLS_INTEGER;
16106: j PLS_INTEGER;
16107: v_target_item_type_name cz_item_types.name%TYPE;
16108:
16109: v_null_table number_type_tbl;
16110:
16111: BEGIN

Line 16145: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'

16141:
16142: FOR i IN 1 .. v_item_types_new_ref.COUNT
16143: LOOP
16144: BEGIN
16145: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
16146: || cz_pb_mgr.v_db_link
16147: || 'it '
16148: || ' WHERE it.deleted_flag = ''0'''
16149: || ' AND it.name = :1'

Line 16159: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'

16155:
16156: WHILE(j IS NOT NULL)
16157: LOOP
16158: BEGIN
16159: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
16160: || cz_pb_mgr.v_db_link
16161: || 'it, '
16162: || ' cz_item_type_properties'
16163: || cz_pb_mgr.v_db_link

Line 16228: || ' cz_item_types'

16224: BEGIN
16225: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'
16226: || cz_pb_mgr.v_db_link
16227: || ' it, '
16228: || ' cz_item_types'
16229: || cz_pb_mgr.v_db_link
16230: || ' ip '
16231: || ' WHERE it.deleted_flag = ''0'''
16232: || ' AND ip.deleted_flag = ''0'''

Line 16258: || ' it, cz_item_types'

16254: --~> 'Item ''%ITEMNAME'' has a different item type on the target instance.'
16255: -- Bug 5219852; 06-Sep-2006; kdande; Modified the message to show the source and target item type names
16256: EXECUTE IMMEDIATE 'SELECT ip.name FROM cz_item_masters'
16257: || cz_pb_mgr.v_db_link
16258: || ' it, cz_item_types'
16259: || cz_pb_mgr.v_db_link
16260: || ' ip '
16261: || ' WHERE it.deleted_flag = ''0'''
16262: || ' AND ip.deleted_flag = ''0'''

Line 16485: FROM cz_item_types

16481: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
16482: )
16483: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
16484: ,v_item_types_orig_tbl
16485: FROM cz_item_types
16486: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
16487: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
16488: THEN
16489: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref

Line 16486: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';

16482: )
16483: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
16484: ,v_item_types_orig_tbl
16485: FROM cz_item_types
16486: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
16487: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
16488: THEN
16489: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
16490: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl, v_item_types_orig_tbl

Line 16491: FROM cz_item_types

16487: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
16488: THEN
16489: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
16490: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl, v_item_types_orig_tbl
16491: FROM cz_item_types
16492: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
16493: END IF;
16494: EXCEPTION
16495: WHEN NO_DATA_FOUND

Line 16492: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';

16488: THEN
16489: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
16490: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl, v_item_types_orig_tbl
16491: FROM cz_item_types
16492: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
16493: END IF;
16494: EXCEPTION
16495: WHEN NO_DATA_FOUND
16496: THEN

Line 22890: 'SELECT t.item_type_id, t.NAME FROM cz_item_types' || cz_pb_mgr.v_db_link || ' t' || ',' ||

22886: l_sync_msg_object_type_tkn := cz_item_caption;
22887: ELSIF(what_exists = 'ITEM_TYPE')
22888: THEN
22889: l_sql_str :=
22890: 'SELECT t.item_type_id, t.NAME FROM cz_item_types' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22891: 'cz_item_types s' || ' ' ||
22892: 'WHERE t.NAME = s.NAME' || ' ' ||
22893: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
22894: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||

Line 22891: 'cz_item_types s' || ' ' ||

22887: ELSIF(what_exists = 'ITEM_TYPE')
22888: THEN
22889: l_sql_str :=
22890: 'SELECT t.item_type_id, t.NAME FROM cz_item_types' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22891: 'cz_item_types s' || ' ' ||
22892: 'WHERE t.NAME = s.NAME' || ' ' ||
22893: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
22894: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||
22895: 'AND s.item_type_id = :1';

Line 22974: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ

22970: ,cz_pb_mgr.v_oraclesequenceincr
22971: );
22972: ELSIF(what_id = 'ITEM_TYPE')
22973: THEN
22974: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ
22975: , 'CZ_ITEM_TYPES_S.nextval' || cz_pb_mgr.v_db_link
22976: ,cz_pb_mgr.v_oraclesequenceincr
22977: );
22978:

Line 22975: , 'CZ_ITEM_TYPES_S.nextval' || cz_pb_mgr.v_db_link

22971: );
22972: ELSIF(what_id = 'ITEM_TYPE')
22973: THEN
22974: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ
22975: , 'CZ_ITEM_TYPES_S.nextval' || cz_pb_mgr.v_db_link
22976: ,cz_pb_mgr.v_oraclesequenceincr
22977: );
22978:
22979: ELSIF(what_id = 'ARCHIVE')