DBA Data[Home] [Help]

APPS.CSD_GEN_ERRMSGS_PVT dependencies on FND_LOOKUPS

Line 711: fnd_lookups c,

707: d.meaning msg_type, a.msg, a.generic_errmsgs_id,
708: a.source_entity_id2
709: FROM csd_generic_errmsgs a,
710: csd_repairs_v b,
711: fnd_lookups c,
712: fnd_lookups d
713: WHERE b.repair_line_id = a.source_entity_id1
714: AND c.lookup_code = a.source_entity_type_code
715: AND c.lookup_type = lc_msg_entity_lkp_typ

Line 712: fnd_lookups d

708: a.source_entity_id2
709: FROM csd_generic_errmsgs a,
710: csd_repairs_v b,
711: fnd_lookups c,
712: fnd_lookups d
713: WHERE b.repair_line_id = a.source_entity_id1
714: AND c.lookup_code = a.source_entity_type_code
715: AND c.lookup_type = lc_msg_entity_lkp_typ
716: AND d.lookup_code = a.msg_type_code

Line 1137: FROM fnd_lookups

1133:
1134: CURSOR cur_module_lookup (p_module_code VARCHAR2)
1135: IS
1136: SELECT 'x'
1137: FROM fnd_lookups
1138: WHERE lookup_type = lc_module_code_lkp_typ
1139: AND lookup_code = p_module_code
1140: AND enabled_flag = lc_enabled
1141: AND ( TRUNC (SYSDATE) >= TRUNC (start_date_active)