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.

[Home] [Help]

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 1206: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPES'') THEN ';

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 ';
1209: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
1210: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';

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

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 ';
1209: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
1210: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
1211: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';

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

1208: v_insertstring := v_insertstring || ' SET (DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
1209: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF) ';
1210: v_insertstring := v_insertstring || ' = (SELECT DESC_TEXT,NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04 ';
1211: v_insertstring := v_insertstring || ' ,USER_STR01,USER_STR02,USER_STR03,USER_STR04,DELETED_FLAG,ORIG_SYS_REF ';
1212: v_insertstring := v_insertstring || ' FROM cz_item_types WHERE cz_item_types.item_type_id = ' || plsql_table_name || '(m) ';
1213: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'') WHERE t.item_type_id = ' || plsql_table_name || '(m); ';
1214: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_PROPERTIES'') THEN ';
1215: v_insertstring := v_insertstring || ' UPDATE cz_properties' || cz_pb_mgr.v_db_link || ' t ';
1216: v_insertstring := v_insertstring || ' SET ( PROPERTY_UNIT,DESC_TEXT,NAME,DATA_TYPE,DEF_VALUE,USER_NUM01 ';

Line 1577: insert_into_item_tables('cz_item_types'

1573: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array1';
1574: rec_count := rec_count + 1;
1575: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1576: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array3';
1577: insert_into_item_tables('cz_item_types'
1578: ,'item_type_id'
1579: ,cz_pb_mgr.v_db_link
1580: ,plsql_table_list
1581: ,'cz_pb_mgr.mm_source_array1'

Line 1594: || 'UPDATE cz_item_types'

1590: || 'FOR I IN cz_pb_mgr.mm_insert_array1.FIRST..cz_pb_mgr.mm_insert_array1.LAST'
1591: || ' '
1592: || 'LOOP'
1593: || ' '
1594: || 'UPDATE cz_item_types'
1595: || cz_pb_mgr.v_db_link
1596: || ' t'
1597: || ' '
1598: || 'SET t.orig_sys_ref = NULL'

Line 1615: insert_into_item_tables('cz_item_types'

1611: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_new_ref';
1612: rec_count := rec_count + 1;
1613: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1614: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_item_types_orig_ref';
1615: insert_into_item_tables('cz_item_types'
1616: ,'item_type_id'
1617: ,cz_pb_mgr.v_db_link
1618: ,plsql_table_list
1619: ,'cz_pb_mgr.v_item_types_new_ref'

Line 17221: v_target_item_type_name cz_item_types.name%TYPE;

17217: v_prop_id cz_properties.property_id%TYPE;
17218: v_error_flag PLS_INTEGER := 0;
17219: v_null PLS_INTEGER;
17220: j PLS_INTEGER;
17221: v_target_item_type_name cz_item_types.name%TYPE;
17222:
17223: v_null_table number_type_tbl;
17224:
17225: BEGIN

Line 17259: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'

17255:
17256: FOR i IN 1 .. v_item_types_new_ref.COUNT
17257: LOOP
17258: BEGIN
17259: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
17260: || cz_pb_mgr.v_db_link
17261: || 'it '
17262: || ' WHERE it.deleted_flag = ''0'''
17263: || ' AND it.name = :1'

Line 17273: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'

17269:
17270: WHILE(j IS NOT NULL)
17271: LOOP
17272: BEGIN
17273: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
17274: || cz_pb_mgr.v_db_link
17275: || 'it, '
17276: || ' cz_item_type_properties'
17277: || cz_pb_mgr.v_db_link

Line 17342: || ' cz_item_types'

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
17344: || ' ip '
17345: || ' WHERE it.deleted_flag = ''0'''
17346: || ' AND ip.deleted_flag = ''0'''

Line 17372: || ' it, cz_item_types'

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 '
17375: || ' WHERE it.deleted_flag = ''0'''
17376: || ' AND ip.deleted_flag = ''0'''

Line 17605: FROM cz_item_types

17601: ,NVL(orig_sys_ref, cz_pb_mgr.null_string)
17602: )
17603: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
17604: ,v_item_types_orig_tbl
17605: FROM cz_item_types
17606: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
17607: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
17608: THEN
17609: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref

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

17602: )
17603: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl
17604: ,v_item_types_orig_tbl
17605: FROM cz_item_types
17606: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
17607: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
17608: THEN
17609: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
17610: 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 17611: FROM cz_item_types

17607: ELSIF((cz_pb_mgr.v_item_types_tbl(i) IS NOT NULL) AND(v_bom_flg_ref(i) = nonbom_item))
17608: THEN
17609: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
17610: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl, v_item_types_orig_tbl
17611: FROM cz_item_types
17612: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
17613: END IF;
17614: EXCEPTION
17615: WHEN NO_DATA_FOUND

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

17608: THEN
17609: SELECT item_type_id, NAME, NVL(src_application_id, 0), orig_sys_ref
17610: BULK COLLECT INTO cz_pb_mgr.v_item_types_ref, v_type_name_tbl, v_type_src_app_tbl, v_item_types_orig_tbl
17611: FROM cz_item_types
17612: WHERE cz_item_types.item_type_id = cz_pb_mgr.v_item_types_tbl(i) AND cz_item_types.deleted_flag = '0';
17613: END IF;
17614: EXCEPTION
17615: WHEN NO_DATA_FOUND
17616: THEN

Line 24322: --- Bug9180063 Joined with cz_item_types to get the uniqueness of item as item

24318: 'AND s.property_id = :1';
24319: l_sync_msg_object_type_tkn := cz_property_caption;
24320: ELSIF(what_exists = 'ITEM')
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' || ',' ||

Line 24326: 'cz_item_types' || cz_pb_mgr.v_db_link || ' t1' || ',' ||

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' || ' ' ||
24330: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||

Line 24328: 'cz_item_types s1' || ' ' ||

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)' || ' ' ||
24332: 'AND t1.name = s1.name' || ' ' ||

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

24339: l_sync_msg_object_type_tkn := cz_item_caption;
24340: ELSIF(what_exists = 'ITEM_TYPE')
24341: THEN
24342: l_sql_str :=
24343: 'SELECT t.item_type_id, t.NAME FROM cz_item_types' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24344: 'cz_item_types s' || ' ' ||
24345: 'WHERE t.NAME = s.NAME' || ' ' ||
24346: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
24347: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||

Line 24344: 'cz_item_types s' || ' ' ||

24340: ELSIF(what_exists = 'ITEM_TYPE')
24341: THEN
24342: l_sql_str :=
24343: 'SELECT t.item_type_id, t.NAME FROM cz_item_types' || cz_pb_mgr.v_db_link || ' t' || ',' ||
24344: 'cz_item_types s' || ' ' ||
24345: 'WHERE t.NAME = s.NAME' || ' ' ||
24346: 'AND t.DELETED_FLAG = ''0'' '|| ' ' ||
24347: 'AND NVL(t.src_application_id,-1) = NVL(s.src_application_id,-1)' || ' ' ||
24348: 'AND s.item_type_id = :1';

Line 24427: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ

24423: ,cz_pb_mgr.v_oraclesequenceincr
24424: );
24425: ELSIF(what_id = 'ITEM_TYPE')
24426: THEN
24427: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ
24428: , 'CZ_ITEM_TYPES_S.nextval' || cz_pb_mgr.v_db_link
24429: ,cz_pb_mgr.v_oraclesequenceincr
24430: );
24431:

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

24424: );
24425: ELSIF(what_id = 'ITEM_TYPE')
24426: THEN
24427: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.CZ_ITEM_TYPES_SEQ
24428: , 'CZ_ITEM_TYPES_S.nextval' || cz_pb_mgr.v_db_link
24429: ,cz_pb_mgr.v_oraclesequenceincr
24430: );
24431:
24432: ELSIF(what_id = 'ARCHIVE')