APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_MATERIAL_STATUSES

Line 196: FROM MTL_MATERIAL_STATUSES

192: AND OPERATION_SEQUENCE_NUM = p_oper_seq;
193: -- query for converting condition desc
194: CURSOR CONDITION_CUR (p_condition_desc VARCHAR2) IS
195: SELECT STATUS_ID
196: FROM MTL_MATERIAL_STATUSES
197: WHERE STATUS_CODE= RTRIM(LTRIM(p_condition_desc))
198: AND ENABLED_FLAG = 1;
199: -- query for converting Employee/Recepient to employee_id
200: CURSOR RECEPIENT_CUR (p_recepient_name VARCHAR2) IS

Line 1785: FROM MTL_MATERIAL_STATUSES

1781:
1782: -- Condition Validaiton
1783: CURSOR Condition_Cur(p_condition NUMBER) IS
1784: SELECT STATUS_ID
1785: FROM MTL_MATERIAL_STATUSES
1786: WHERE STATUS_ID = p_Condition;
1787:
1788: -- Query to Validate Problem Code
1789: CURSOR PROBLEM_CODE_LKUP_CUR (p_problem_code VARCHAR2) IS