DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 647: FROM mtl_item_revisions_b

643: l_return_status VARCHAR2(1);
644:
645: CURSOR cur_get_item_revision(v_item_id NUMBER, v_org_id NUMBER) IS
646: SELECT revision
647: FROM mtl_item_revisions_b
648: WHERE inventory_item_id = v_item_id
649: AND organization_id = v_org_id
650: AND effectivity_date <= gme_common_pvt.g_timestamp
651: ORDER BY effectivity_date desc;