APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_MATERIAL_STATUSES

Line 207: FROM MTL_MATERIAL_STATUSES

203: AND OPERATION_SEQUENCE_NUM = p_oper_seq;
204: -- query for converting condition desc
205: CURSOR CONDITION_CUR (p_condition_desc VARCHAR2) IS
206: SELECT STATUS_ID
207: FROM MTL_MATERIAL_STATUSES
208: WHERE STATUS_CODE= RTRIM(LTRIM(p_condition_desc))
209: AND ENABLED_FLAG = 1;
210: -- query for converting Employee/Recepient to employee_id
211: CURSOR RECEPIENT_CUR (p_recepient_name VARCHAR2) IS

Line 2074: FROM MTL_MATERIAL_STATUSES

2070:
2071: -- Condition Validaiton
2072: CURSOR Condition_Cur(p_condition NUMBER) IS
2073: SELECT STATUS_ID
2074: FROM MTL_MATERIAL_STATUSES
2075: WHERE STATUS_ID = p_Condition;
2076:
2077: -- Query to Validate Problem Code
2078: CURSOR PROBLEM_CODE_LKUP_CUR (p_problem_code VARCHAR2) IS

Line 5138: condition_code MTL_MATERIAL_STATUSES_TL.STATUS_CODE%TYPE,

5134: item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE,
5135: immediate_disposition_code AHL_PRD_DISPOSITIONS_B.IMMEDIATE_DISPOSITION_CODE%TYPE,
5136: disposition_id AHL_PRD_DISPOSITIONS_B.DISPOSITION_ID%TYPE,
5137: immediate_type FND_LOOKUP_VALUES.MEANING%TYPE,
5138: condition_code MTL_MATERIAL_STATUSES_TL.STATUS_CODE%TYPE,
5139: condition_id AHL_PRD_DISPOSITIONS_B.CONDITION_ID%TYPE,
5140: serial_number CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE,
5141: uom AHL_PRD_DISPOSITIONS_B.UOM%TYPE,
5142: unit_of_measure MTL_UNITS_OF_MEASURE_VL.UNIT_OF_MEASURE%TYPE,