Product: | PV - Partner Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PV_PARTNER_PROGRAM_V |
SELECT PVAB.ROWID ROW_ID
, PVAB.PROGRAM_ID
, PVAB.OBJECT_VERSION_NUMBER
, PVAB.PROGRAM_PARENT_ID
, PVAB.CUSTOM_SETUP_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.ADMIN_RESP_ID
, PVAB.BUS_USER_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.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
, PVAB.CREATED_BY
, PVAB.CREATION_DATE
, PVAB.LAST_UPDATED_BY
, PVAB.LAST_UPDATE_DATE
, PVAB.LAST_UPDATE_LOGIN
, PVAB.PROGRAM_ID ID1
, '#' ID2
, PVATL.PROGRAM_DESCRIPTION DESCRIPTION
, PVATL.PROGRAM_NAME NAME
, PVAB.PROGRAM_START_DATE START_DATE_ACTIVE
, PVAB.PROGRAM_END_DATE END_DATE_ACTIVE
FROM PV_PARTNER_PROGRAM_B PVAB
, PV_PARTNER_PROGRAM_TL PVATL
WHERE PVAB.PROGRAM_ID = PVATL.PROGRAM_ID
AND PVATL.LANGUAGE = USERENV('LANG')