DBA Data[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;