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 403: ELSIF(p_table_name = 'cz_item_masters')

399: cz_pb_mgr.v_prop_vals_data_num_ref.DELETE;
400: cz_pb_mgr.v_prop_vals_intl_text_ref.DELETE;
401: v_prop_vals_def_num_value_ref.DELETE;
402: END IF;
403: ELSIF(p_table_name = 'cz_item_masters')
404: THEN
405: IF (p_table_type = 'tbl')
406: THEN
407: cz_pb_mgr.v_item_prop_num_val_tbl.DELETE;

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

1194: v_insertstring || ' FROM ' || table_name || ' WHERE ' || table_name || '.' || primary_key || ' = ' || plsql_table_name || '(m) ';
1195: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1196: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1197: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1198: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_MASTERS'') THEN ';
1199: v_insertstring := v_insertstring || ' UPDATE cz_item_masters' || cz_pb_mgr.v_db_link || ' t ';
1200: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
1201: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
1202: v_insertstring := v_insertstring || ' = ( SELECT ITEM_TYPE_ID,DESC_TEXT,orig_sys_ref,REF_PART_NBR, ';

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

1195: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1196: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1197: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1198: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_MASTERS'') THEN ';
1199: v_insertstring := v_insertstring || ' UPDATE cz_item_masters' || cz_pb_mgr.v_db_link || ' t ';
1200: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
1201: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
1202: v_insertstring := v_insertstring || ' = ( SELECT ITEM_TYPE_ID,DESC_TEXT,orig_sys_ref,REF_PART_NBR, ';
1203: v_insertstring := v_insertstring || ' QUOTEABLE_FLAG ,LEAD_TIME,ITEM_STATUS,PRIMARY_UOM_CODE, DELETED_FLAG,DECIMAL_QTY_FLAG ';

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

1200: v_insertstring := v_insertstring || ' SET ( ITEM_TYPE_ID,DESC_TEXT,ORIG_SYS_REF,REF_PART_NBR,QUOTEABLE_FLAG,LEAD_TIME ';
1201: v_insertstring := v_insertstring || ' ,ITEM_STATUS,PRIMARY_UOM_CODE,DELETED_FLAG,DECIMAL_QTY_FLAG) ';
1202: v_insertstring := v_insertstring || ' = ( SELECT ITEM_TYPE_ID,DESC_TEXT,orig_sys_ref,REF_PART_NBR, ';
1203: v_insertstring := v_insertstring || ' QUOTEABLE_FLAG ,LEAD_TIME,ITEM_STATUS,PRIMARY_UOM_CODE, DELETED_FLAG,DECIMAL_QTY_FLAG ';
1204: v_insertstring := v_insertstring || ' FROM cz_item_masters WHERE cz_item_masters.item_id = ' || plsql_table_name || '(m) ';
1205: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_id = ' || plsql_table_name || '(m); ';
1206: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPES'') THEN ';
1207: v_insertstring := v_insertstring || ' UPDATE cz_item_types' || cz_pb_mgr.v_db_link || ' t ';
1208: v_insertstring := v_insertstring || ' SET (DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';

Line 1701: insert_into_item_tables('cz_item_masters'

1697: mm_dump_osr_array(cz_pb_mgr.mm_insert_array3, 'ITEM ORIG_SYS_REF INSERT');
1698:
1699: END IF;
1700:
1701: insert_into_item_tables('cz_item_masters'
1702: ,'item_id'
1703: ,cz_pb_mgr.v_db_link
1704: ,plsql_table_list
1705: ,'cz_pb_mgr.mm_source_array1'

Line 1717: insert_into_item_tables('cz_item_masters'

1713: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_tbl';
1714: rec_count := rec_count + 1;
1715: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1716: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_items_orig_ref';
1717: insert_into_item_tables('cz_item_masters'
1718: ,'item_id'
1719: ,cz_pb_mgr.v_db_link
1720: ,plsql_table_list
1721: ,'cz_pb_mgr.v_item_masters_tbl'

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

13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);

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

13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);
13207: clear_tables('cz_ps_prop_vals', 'tbl', cz_pb_mgr.v_status_code);
13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);

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

16008: load_usages;
16009: END IF;
16010:
16011: ---------delete pl/sql tables
16012: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
16013: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
16014: END IF; /* end if of cz_pb_mgr.v_server_id <> 0 */
16015: EXCEPTION
16016: WHEN OTHERS

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

16009: END IF;
16010:
16011: ---------delete pl/sql tables
16012: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
16013: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
16014: END IF; /* end if of cz_pb_mgr.v_server_id <> 0 */
16015: EXCEPTION
16016: WHEN OTHERS
16017: THEN

Line 17322: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'

17318: --Judging from the SELECT NULL and empty exception block for no_data_found, the only purpose of this
17319: --query is to skip the second verification for items that don't exist on the target, so we can just
17320: --use BULK COLLECT.
17321:
17322: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'
17323: || cz_pb_mgr.v_db_link
17324: || ' it '
17325: || ' WHERE it.deleted_flag = ''0'''
17326: || ' AND it.ref_part_nbr = :1'

Line 17339: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'

17335:
17336: IF ( v_null_table.COUNT > 0 ) THEN
17337:
17338: BEGIN
17339: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_masters'
17340: || cz_pb_mgr.v_db_link
17341: || ' it, '
17342: || ' cz_item_types'
17343: || cz_pb_mgr.v_db_link

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

17366: THEN
17367: v_error_flag := 1;
17368: --~> 'Item ''%ITEMNAME'' has a different item type on the target instance.'
17369: -- Bug 5219852; 06-Sep-2006; kdande; Modified the message to show the source and target item type names
17370: EXECUTE IMMEDIATE 'SELECT ip.name FROM cz_item_masters'
17371: || cz_pb_mgr.v_db_link
17372: || ' it, cz_item_types'
17373: || cz_pb_mgr.v_db_link
17374: || ' ip '

Line 17532: FROM cz_item_masters

17528: ,bom_item, ref_part_nbr, NVL(src_application_id, 0)
17529: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref
17530: ,v_item_types_orig_tbl
17531: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17532: FROM cz_item_masters
17533: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17534: AND cz_item_masters.item_id IS NOT NULL
17535: AND cz_item_masters.deleted_flag = '0';
17536: ELSE

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

17529: BULK COLLECT INTO cz_pb_mgr.v_item_masters_ref, cz_pb_mgr.v_item_types_ref
17530: ,v_item_types_orig_tbl
17531: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17532: FROM cz_item_masters
17533: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17534: AND cz_item_masters.item_id IS NOT NULL
17535: AND cz_item_masters.deleted_flag = '0';
17536: ELSE
17537: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item

Line 17534: AND cz_item_masters.item_id IS NOT NULL

17530: ,v_item_types_orig_tbl
17531: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17532: FROM cz_item_masters
17533: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17534: AND cz_item_masters.item_id IS NOT NULL
17535: AND cz_item_masters.deleted_flag = '0';
17536: ELSE
17537: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
17538: ,ref_part_nbr, NVL(src_application_id, 0)

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

17531: ,v_bom_flg_tbl, mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17532: FROM cz_item_masters
17533: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17534: AND cz_item_masters.item_id IS NOT NULL
17535: AND cz_item_masters.deleted_flag = '0';
17536: ELSE
17537: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
17538: ,ref_part_nbr, NVL(src_application_id, 0)
17539: 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 17541: FROM cz_item_masters

17537: SELECT item_id, item_type_id, orig_sys_ref, nonbom_item
17538: ,ref_part_nbr, NVL(src_application_id, 0)
17539: 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
17540: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17541: FROM cz_item_masters
17542: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17543: AND cz_item_masters.item_id IS NOT NULL
17544: AND cz_item_masters.deleted_flag = '0';
17545: END IF;

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

17538: ,ref_part_nbr, NVL(src_application_id, 0)
17539: 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
17540: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17541: FROM cz_item_masters
17542: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17543: AND cz_item_masters.item_id IS NOT NULL
17544: AND cz_item_masters.deleted_flag = '0';
17545: END IF;
17546: EXCEPTION

Line 17543: AND cz_item_masters.item_id IS NOT NULL

17539: 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
17540: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17541: FROM cz_item_masters
17542: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17543: AND cz_item_masters.item_id IS NOT NULL
17544: AND cz_item_masters.deleted_flag = '0';
17545: END IF;
17546: EXCEPTION
17547: WHEN NO_DATA_FOUND

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

17540: ,mm_v_itmst_ref_part_nbr_tbl, mm_v_itmst_src_app_id_tbl
17541: FROM cz_item_masters
17542: WHERE cz_item_masters.item_id = cz_pb_mgr.v_ps_item_id_tbl(i)
17543: AND cz_item_masters.item_id IS NOT NULL
17544: AND cz_item_masters.deleted_flag = '0';
17545: END IF;
17546: EXCEPTION
17547: WHEN NO_DATA_FOUND
17548: THEN

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

17656: BEGIN
17657: SELECT property_id, data_type, name, src_application_id
17658: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
17659: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
17661: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
17662: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
17663: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
17664: UNION

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

24321: THEN
24322: --- Bug9180063 Joined with cz_item_types to get the uniqueness of item as item
24323: -- with same name can be under two different item types. This is mostly for non-BOM items case.
24324: l_sql_str :=
24325: 'SELECT t.item_id, t.ref_part_nbr FROM cz_item_masters' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24326: 'cz_item_types' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
24327: 'cz_item_masters s' || ',' ||
24328: 'cz_item_types s1' || ' ' ||
24329: 'WHERE t.ref_part_nbr = s.ref_part_nbr' || ' ' ||

Line 24327: 'cz_item_masters s' || ',' ||

24323: -- with same name can be under two different item types. This is mostly for non-BOM items case.
24324: l_sql_str :=
24325: 'SELECT t.item_id, t.ref_part_nbr FROM cz_item_masters' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24326: 'cz_item_types' || cz_pb_mgr.v_db_link || ' t1' || ',' ||
24327: 'cz_item_masters s' || ',' ||
24328: 'cz_item_types s1' || ' ' ||
24329: 'WHERE t.ref_part_nbr = s.ref_part_nbr' || ' ' ||
24330: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||
24331: 'AND NVL(t1.src_application_id,-1) = NVL(s1.src_application_id,-1)' || ' ' ||

Line 24421: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ

24417: );
24418:
24419: ELSIF(what_id = 'ITEM')
24420: THEN
24421: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ
24422: , 'CZ_ITEM_MASTERS_S.nextval' || cz_pb_mgr.v_db_link
24423: ,cz_pb_mgr.v_oraclesequenceincr
24424: );
24425: ELSIF(what_id = 'ITEM_TYPE')

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

24418:
24419: ELSIF(what_id = 'ITEM')
24420: THEN
24421: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_MASTERS_SEQ
24422: , 'CZ_ITEM_MASTERS_S.nextval' || cz_pb_mgr.v_db_link
24423: ,cz_pb_mgr.v_oraclesequenceincr
24424: );
24425: ELSIF(what_id = 'ITEM_TYPE')
24426: THEN