DBA Data[Home] [Help]

APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_SYSTEM_ITEMS

Line 480: FROM mtl_system_items msi

476: l_transaction_action_id NUMBER; -- nsinghi bug#5209065 rework
477:
478: CURSOR Cur_item_dtl (c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
479: SELECT msi.shelf_life_code, msi.shelf_life_days
480: FROM mtl_system_items msi
481: WHERE msi.inventory_item_id = c_inventory_item_id
482: AND msi.organization_id = c_organization_id;
483: BEGIN
484: /* Initialize return status to success */