VIEW: APPS.QPR_PR_SEGMENTS_ALL_VL

Source

View Text - Preformatted

SELECT b.pr_segment_id, tl.name, tl.description, b.instance_id, b.default_policy_id, b.policy_importance_code, b.policy_precedence, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login, b.program_id, b.program_login_id, b.program_application_id, b.request_id FROM qpr_pr_segments_b b, qpr_pr_segments_tl tl WHERE b.pr_segment_id = tl.pr_segment_id AND tl.LANGUAGE = userenv('LANG') union all select to_number(qpr_sr_util.get_null_pk), qpr_sr_util.get_null_desc, qpr_sr_util.get_null_desc, null, to_number(nvl(fnd_profile.value('QPR_DEFAULT_POLICY'),0)), null, null, sysdate, -1, sysdate, -1, -1, null, null, null, null from dual

View Text - HTML Formatted

SELECT B.PR_SEGMENT_ID
, TL.NAME
, TL.DESCRIPTION
, B.INSTANCE_ID
, B.DEFAULT_POLICY_ID
, B.POLICY_IMPORTANCE_CODE
, B.POLICY_PRECEDENCE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.PROGRAM_ID
, B.PROGRAM_LOGIN_ID
, B.PROGRAM_APPLICATION_ID
, B.REQUEST_ID
FROM QPR_PR_SEGMENTS_B B
, QPR_PR_SEGMENTS_TL TL
WHERE B.PR_SEGMENT_ID = TL.PR_SEGMENT_ID
AND TL.LANGUAGE = USERENV('LANG') UNION ALL SELECT TO_NUMBER(QPR_SR_UTIL.GET_NULL_PK)
, QPR_SR_UTIL.GET_NULL_DESC
, QPR_SR_UTIL.GET_NULL_DESC
, NULL
, TO_NUMBER(NVL(FND_PROFILE.VALUE('QPR_DEFAULT_POLICY')
, 0))
, NULL
, NULL
, SYSDATE
, -1
, SYSDATE
, -1
, -1
, NULL
, NULL
, NULL
, NULL
FROM DUAL