DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_ITEM_REVISIONS

Line 1870: FROM mtl_item_revisions

1866: FUNCTION get_latest_revision(p_organization_id IN NUMBER,
1867: p_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
1868: CURSOR Cur_get_revision IS
1869: SELECT revision
1870: FROM mtl_item_revisions
1871: WHERE organization_id = p_organization_id
1872: AND inventory_item_id = p_inventory_item_id
1873: AND effectivity_date <= gme_common_pvt.g_timestamp
1874: ORDER BY effectivity_date DESC;