APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_MATERIAL_STATUSES

Line 3520: SELECT status_id FROM mtl_material_statuses_vl

3516: SELECT inventory_item_id FROM MTL_SYSTEM_ITEMS_KFV
3517: WHERE concatenated_segments = p_item_number;
3518:
3519: CURSOR condition_id_csr(p_condition_meaning IN VARCHAR2) IS
3520: SELECT status_id FROM mtl_material_statuses_vl
3521: WHERE status_code = p_condition_meaning;
3522:
3523:
3524: CURSOR wo_operation_id_csr(p_workorder_id IN NUMBER, p_operation_seq IN NUMBER) IS

Line 4422: FROM mtl_material_statuses

4418: AND lookup_code <> 'NULL';
4419: --
4420: CURSOR check_condition_csr (p_condition_id IN NUMBER) IS
4421: SELECT 'X'
4422: FROM mtl_material_statuses
4423: WHERE status_id = p_condition_id
4424: AND enabled_flag = 1;
4425: --
4426: CURSOR get_disp_rec_csr (p_disp_id IN NUMBER) IS

Line 4444: MTL_MATERIAL_STATUSES_VL COND

4440: decode(B.instance_id, null, decode(B.path_position_id, null, 'N', 'Y'), 'Y') TRACKABLE_FLAG
4441: from AHL_PRD_DISPOSITIONS_B B,
4442: FND_LOOKUPS FND1,
4443: FND_LOOKUPS FND2,
4444: MTL_MATERIAL_STATUSES_VL COND
4445: where FND1.LOOKUP_TYPE (+) = 'AHL_IMMED_DISP_TYPE'
4446: AND B.immediate_disposition_code = FND1.LOOKUP_CODE (+)
4447: AND FND2.LOOKUP_TYPE (+) = 'AHL_SECND_DISP_TYPE'
4448: AND B.SECONDARY_DISPOSITION_CODE = FND2.LOOKUP_CODE (+)