VIEW: APPS.PV_PARTNER_PROGRAM_VL

Source

View Text - Preformatted

SELECT pvab.rowid row_id, pvab.program_id, pvab.object_version_number, pvab.custom_setup_id, pvab.program_parent_id, pvab.program_owner_resource_id, pvab.program_type_id, pvab.program_level_code, pvab.program_status_code, pvab.enabled_flag, pvab.program_start_date, pvab.program_end_date, pvab.process_rule_id, pvab.user_status_id, pvab.membership_period_unit, pvab.membership_valid_period, pvab.submit_child_nodes, pvab.inventory_item_id, pvab.inventory_item_org_id, pvab.bus_user_resp_id, pvab.admin_resp_id, pvab.no_fee_flag, pvab.qsnr_ttl_all_page_dsp_flag, pvab.qsnr_hdr_all_page_dsp_flag, pvab.qsnr_ftr_all_page_dsp_flag, pvab.allow_enrl_wout_chklst_flag, pvab.allow_enrl_until_date, pvab.citem_version_id, pvab.vad_invite_allow_flag, pvab.global_mmbr_reqd_flag, pvab.waive_subsidiary_fee_flag, pvab.prereq_process_rule_id, pvab.created_by, pvab.creation_date, pvab.last_update_date, pvab.last_updated_by, pvab.last_update_login, pvab.attribute_category, pvab.attribute1, pvab.attribute2, pvab.attribute3, pvab.attribute4, pvab.attribute5, pvab.attribute6, pvab.attribute7, pvab.attribute8, pvab.attribute9, pvab.attribute10, pvab.attribute11, pvab.attribute12, pvab.attribute13, pvab.attribute14, pvab.attribute15, pvatl.program_name, pvatl.program_description, pvatl.qsnr_title, pvatl.qsnr_header, pvatl.qsnr_footer FROM pv_partner_program_b pvab, pv_partner_program_tl pvatl WHERE pvab.program_id = pvatl.program_id and pvatl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT PVAB.ROWID ROW_ID
, PVAB.PROGRAM_ID
, PVAB.OBJECT_VERSION_NUMBER
, PVAB.CUSTOM_SETUP_ID
, PVAB.PROGRAM_PARENT_ID
, PVAB.PROGRAM_OWNER_RESOURCE_ID
, PVAB.PROGRAM_TYPE_ID
, PVAB.PROGRAM_LEVEL_CODE
, PVAB.PROGRAM_STATUS_CODE
, PVAB.ENABLED_FLAG
, PVAB.PROGRAM_START_DATE
, PVAB.PROGRAM_END_DATE
, PVAB.PROCESS_RULE_ID
, PVAB.USER_STATUS_ID
, PVAB.MEMBERSHIP_PERIOD_UNIT
, PVAB.MEMBERSHIP_VALID_PERIOD
, PVAB.SUBMIT_CHILD_NODES
, PVAB.INVENTORY_ITEM_ID
, PVAB.INVENTORY_ITEM_ORG_ID
, PVAB.BUS_USER_RESP_ID
, PVAB.ADMIN_RESP_ID
, PVAB.NO_FEE_FLAG
, PVAB.QSNR_TTL_ALL_PAGE_DSP_FLAG
, PVAB.QSNR_HDR_ALL_PAGE_DSP_FLAG
, PVAB.QSNR_FTR_ALL_PAGE_DSP_FLAG
, PVAB.ALLOW_ENRL_WOUT_CHKLST_FLAG
, PVAB.ALLOW_ENRL_UNTIL_DATE
, PVAB.CITEM_VERSION_ID
, PVAB.VAD_INVITE_ALLOW_FLAG
, PVAB.GLOBAL_MMBR_REQD_FLAG
, PVAB.WAIVE_SUBSIDIARY_FEE_FLAG
, PVAB.PREREQ_PROCESS_RULE_ID
, PVAB.CREATED_BY
, PVAB.CREATION_DATE
, PVAB.LAST_UPDATE_DATE
, PVAB.LAST_UPDATED_BY
, PVAB.LAST_UPDATE_LOGIN
, PVAB.ATTRIBUTE_CATEGORY
, PVAB.ATTRIBUTE1
, PVAB.ATTRIBUTE2
, PVAB.ATTRIBUTE3
, PVAB.ATTRIBUTE4
, PVAB.ATTRIBUTE5
, PVAB.ATTRIBUTE6
, PVAB.ATTRIBUTE7
, PVAB.ATTRIBUTE8
, PVAB.ATTRIBUTE9
, PVAB.ATTRIBUTE10
, PVAB.ATTRIBUTE11
, PVAB.ATTRIBUTE12
, PVAB.ATTRIBUTE13
, PVAB.ATTRIBUTE14
, PVAB.ATTRIBUTE15
, PVATL.PROGRAM_NAME
, PVATL.PROGRAM_DESCRIPTION
, PVATL.QSNR_TITLE
, PVATL.QSNR_HEADER
, PVATL.QSNR_FOOTER
FROM PV_PARTNER_PROGRAM_B PVAB
, PV_PARTNER_PROGRAM_TL PVATL
WHERE PVAB.PROGRAM_ID = PVATL.PROGRAM_ID
AND PVATL.LANGUAGE = USERENV('LANG')