APPS.CZ_BOM_SYNCH dependencies on CZ_PROPERTIES

Line 586: l_src_application_id cz_properties.src_application_id%TYPE;

582: elementValue mtl_descr_element_values.element_value%TYPE;
583: l_val VARCHAR2(4000);
584: l_flag PLS_INTEGER;
585: position NUMBER;
586: l_src_application_id cz_properties.src_application_id%TYPE;
587: l_item_catalog_group_id cz_exv_item_master.item_catalog_group_id%TYPE;
588: l_database_column cz_exv_apc_properties.database_column%TYPE;
589: l_attr_group_id cz_exv_apc_properties.attr_group_id%TYPE;
590: l_attr_id cz_exv_apc_properties.attr_id%TYPE;

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 603: FROM cz_properties p

599: AND p.property_id = v.property_id
600: AND p.data_type NOT IN(TL_TEXT_TYPE)
601: UNION
602: SELECT name, data_type,def_value as property_value,def_num_value as property_num_value,src_application_id
603: FROM cz_properties p
604: WHERE p.property_id IN(
605: SELECT it.property_id FROM cz_item_type_properties it
606: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im
607: WHERE im.item_id=tabItemId(j) AND