Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.2 kB
2
Indexable
Never
INSERT INTO tibtcare_ppm_st.ppm_product_pff_attr_map (product_pff_attr_map_nbr, order_line_action, service_type, service_id_key, product_spec_id, product_attr_name, product_type_id, product_action, pff_id, pff_default_state, start_date, end_date, created_by, created_on, updated_by, updated_on, bu_id, operator_id, external_sys_id, external_sys_catg, product_default_value, ppm_attr_id, instant_billing, rollback_pff_id, product_attr_value, attribute_action, exec_rule_yn, extended_rule_code, off_set, base_date) VALUES ('850', 'CHANGE_OWNER_TO', 'Mobile', NULL, 'PO_Mobile_Service_Business_Suomi_Pck', 'CHNAGE_OWNER_MOBILE_ASSO_TO_VPBX', 'Core', 'M', 'PFF_CREATE_ASSOC_ORDER_EVENT', 'ON', TO_DATE('2021-10-21 11:08:55', 'YYYY-MM-DD HH24:MI:SS'), NULL, 'a0665867', TO_DATE('2021-10-21 11:08:55', 'YYYY-MM-DD HH24:MI:SS'), 'a0665867', TO_DATE('2021-10-21 11:08:55', 'YYYY-MM-DD HH24:MI:SS'), 'DEFAULT', 'HOB', 'ASSOC_ORDER_EVENT', 'NETWORK', NULL, NULL, NULL, NULL, 'YES', NULL, 'Y', 'String CHNAGE_OWNER_MOBILE_ASSO_TO_VPBX;CHNAGE_OWNER_MOBILE_ASSO_TO_VPBX=='YES'', NULL, NULL)

still iam getting same if you see above query where extended_rule_code value after == it should be ''YES''' but its only 'YES''