DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_ITEM_REVISIONS

Line 2086: FROM mtl_item_revisions

2082: FUNCTION get_latest_revision(p_organization_id IN NUMBER,
2083: p_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
2084: CURSOR Cur_get_revision IS
2085: SELECT revision
2086: FROM mtl_item_revisions
2087: WHERE organization_id = p_organization_id
2088: AND inventory_item_id = p_inventory_item_id
2089: AND effectivity_date <= gme_common_pvt.g_timestamp
2090: ORDER BY effectivity_date DESC;