[Home] [Help]
509: decode(c.disp_data_type, 'N', nvl2(d.mod_value, d.mod_value, 0),
510: 'M', nvl2(d.mod_value, d.mod_value, 0),
511: nvl(d.mod_value_desc, d.mod_value)) mod_value_desc
512:
513: FROM pon_entity_differences d,
514: po_diff_config c
515:
516: WHERE d.document_type = p_document_type
517: and d.entity_name = p_entity_name
862: ''' and d.entity_name = ''' || p_entity_name ||
863: ''' and d.mod_doc_source_name = ''' || p_mod_doc_source || '''';
864:
865: --sql stmt to get the rollup changes
866: l_rfc_stmt := 'SELECT d.column_name, d.orig_value, d.mod_value from pon_entity_differences d, po_diff_config c
867: where ' || l_where_stmt ||
868: ' and c.column_name = d.column_name
869: and nvl(c.rollup_eligibility_flag, ''N'') = ''Y''
870: and c.document_type = '''|| p_document_type ||'''
883: SELECT document_type, entity_name, mod_doc_source_name, base_doc_pk1_val, base_doc_pk2_val,
884: base_doc_pk3_val, base_doc_pk4_val, base_doc_pk5_val, mod_doc_pk1_val, mod_doc_pk2_val,
885: mod_doc_pk3_val, mod_doc_pk4_val, mod_doc_pk5_val, column_name, mod_value, orig_value,
886: mod_value_desc, orig_value_desc, creation_date, created_by, last_update_date, last_updated_by
887: from pon_entity_differences d
888:
889: WHERE '|| l_where_stmt ||' and column_name = :1 and nvl(orig_value, ''*'') = nvl(:2, ''*'') and nvl(mod_value, ''*'') = nvl(:3, ''*'') ';
890:
891: OPEN l_rc FOR l_rfc_stmt ;