VIEW: PN.PN_VAR_TRX_DETAILS_ALL#

Source

View Text - Preformatted

select TRX_DETAIL_ID TRX_DETAIL_ID, TRX_HEADER_ID TRX_HEADER_ID, BKPT_DETAIL_ID BKPT_DETAIL_ID, BKPT_RATE BKPT_RATE, PRORATED_GRP_VOL_START PRORATED_GRP_VOL_START, PRORATED_GRP_VOL_END PRORATED_GRP_VOL_END, FY_PR_GRP_VOL_START FY_PR_GRP_VOL_START, FY_PR_GRP_VOL_END FY_PR_GRP_VOL_END, LY_PR_GRP_VOL_START LY_PR_GRP_VOL_START, LY_PR_GRP_VOL_END LY_PR_GRP_VOL_END, PR_GRP_BLENDED_VOL_START PR_GRP_BLENDED_VOL_START, PR_GRP_BLENDED_VOL_END PR_GRP_BLENDED_VOL_END, YTD_GROUP_VOL_START YTD_GROUP_VOL_START, YTD_GROUP_VOL_END YTD_GROUP_VOL_END, BLENDED_PERIOD_VOL_START BLENDED_PERIOD_VOL_START, BLENDED_PERIOD_VOL_END BLENDED_PERIOD_VOL_END, ORG_ID ORG_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PN"."PN_VAR_TRX_DETAILS_ALL"

View Text - HTML Formatted

SELECT TRX_DETAIL_ID TRX_DETAIL_ID
, TRX_HEADER_ID TRX_HEADER_ID
, BKPT_DETAIL_ID BKPT_DETAIL_ID
, BKPT_RATE BKPT_RATE
, PRORATED_GRP_VOL_START PRORATED_GRP_VOL_START
, PRORATED_GRP_VOL_END PRORATED_GRP_VOL_END
, FY_PR_GRP_VOL_START FY_PR_GRP_VOL_START
, FY_PR_GRP_VOL_END FY_PR_GRP_VOL_END
, LY_PR_GRP_VOL_START LY_PR_GRP_VOL_START
, LY_PR_GRP_VOL_END LY_PR_GRP_VOL_END
, PR_GRP_BLENDED_VOL_START PR_GRP_BLENDED_VOL_START
, PR_GRP_BLENDED_VOL_END PR_GRP_BLENDED_VOL_END
, YTD_GROUP_VOL_START YTD_GROUP_VOL_START
, YTD_GROUP_VOL_END YTD_GROUP_VOL_END
, BLENDED_PERIOD_VOL_START BLENDED_PERIOD_VOL_START
, BLENDED_PERIOD_VOL_END BLENDED_PERIOD_VOL_END
, ORG_ID ORG_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PN"."PN_VAR_TRX_DETAILS_ALL"