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_MASTERS

Line 7: --TYPE t_item_origsysref_tbl IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY VARCHAR2(4000);

3:
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;

Line 354: ELSIF(p_table_name = 'cz_item_masters')

350: cz_pb_mgr.v_prop_vals_data_num_ref.DELETE;
351: cz_pb_mgr.v_prop_vals_intl_text_ref.DELETE;
352: v_prop_vals_def_num_value_ref.DELETE;
353: END IF;
354: ELSIF(p_table_name = 'cz_item_masters')
355: THEN
356: IF (p_table_type = 'tbl')
357: THEN
358: cz_pb_mgr.v_item_prop_num_val_tbl.DELETE;

Line 940: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_MASTERS'') THEN ';

936: v_insertstring || ' FROM ' || table_name || ' WHERE ' || table_name || '.' || primary_key || ' = ' || plsql_table_name || '(m) ';
937: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
938: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
939: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
940: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_MASTERS'') THEN ';
941: v_insertstring := v_insertstring || ' UPDATE cz_item_masters' || cz_pb_mgr.v_db_link || ' t ';
942: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
943: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
944: v_insertstring := v_insertstring || ' = ( SELECT ITEM_TYPE_ID,DESC_TEXT,orig_sys_ref,REF_PART_NBR, ';

Line 941: v_insertstring := v_insertstring || ' UPDATE cz_item_masters' || cz_pb_mgr.v_db_link || ' t ';

937: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
938: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
939: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
940: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_MASTERS'') THEN ';
941: v_insertstring := v_insertstring || ' UPDATE cz_item_masters' || cz_pb_mgr.v_db_link || ' t ';
942: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
943: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
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 ';

Line 946: v_insertstring := v_insertstring || ' FROM cz_item_masters WHERE cz_item_masters.item_id = ' || plsql_table_name || '(m) ';

942: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
943: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
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 ';

Line 1342: insert_into_item_tables('cz_item_masters'

1338: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1339: rec_count := rec_count + 1;
1340: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1341: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array3';
1342: insert_into_item_tables('cz_item_masters'
1343: ,'item_id'
1344: ,cz_pb_mgr.v_db_link
1345: ,plsql_table_list
1346: ,'cz_pb_mgr.mm_source_array1'

Line 1358: insert_into_item_tables('cz_item_masters'

1354: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_tbl';
1355: rec_count := rec_count + 1;
1356: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1357: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_items_orig_ref';
1358: insert_into_item_tables('cz_item_masters'
1359: ,'item_id'
1360: ,cz_pb_mgr.v_db_link
1361: ,plsql_table_list
1362: ,'cz_pb_mgr.v_item_masters_tbl'

Line 12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);

12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);

Line 12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);

12213: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
12214: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
12215: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);

Line 14898: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);

14894: load_usages;
14895: END IF;
14896:
14897: ---------delete pl/sql tables
14898: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
14899: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
14900: END IF; /* end if of cz_pb_mgr.v_server_id <> 0 */
14901: EXCEPTION
14902: WHEN OTHERS

Line 14899: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);

14895: END IF;
14896:
14897: ---------delete pl/sql tables
14898: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
14899: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
14900: END IF; /* end if of cz_pb_mgr.v_server_id <> 0 */
14901: EXCEPTION
14902: WHEN OTHERS
14903: THEN

Line 16208: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'

16204: --Judging from the SELECT NULL and empty exception block for no_data_found, the only purpose of this
16205: --query is to skip the second verification for items that don't exist on the target, so we can just
16206: --use BULK COLLECT.
16207:
16208: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'
16209: || cz_pb_mgr.v_db_link
16210: || ' it '
16211: || ' WHERE it.deleted_flag = ''0'''
16212: || ' AND it.ref_part_nbr = :1'

Line 16225: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'

16221:
16222: IF ( v_null_table.COUNT > 0 ) THEN
16223:
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

Line 16256: EXECUTE IMMEDIATE 'SELECT ip.name FROM cz_item_masters'

16252: THEN
16253: v_error_flag := 1;
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 '

Line 16412: FROM cz_item_masters

16408: ,bom_item, ref_part_nbr, NVL(src_application_id, 0)
16409: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref
16410: ,v_item_types_orig_tbl
16411: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16412: FROM cz_item_masters
16413: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16414: AND cz_item_masters.item_id IS NOT NULL
16415: AND cz_item_masters.deleted_flag = '0';
16416: ELSE

Line 16413: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)

16409: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref
16410: ,v_item_types_orig_tbl
16411: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16412: FROM cz_item_masters
16413: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16414: AND cz_item_masters.item_id IS NOT NULL
16415: AND cz_item_masters.deleted_flag = '0';
16416: ELSE
16417: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item

Line 16414: AND cz_item_masters.item_id IS NOT NULL

16410: ,v_item_types_orig_tbl
16411: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16412: FROM cz_item_masters
16413: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16414: AND cz_item_masters.item_id IS NOT NULL
16415: AND cz_item_masters.deleted_flag = '0';
16416: ELSE
16417: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
16418: ,ref_part_nbr, NVL(src_application_id, 0)

Line 16415: AND cz_item_masters.deleted_flag = '0';

16411: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16412: FROM cz_item_masters
16413: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16414: AND cz_item_masters.item_id IS NOT NULL
16415: AND cz_item_masters.deleted_flag = '0';
16416: ELSE
16417: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
16418: ,ref_part_nbr, NVL(src_application_id, 0)
16419: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref, v_item_types_orig_tbl, v_bom_flg_tbl

Line 16421: FROM cz_item_masters

16417: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
16418: ,ref_part_nbr, NVL(src_application_id, 0)
16419: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref, v_item_types_orig_tbl, v_bom_flg_tbl
16420: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16421: FROM cz_item_masters
16422: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16423: AND cz_item_masters.item_id IS NOT NULL
16424: AND cz_item_masters.deleted_flag = '0';
16425: END IF;

Line 16422: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)

16418: ,ref_part_nbr, NVL(src_application_id, 0)
16419: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref, v_item_types_orig_tbl, v_bom_flg_tbl
16420: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16421: FROM cz_item_masters
16422: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16423: AND cz_item_masters.item_id IS NOT NULL
16424: AND cz_item_masters.deleted_flag = '0';
16425: END IF;
16426: EXCEPTION

Line 16423: AND cz_item_masters.item_id IS NOT NULL

16419: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref, v_item_types_orig_tbl, v_bom_flg_tbl
16420: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16421: FROM cz_item_masters
16422: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16423: AND cz_item_masters.item_id IS NOT NULL
16424: AND cz_item_masters.deleted_flag = '0';
16425: END IF;
16426: EXCEPTION
16427: WHEN NO_DATA_FOUND

Line 16424: AND cz_item_masters.deleted_flag = '0';

16420: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
16421: FROM cz_item_masters
16422: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
16423: AND cz_item_masters.item_id IS NOT NULL
16424: AND cz_item_masters.deleted_flag = '0';
16425: END IF;
16426: EXCEPTION
16427: WHEN NO_DATA_FOUND
16428: THEN

Line 16540: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p

16536: BEGIN
16537: SELECT property_id, data_type, name, src_application_id
16538: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
16539: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
16540: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
16541: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
16542: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
16543: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
16544: UNION

Line 22879: 'SELECT t.item_id, t.ref_part_nbr FROM cz_item_masters' || cz_pb_mgr.v_db_link || ' t' || ',' ||

22875: l_sync_msg_object_type_tkn := cz_property_caption;
22876: ELSIF(what_exists = 'ITEM')
22877: THEN
22878: l_sql_str :=
22879: 'SELECT t.item_id, t.ref_part_nbr FROM cz_item_masters' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22880: 'cz_item_masters s' || ' ' ||
22881: 'WHERE t.ref_part_nbr = s.ref_part_nbr' || ' ' ||
22882: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||
22883: 'AND NVL(t.orig_sys_ref, 0) = :1' || ' ' ||

Line 22880: 'cz_item_masters s' || ' ' ||

22876: ELSIF(what_exists = 'ITEM')
22877: THEN
22878: l_sql_str :=
22879: 'SELECT t.item_id, t.ref_part_nbr FROM cz_item_masters' || cz_pb_mgr.v_db_link || ' t' || ',' ||
22880: 'cz_item_masters s' || ' ' ||
22881: 'WHERE t.ref_part_nbr = s.ref_part_nbr' || ' ' ||
22882: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||
22883: 'AND NVL(t.orig_sys_ref, 0) = :1' || ' ' ||
22884: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||

Line 22968: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ

22964: );
22965:
22966: ELSIF(what_id = 'ITEM')
22967: THEN
22968: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ
22969: , 'CZ_ITEM_MASTERS_S.nextval' || cz_pb_mgr.v_db_link
22970: ,cz_pb_mgr.v_oraclesequenceincr
22971: );
22972: ELSIF(what_id = 'ITEM_TYPE')

Line 22969: , 'CZ_ITEM_MASTERS_S.nextval' || cz_pb_mgr.v_db_link

22965:
22966: ELSIF(what_id = 'ITEM')
22967: THEN
22968: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ
22969: , 'CZ_ITEM_MASTERS_S.nextval' || cz_pb_mgr.v_db_link
22970: ,cz_pb_mgr.v_oraclesequenceincr
22971: );
22972: ELSIF(what_id = 'ITEM_TYPE')
22973: THEN