Bill_to_site_use_id in RA_CUSTOMER_TRX_ALL
Bill_to_site_use_id in RA_CUSTOMER_TRX_ALL is not the same to that of Invoice_to_org_id in OE_ORDER_LINES_ALL for the related invoice.
Infact the value in Bill_to_site_use_id of RA_CUSTOMER_TRX_ALL is having the Billing site id of the shipping customer specified at the line level. ie. Suppose "abc" is specified as ship to customer and "xyz" is specified as Bill to customer, then Bill_to_site_use_id of RA_CUSTOMER_TRX_ALL is having the Billing site id of "abc" customer.
Can anyone help me in understanding how Bill_to_site_use_id value gets populated in RA_CUSTOMER_TRX_ALL table?