DBA Data[Home] [Help]

APPS.EGO_ITEM_OPEN_INTERFACE_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 281: FROM mtl_item_revisions_b

277: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER
278: ,cp_organization_id NUMBER
279: ,cp_revision VARCHAR2) IS
280: SELECT revision_id
281: FROM mtl_item_revisions_b
282: WHERE inventory_item_id = cp_inventory_item_id
283: AND organization_id = cp_organization_id
284: AND revision < cp_revision
285: AND implementation_date IS NOT NULL

Line 289: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;

285: AND implementation_date IS NOT NULL
286: AND effectivity_date <= sysdate
287: ORDER BY effectivity_date desc;
288:
289: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;
290: l_return_status VARCHAR2(100);
291: l_error_code NUMBER;
292: l_msg_count NUMBER ;
293: l_msg_data VARCHAR2(100);