Context Sensitive DFF and Code changes

[nishank1]

Hi,
I have changed the existing DFF to context sensitive dff and need to
change existing programs to accommodate these changes.
What information do I need to include?
Here are the details---

The part of original code is (THIS CODE WAS WRITTEN WHEN ATTRIBUTES
WERE NOT CONTEXT SENSITIVE)---

select attribute4, trim(substr(attribute5,10,14)),
trim(substr(attribute5,124,15)),vendor_site_id, vendor_id
into v_team1, v_team2, v_team3, v_vendor_site_id, v_vendor_id
from ap_invoices_all
where invoice_id = r_c_invoice_id;

The DFF details are:

Application: Payables Title: Invoice
Context Prompt: US INV
Segments - Attributes1 to Attributes9

I have FLEX_VALUE_SET_ID for each of the segment in the
FND_DESCR_FLEX_COL_USAGE_VL table.
ex: attribute1's flex_value_set_id = 100001

WHAT CHANGES DO I NEED TO MAKE SO THE ABOVE CODE IS NOW REFERENCING TO
CONTEXT SENSITIVE DFF?

Thanks,

[rajesh_gumber]

You need to add one more where condition i.e. where ATTRIBUTE_CATEGORY = 'US INV'

Rajesh