PDH Item Status backend table — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!