[Home] [Help]
APPS.GME_COMPLETE_BATCH_PVT dependencies on MTL_ITEM_REVISIONS_B
Line 640: FROM mtl_item_revisions_b
636: l_return_status VARCHAR2(1);
637:
638: CURSOR cur_get_item_revision(v_item_id NUMBER, v_org_id NUMBER) IS
639: SELECT revision
640: FROM mtl_item_revisions_b
641: WHERE inventory_item_id = v_item_id
642: AND organization_id = v_org_id
643: AND effectivity_date <= gme_common_pvt.g_timestamp
644: ORDER BY effectivity_date desc;