Item and org relationship can be seen in UI but can't see in backend tables tables

Hi,

When search for an item from the manage item page inside the product information management giving the name and organization name iam able to see the item in the UI, but the same item name and organization combination is not returning any values in the backend.

join condition that i used-

EGP_System_Items_B.ORGANIZATION_ID = inv_org_Parameters.ORGANIZATION_ID

Any help would be really appreciated

Thank you,
Sarath