DBA Data[Home] [Help] [Dependency Information]

VIEW: PN.PN_VAR_TRX_DETAILS_ALL#

Object Details
Object Name: PN_VAR_TRX_DETAILS_ALL#
Object Type: VIEW
Owner: PN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRX_DETAIL_ID NUMBER (15) Yes
TRX_HEADER_ID NUMBER (15) Yes
BKPT_DETAIL_ID NUMBER (15) Yes
BKPT_RATE NUMBER
Yes
PRORATED_GRP_VOL_START NUMBER

PRORATED_GRP_VOL_END NUMBER

FY_PR_GRP_VOL_START NUMBER

FY_PR_GRP_VOL_END NUMBER

LY_PR_GRP_VOL_START NUMBER

LY_PR_GRP_VOL_END NUMBER

PR_GRP_BLENDED_VOL_START NUMBER

PR_GRP_BLENDED_VOL_END NUMBER

YTD_GROUP_VOL_START NUMBER

YTD_GROUP_VOL_END NUMBER

BLENDED_PERIOD_VOL_START NUMBER

BLENDED_PERIOD_VOL_END NUMBER

ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PN.PN_VAR_TRX_DETAILS_ALL# references the following:

SchemaPN
TablePN_VAR_TRX_DETAILS_ALL
PN.PN_VAR_TRX_DETAILS_ALL# is referenced by following:

SchemaAPPS
SynonymPN_VAR_TRX_DETAILS
SynonymPN_VAR_TRX_DETAILS_ALL