APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_LOOKUPS

Line 4868: FROM fnd_lookups

4864: --
4865: --
4866: CURSOR check_immed_disp_types_csr (p_disp_code IN VARCHAR2)IS
4867: SELECT 'X'
4868: FROM fnd_lookups
4869: WHERE lookup_type = 'AHL_IMMED_DISP_TYPE'
4870: AND lookup_code = p_disp_code
4871: AND lookup_code <> 'NULL';
4872: --

Line 4875: FROM fnd_lookups

4871: AND lookup_code <> 'NULL';
4872: --
4873: CURSOR check_second_disp_types_csr (p_disp_code IN VARCHAR2)IS
4874: SELECT 'X'
4875: FROM fnd_lookups
4876: WHERE lookup_type = 'AHL_SECND_DISP_TYPE'
4877: AND lookup_code = p_disp_code
4878: AND lookup_code <> 'NULL';
4879: --

Line 4902: FND_LOOKUPS FND1,

4898: FND2.MEANING SECONDARY_TYPE,
4899: B.part_change_id,
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 (+)

Line 4903: FND_LOOKUPS FND2,

4899: B.part_change_id,
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'