APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_MATERIAL_STATUSES

Line 3953: SELECT status_id FROM mtl_material_statuses_vl

3949: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV
3950: WHERE concatenated_segments = p_item_number;
3951:
3952: CURSOR condition_id_csr(p_condition_meaning IN VARCHAR2) IS
3953: SELECT status_id FROM mtl_material_statuses_vl
3954: WHERE status_code = p_condition_meaning;
3955:
3956:
3957: CURSOR wo_operation_id_csr(p_workorder_id IN NUMBER, p_operation_seq IN NUMBER) IS

Line 4882: FROM mtl_material_statuses

4878: AND lookup_code <> 'NULL';
4879: --
4880: CURSOR check_condition_csr (p_condition_id IN NUMBER) IS
4881: SELECT 'X'
4882: FROM mtl_material_statuses
4883: WHERE status_id = p_condition_id
4884: AND enabled_flag = 1;
4885: --
4886: CURSOR get_disp_rec_csr (p_disp_id IN NUMBER) IS

Line 4904: MTL_MATERIAL_STATUSES_VL COND

4900: decode(B.instance_id, null, decode(B.path_position_id, null, 'N', 'Y'), 'Y') TRACKABLE_FLAG
4901: from AHL_PRD_DISPOSITIONS_B B,
4902: FND_LOOKUPS FND1,
4903: FND_LOOKUPS FND2,
4904: MTL_MATERIAL_STATUSES_VL COND
4905: where FND1.LOOKUP_TYPE (+) = 'AHL_IMMED_DISP_TYPE'
4906: AND B.immediate_disposition_code = FND1.LOOKUP_CODE (+)
4907: AND FND2.LOOKUP_TYPE (+) = 'AHL_SECND_DISP_TYPE'
4908: AND B.SECONDARY_DISPOSITION_CODE = FND2.LOOKUP_CODE (+)