VIEW: APPS.PV_LEAD_PSS_LINES_V

Source

View Text - Preformatted

SELECT PSS.LEAD_PSS_LINE_ID ,PSS. LAST_UPDATE_DATE ,PSS. LAST_UPDATED_BY ,PSS. CREATION_DATE ,PSS.CREATED_BY ,PSS. LAST_UPDATE_LOGIN ,PSS.OBJECT_VERSION_NUMBER ,PSS. REQUEST_ID ,PSS.PROGRAM_APPLICATION_ID ,PSS.PROGRAM_ID ,PSS.PROGRAM_UPDATE_DATE ,PSS.ATTR_CODE_ID ,PSS. LEAD_ID ,PSS.UOM_CODE ,PSS.QUANTITY ,PSS.AMOUNT ,PSS.OBJECT_NAME ,CODE. ATTR_CODE ,ACTL. DESCRIPTION ,CODE. ATTRIBUTE_ID ,CODE. ENABLED_FLAG ,CODE. START_DATE_ACTIVE ,CODE. END_DATE_ACTIVE ,CODE. AUTO_ASSIGN_FLAG ,PSS.OBJECT_ID ,PSS.PARTNER_ID FROM PV_LEAD_PSS_LINES PSS,PV_ATTRIBUTE_CODES_B CODE ,PV_ATTRIBUTE_CODES_TL ACTL WHERE pss.attr_code_id = code.attr_code_id and code.attr_code_id = actl.attr_code_id and actl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT PSS.LEAD_PSS_LINE_ID
, PSS. LAST_UPDATE_DATE
, PSS. LAST_UPDATED_BY
, PSS. CREATION_DATE
, PSS.CREATED_BY
, PSS. LAST_UPDATE_LOGIN
, PSS.OBJECT_VERSION_NUMBER
, PSS. REQUEST_ID
, PSS.PROGRAM_APPLICATION_ID
, PSS.PROGRAM_ID
, PSS.PROGRAM_UPDATE_DATE
, PSS.ATTR_CODE_ID
, PSS. LEAD_ID
, PSS.UOM_CODE
, PSS.QUANTITY
, PSS.AMOUNT
, PSS.OBJECT_NAME
, CODE. ATTR_CODE
, ACTL. DESCRIPTION
, CODE. ATTRIBUTE_ID
, CODE. ENABLED_FLAG
, CODE. START_DATE_ACTIVE
, CODE. END_DATE_ACTIVE
, CODE. AUTO_ASSIGN_FLAG
, PSS.OBJECT_ID
, PSS.PARTNER_ID
FROM PV_LEAD_PSS_LINES PSS
, PV_ATTRIBUTE_CODES_B CODE
, PV_ATTRIBUTE_CODES_TL ACTL
WHERE PSS.ATTR_CODE_ID = CODE.ATTR_CODE_ID
AND CODE.ATTR_CODE_ID = ACTL.ATTR_CODE_ID
AND ACTL.LANGUAGE = USERENV('LANG')