DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 514: FROM mtl_item_revisions_b

510: l_eff_locator_control NUMBER;
511:
512: CURSOR cur_get_item_revision(v_item_id NUMBER, v_org_id NUMBER) IS
513: SELECT revision
514: FROM mtl_item_revisions_b
515: WHERE inventory_item_id = v_item_id
516: AND organization_id = v_org_id
517: AND effectivity_date <= gme_common_pvt.g_timestamp
518: ORDER BY effectivity_date desc;