DBA Data[Home] [Help]

APPS.JTS_CONFIG_VERSION_PVT dependencies on FND_USER

Line 741: fnd_user u1,

737: x_version_rec.replayed_by_name
738: FROM jts_config_versions_vl v,
739: fnd_lookup_values rep,
740: fnd_lookup_values ver,
741: fnd_user u1,
742: fnd_user u2,
743: fnd_user u3
744: WHERE version_id = p_version_id
745: AND rep.lookup_type (+) = C_STATUS_TYPE

Line 742: fnd_user u2,

738: FROM jts_config_versions_vl v,
739: fnd_lookup_values rep,
740: fnd_lookup_values ver,
741: fnd_user u1,
742: fnd_user u2,
743: fnd_user u3
744: WHERE version_id = p_version_id
745: AND rep.lookup_type (+) = C_STATUS_TYPE
746: AND rep.lookup_code (+) = v.replay_status_code

Line 743: fnd_user u3

739: fnd_lookup_values rep,
740: fnd_lookup_values ver,
741: fnd_user u1,
742: fnd_user u2,
743: fnd_user u3
744: WHERE version_id = p_version_id
745: AND rep.lookup_type (+) = C_STATUS_TYPE
746: AND rep.lookup_code (+) = v.replay_status_code
747: AND ver.lookup_type = C_STATUS_TYPE

Line 892: || ' fnd_user u1, '

888: || ' replayed_on, u3.user_name '
889: || 'FROM jts_config_versions_vl v, '
890: || ' fnd_lookup_values rep, '
891: || ' fnd_lookup_values ver, '
892: || ' fnd_user u1, '
893: || ' fnd_user u2, '
894: || ' fnd_user u3 '
895: || 'WHERE configuration_id = ' || p_config_id ||
896: ' AND rep.lookup_type (+) = ''' || C_STATUS_TYPE ||

Line 893: || ' fnd_user u2, '

889: || 'FROM jts_config_versions_vl v, '
890: || ' fnd_lookup_values rep, '
891: || ' fnd_lookup_values ver, '
892: || ' fnd_user u1, '
893: || ' fnd_user u2, '
894: || ' fnd_user u3 '
895: || 'WHERE configuration_id = ' || p_config_id ||
896: ' AND rep.lookup_type (+) = ''' || C_STATUS_TYPE ||
897: ''' AND rep.lookup_code (+)= v.replay_status_code ' ||

Line 894: || ' fnd_user u3 '

890: || ' fnd_lookup_values rep, '
891: || ' fnd_lookup_values ver, '
892: || ' fnd_user u1, '
893: || ' fnd_user u2, '
894: || ' fnd_user u3 '
895: || 'WHERE configuration_id = ' || p_config_id ||
896: ' AND rep.lookup_type (+) = ''' || C_STATUS_TYPE ||
897: ''' AND rep.lookup_code (+)= v.replay_status_code ' ||
898: ' AND ver.lookup_type = ''' || C_STATUS_TYPE ||