1. Tables and Views for Project Management
  2. PJF_BILLING_CYCLES_VL

PJF_BILLING_CYCLES_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

BILLING_CYCLE_NAME

BILLING_CYCLE_DESC

BILLING_CYCLE_ID

BILLING_CYCLE_TYPE

START_DATE_ACTIVE

END_DATE_ACTIVE

BILLING_ATTRIBUTE_CATEGORY

BILLING_VALUE1

BILLING_VALUE2

BILLING_VALUE3

BILLING_VALUE4

BILLING_VALUE5

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

Query

SQL_Statement

SELECT

PJF_BILLING_CYCLES_TL1.BILLING_CYCLE_NAME BILLING_CYCLE_NAME,

PJF_BILLING_CYCLES_TL1.BILLING_CYCLE_DESC BILLING_CYCLE_DESC,

PJF_BILLING_CYCLES_B1.BILLING_CYCLE_ID BILLING_CYCLE_ID,

PJF_BILLING_CYCLES_B1.BILLING_CYCLE_TYPE BILLING_CYCLE_TYPE,

PJF_BILLING_CYCLES_B1.START_DATE_ACTIVE START_DATE_ACTIVE,

PJF_BILLING_CYCLES_B1.END_DATE_ACTIVE END_DATE_ACTIVE,

PJF_BILLING_CYCLES_B1.BILLING_ATTRIBUTE_CATEGORY BILLING_ATTRIBUTE_CATEGORY,

PJF_BILLING_CYCLES_B1.BILLING_VALUE1 BILLING_VALUE1,

PJF_BILLING_CYCLES_B1.BILLING_VALUE2 BILLING_VALUE2,

PJF_BILLING_CYCLES_B1.BILLING_VALUE3 BILLING_VALUE3,

PJF_BILLING_CYCLES_B1.BILLING_VALUE4 BILLING_VALUE4,

PJF_BILLING_CYCLES_B1.BILLING_VALUE5 BILLING_VALUE5,

PJF_BILLING_CYCLES_B1.CREATED_BY CREATED_BY,

PJF_BILLING_CYCLES_B1.CREATION_DATE CREATION_DATE,

PJF_BILLING_CYCLES_B1.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_BILLING_CYCLES_B1.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_BILLING_CYCLES_B1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_BILLING_CYCLES_B1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_BILLING_CYCLES_B1.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PJF_BILLING_CYCLES_B1.ATTRIBUTE1 ATTRIBUTE1,

PJF_BILLING_CYCLES_B1.ATTRIBUTE2 ATTRIBUTE2,

PJF_BILLING_CYCLES_B1.ATTRIBUTE3 ATTRIBUTE3,

PJF_BILLING_CYCLES_B1.ATTRIBUTE4 ATTRIBUTE4,

PJF_BILLING_CYCLES_B1.ATTRIBUTE5 ATTRIBUTE5,

PJF_BILLING_CYCLES_B1.ATTRIBUTE6 ATTRIBUTE6,

PJF_BILLING_CYCLES_B1.ATTRIBUTE7 ATTRIBUTE7,

PJF_BILLING_CYCLES_B1.ATTRIBUTE8 ATTRIBUTE8,

PJF_BILLING_CYCLES_B1.ATTRIBUTE9 ATTRIBUTE9,

PJF_BILLING_CYCLES_B1.ATTRIBUTE10 ATTRIBUTE10,

PJF_BILLING_CYCLES_B1.ATTRIBUTE11 ATTRIBUTE11,

PJF_BILLING_CYCLES_B1.ATTRIBUTE12 ATTRIBUTE12,

PJF_BILLING_CYCLES_B1.ATTRIBUTE13 ATTRIBUTE13,

PJF_BILLING_CYCLES_B1.ATTRIBUTE14 ATTRIBUTE14,

PJF_BILLING_CYCLES_B1.ATTRIBUTE15 ATTRIBUTE15

FROM

PJF_BILLING_CYCLES_TL PJF_BILLING_CYCLES_TL1,

PJF_BILLING_CYCLES_B PJF_BILLING_CYCLES_B1

WHERE

PJF_BILLING_CYCLES_B1.BILLING_CYCLE_ID = PJF_BILLING_CYCLES_TL1.BILLING_CYCLE_ID AND PJF_BILLING_CYCLES_TL1.LANGUAGE = USERENV('LANG')