DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on MTL_CROSS_REFERENCES

Line 277: mtl_cross_references mcr

273:
274: SELECT DISTINCT opi.item_no, opi.item_desc1, opi.item_id, mti.inventory_item_id
275: FROM mtl_system_items mti,
276: ic_item_mst opi,
277: mtl_cross_references mcr
278: WHERE
279: mti.organization_id = p_org_id
280: AND opi.item_no = mti.segment1
281: AND mti.inventory_item_id = mcr.inventory_item_id