Deriving Intercompany segment value based on multiple customer on a project

   Hi ,

we are having 6 segment COA, one of the segment is intercompany, this segment value is derived from customer site> business purpose > Bill To details . Recieevables Accounts. We are writing sql statement to derive the value for revenue invoice auto accounitng fucntion. In projects for this function we can use sql statement parameter as Project Organization, Project Organization,Class Code,Project Number and Project ID.

Now that in R12 we can have multilpe customer in a single project, we want to know how to derive the intercompany segment for the task level customer assignment as we are not able to write sql statement parameter based on the task id / task number.