DBA Data[Home] [Help]

APPS.INV_LOT_ATTR_PUB dependencies on MTL_ACTIONS

Line 310: -- mtl_actions table

306: -- Name : validate_exp_action_code
307: -- Desc :
308: -- Generic routine to validates Expiration Action Code , item
309: -- must be shlef life controlled, and Action Code must exist in
310: -- mtl_actions table
311: -- I/P params :
312: -- p_expiration_action_code , item ID and Org ID (Mandatory)
313: -- p_shelf_life_code (optional..)
314: -----------------------------------------------------------------------

Line 331: FROM mtl_actions

327:
328: /* get expiration action code */
329: CURSOR c_get_exp_action_code IS
330: SELECT action_code
331: FROM mtl_actions
332: WHERE action_code = p_expiration_action_code
333: AND NVL(disable_flag,'N') = 'N';
334:
335: /* get shelf life code */