PDH Item Status backend table
We need to have Item Number and its Item Status both combined in backend.
Item Number is available in EGP_SYSTEM_ITEMS_B table, INVENTORY_ITEM_STATUS_CODE is available in EGP_ITEM_STATUS_TL and EGP_STATUS_ATTRIBUTE_VALUES tables.
EGP_ITEM_STATUS_TL and EGP_STATUS_ATTRIBUTE_VALUES does not have INVENTORY_ITEM_ID to join these with EGP_SYSTEM_ITEMS_B.
Please help us in finding the appropriate solution here.
Thank you,
Sainatha
0