828: from ff_database_items fdi,
829: ff_archive_items fai,
830: ff_archive_item_contexts fac,
831: ff_archive_item_contexts fac1,
832: ff_contexts fc,
833: ff_contexts fc1
834: where fai.user_entity_id = fdi.user_entity_id
835: and fai.context1 = to_char(cp_asg_act_id)
836: /* context assignment action id */
829: ff_archive_items fai,
830: ff_archive_item_contexts fac,
831: ff_archive_item_contexts fac1,
832: ff_contexts fc,
833: ff_contexts fc1
834: where fai.user_entity_id = fdi.user_entity_id
835: and fai.context1 = to_char(cp_asg_act_id)
836: /* context assignment action id */
837: and fac.archive_item_id = fai.archive_item_id
849: select fdi.user_name,fai.value
850: from ff_database_items fdi,
851: ff_archive_items fai,
852: ff_archive_item_contexts fac,
853: ff_contexts fc
854: where fai.user_entity_id = fdi.user_entity_id
855: and fai.context1 = to_char(cp_asg_act_id)
856: /* context assignment action id */
857: and fc.context_name = 'TAX_UNIT_ID'
870: select fdi.user_name,fai.value
871: from ff_database_items fdi,
872: ff_archive_items fai,
873: ff_archive_item_contexts fac,
874: ff_contexts fc
875: where fai.user_entity_id = fdi.user_entity_id
876: and fai.context1 = to_char(p_asg_action_id)
877: /* context assignment action id */
878: and fc.context_name = 'ASSIGNMENT_ID'