APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_PROPERTY_VALUES

Line 594: FROM cz_properties p, cz_item_property_values v

590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
591:
592: BEGIN
593: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id
594: FROM cz_properties p, cz_item_property_values v
595: WHERE p.deleted_flag = FLAG_NOT_DELETED
596: AND p.orig_sys_ref IS NOT NULL
597: AND v.deleted_flag = FLAG_NOT_DELETED
598: AND v.item_id = tabItemId(j)

Line 611: NOT EXISTS(SELECT NULL FROM cz_item_property_values iv

607: WHERE im.item_id=tabItemId(j) AND
608: im.deleted_flag=FLAG_NOT_DELETED) AND
609: it.deleted_flag=FLAG_NOT_DELETED
610: ) AND
611: NOT EXISTS(SELECT NULL FROM cz_item_property_values iv
612: WHERE iv.property_id=p.property_id AND iv.item_id=tabItemId(j) AND
613: iv.deleted_flag=FLAG_NOT_DELETED) AND
614: p.deleted_flag = FLAG_NOT_DELETED AND
615: p.orig_sys_ref IS NOT NULL AND

Line 1509: UPDATE cz_item_property_values SET

1505: END LOOP;
1506:
1507: debug('Table cz_model_publications updates rolled back');
1508: FOR i IN 1..tabRbItmPropValItemId.count LOOP
1509: UPDATE cz_item_property_values SET
1510: orig_sys_ref = tabRbItmPropValOrigSysRef(i)
1511: WHERE item_id = tabRbItmPropValItemId(i)
1512: and property_id=tabRbItmPropValPropId(i)
1513: and deleted_flag='0';

Line 1517: debug('Table cz_item_property_values updates rolled back');

1513: and deleted_flag='0';
1514: COMMIT;
1515: END LOOP;
1516:
1517: debug('Table cz_item_property_values updates rolled back');
1518:
1519: FOR i IN 1..tabRbItmTypPropItTypeId.count LOOP
1520: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
1521: orig_sys_ref = tabRbItmTypPropOrigSysRef(i)

Line 1748: --Update cz_item_property_values table.

1744: segmentStart := segmentEnd + 1;
1745:
1746: END LOOP;
1747:
1748: --Update cz_item_property_values table.
1749:
1750: localCount := tabCandidateItem.COUNT;
1751: segmentStart := 1;
1752:

Line 1753: debug('Updating cz_item_property_values table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));

1749:
1750: localCount := tabCandidateItem.COUNT;
1751: segmentStart := 1;
1752:
1753: debug('Updating cz_item_property_values table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1754:
1755: WHILE(segmentStart <= localCount)LOOP
1756:
1757: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1765: FROM cz_item_property_values where item_id = tabCandidateItem(i)

1761: for i IN segmentStart..segmentEnd LOOP
1762:
1763: select ITEM_ID,PROPERTY_ID,ORIG_SYS_REF
1764: BULK COLLECT INTO l_tabRbItmPropValItemId,l_tabRbItmPropValPropId,l_tabRbItmPropValOrigSysRef
1765: FROM cz_item_property_values where item_id = tabCandidateItem(i)
1766: and deleted_flag='0';
1767:
1768: loopCount:=tabRbItmPropValItemId.count;
1769: for j in 1..l_tabRbItmPropValItemId.COUNT

Line 1782: UPDATE cz_item_property_values SET

1778: END LOOP;
1779:
1780: FORALL i IN segmentStart..segmentEnd
1781:
1782: UPDATE cz_item_property_values SET
1783: orig_sys_ref = NVL(itemPropValues_origSysRef(orig_sys_ref),orig_sys_ref)
1784: WHERE item_id = tabCandidateItem(i)
1785: and deleted_flag='0';
1786:

Line 2140: --format of cz_item_property_values.orig_sys_ref: inv_item_id:property_id

2136: v_item_id VARCHAR2(20);
2137: v_org_id VARCHAR2(20);
2138:
2139: BEGIN
2140: --format of cz_item_property_values.orig_sys_ref: inv_item_id:property_id
2141: IF (p_orig_sys_ref IS NOT NULL) THEN
2142: v_inv_id_pos := instr(p_orig_sys_ref, ':',1,1);
2143: v_org_id_pos := instr(p_orig_sys_ref, ':',1,2);
2144: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_orig_sys_ref, 1, v_inv_id_pos - 1))));