APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_LOOKUPS

Line 4408: FROM fnd_lookups

4404: --
4405: --
4406: CURSOR check_immed_disp_types_csr (p_disp_code IN VARCHAR2)IS
4407: SELECT 'X'
4408: FROM fnd_lookups
4409: WHERE lookup_type = 'AHL_IMMED_DISP_TYPE'
4410: AND lookup_code = p_disp_code
4411: AND lookup_code <> 'NULL';
4412: --

Line 4415: FROM fnd_lookups

4411: AND lookup_code <> 'NULL';
4412: --
4413: CURSOR check_second_disp_types_csr (p_disp_code IN VARCHAR2)IS
4414: SELECT 'X'
4415: FROM fnd_lookups
4416: WHERE lookup_type = 'AHL_SECND_DISP_TYPE'
4417: AND lookup_code = p_disp_code
4418: AND lookup_code <> 'NULL';
4419: --

Line 4442: FND_LOOKUPS FND1,

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

Line 4443: FND_LOOKUPS FND2,

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