DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 521: FROM mtl_item_revisions_b

517: error_bad_trans_date EXCEPTION;
518:
519: CURSOR cur_get_item_revision(v_item_id NUMBER, v_org_id NUMBER) IS
520: SELECT revision
521: FROM mtl_item_revisions_b
522: WHERE inventory_item_id = v_item_id
523: AND organization_id = v_org_id
524: AND effectivity_date <= gme_common_pvt.g_timestamp
525: ORDER BY effectivity_date desc;