1. Tables and Views for Project Management
  2. PJS_PPC_REP_ASSOCIATIONS_VL

PJS_PPC_REP_ASSOCIATIONS_VL

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: VIEW

Columns

Name

ASSOCIATION_ID

REPORT_ID

TEMPLATE_FLAG

SRC_OBJECT_ID

SRC_OBJECT_TYPE

ASSOCIATION_NAME

ASSOCIATION_DESCRIPTION

INACTIVE_FLAG

AUTO_PUBLISH

FORMAT

CURRENCY_CODE

FREQUENCY

SCHEDULE_START_DATE

LAST_GENERATED_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

EXTERNAL_SOURCE

EXTERNAL_SOURCE_REFERENCE

ADDL_ATTRIBUTE1

ADDL_ATTRIBUTE2

ADDL_ATTRIBUTE3

ADDL_ATTRIBUTE4

ADDL_ATTRIBUTE5

OWNER_PERSON_ID

ARCHIVED_FLAG

REFRESH_FROM_ENT_PERIOD_NAME

Query

SQL_Statement

SELECT

PJS_PPC_REP_ASSOCIATIONS_B.ASSOCIATION_ID,

PJS_PPC_REP_ASSOCIATIONS_B.REPORT_ID,

PJS_PPC_REP_ASSOCIATIONS_B.TEMPLATE_FLAG,

PJS_PPC_REP_ASSOCIATIONS_B.SRC_OBJECT_ID,

PJS_PPC_REP_ASSOCIATIONS_B.SRC_OBJECT_TYPE,

PJS_PPC_REP_ASSOCIATIONS_TL.ASSOCIATION_NAME,

PJS_PPC_REP_ASSOCIATIONS_TL.ASSOCIATION_DESCRIPTION,

PJS_PPC_REP_ASSOCIATIONS_B.INACTIVE_FLAG,

PJS_PPC_REP_ASSOCIATIONS_B.AUTO_PUBLISH,

PJS_PPC_REP_ASSOCIATIONS_B.FORMAT,

PJS_PPC_REP_ASSOCIATIONS_B.CURRENCY_CODE,

PJS_PPC_REP_ASSOCIATIONS_B.FREQUENCY,

PJS_PPC_REP_ASSOCIATIONS_B.SCHEDULE_START_DATE,

PJS_PPC_REP_ASSOCIATIONS_B.LAST_GENERATED_DATE,

PJS_PPC_REP_ASSOCIATIONS_B.CREATED_BY,

PJS_PPC_REP_ASSOCIATIONS_B.CREATION_DATE,

PJS_PPC_REP_ASSOCIATIONS_B.LAST_UPDATED_BY,

PJS_PPC_REP_ASSOCIATIONS_B.LAST_UPDATE_DATE,

PJS_PPC_REP_ASSOCIATIONS_B.OBJECT_VERSION_NUMBER,

PJS_PPC_REP_ASSOCIATIONS_B.LAST_UPDATE_LOGIN,

PJS_PPC_REP_ASSOCIATIONS_B.EXTERNAL_SOURCE,

PJS_PPC_REP_ASSOCIATIONS_B.EXTERNAL_SOURCE_REFERENCE,

PJS_PPC_REP_ASSOCIATIONS_B.ADDL_ATTRIBUTE1,

PJS_PPC_REP_ASSOCIATIONS_B.ADDL_ATTRIBUTE2,

PJS_PPC_REP_ASSOCIATIONS_B.ADDL_ATTRIBUTE3,

PJS_PPC_REP_ASSOCIATIONS_B.ADDL_ATTRIBUTE4,

PJS_PPC_REP_ASSOCIATIONS_B.ADDL_ATTRIBUTE5,

PJS_PPC_REP_ASSOCIATIONS_B.OWNER_PERSON_ID,

PJS_PPC_REP_ASSOCIATIONS_B.ARCHIVED_FLAG,

PJS_PPC_REP_ASSOCIATIONS_B.REFRESH_FROM_ENT_PERIOD_NAME

FROM

PJS_PPC_REP_ASSOCIATIONS_B,

PJS_PPC_REP_ASSOCIATIONS_TL

WHERE

PJS_PPC_REP_ASSOCIATIONS_B.ASSOCIATION_ID = PJS_PPC_REP_ASSOCIATIONS_TL.ASSOCIATION_ID

AND PJS_PPC_REP_ASSOCIATIONS_TL.LANGUAGE = USERENV('LANG')