PSC_XLA_LNP_FEE_RECORD

Details

Schema: FUSION
Object owner: PSC_PER
Object type: VIEW

Columns

Name
FEE_RECORD_KEY LNP_RECORD_KEY LNP_RECORD_ID EVENT_ID FEE_SCHEDULE_ID FEE_SCHEDULE_LINE FEE_ITEM_ID RECORD_TYPE DEPARTMENT_ID FEE_AMOUNT CURRENCY_CODE CUR_CONVERSION_DATE CUR_CONVERSION_RATE CUR_CONVERSION_TYPE FEE_MEMO PAYMENT_DATE ACCOUNTING_DATE INVOICE INVOICE_LINE PAYMENT_REFERENCE_ID PAYMENT_METHOD_CODE FEE_SOURCE ATTRIBUTE_CATEGORY CLASSIFICATION STATUS APPLICANT PERSON_TITLE PERSON_NAME GENDER ORGANIZATION_NAME COUNTRY STATE PROVINCE COUNTY POSTAL_CODE POSTAL_PLUS4_CODE ORIGINATOR MOBILE_FLAG PROJECT_KEY SUBMIT_DATE SUBMITTED_BY RENEWAL_DATE ISSUE_DATE EXPIRATION_DATE BUS_BUSINESS_NAME BUS_DBA_BUSINESS_NAME BUS_DESCRIPTION BUS_INDUSTRY_ID BUS_OWNERSHIP_TYPE BUS_FEMALE_OWNED_FLAG BUS_MINORITY_OWNED_FLAG BUS_DISADV_OWNED_FLAG FILER_ID AGENCY_ID RECORD_NAME RECORD_NUMBER CREATED_BY LAST_UPDATE_LOGIN CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE

Name

FEE_RECORD_KEY

LNP_RECORD_KEY

LNP_RECORD_ID

EVENT_ID

FEE_SCHEDULE_ID

FEE_SCHEDULE_LINE

FEE_ITEM_ID

RECORD_TYPE

DEPARTMENT_ID

FEE_AMOUNT

CURRENCY_CODE

CUR_CONVERSION_DATE

CUR_CONVERSION_RATE

CUR_CONVERSION_TYPE

FEE_MEMO

PAYMENT_DATE

ACCOUNTING_DATE

INVOICE

INVOICE_LINE

PAYMENT_REFERENCE_ID

PAYMENT_METHOD_CODE

FEE_SOURCE

ATTRIBUTE_CATEGORY

CLASSIFICATION

STATUS

APPLICANT

PERSON_TITLE

PERSON_NAME

GENDER

ORGANIZATION_NAME

COUNTRY

STATE

PROVINCE

COUNTY

POSTAL_CODE

POSTAL_PLUS4_CODE

ORIGINATOR

MOBILE_FLAG

PROJECT_KEY

SUBMIT_DATE

SUBMITTED_BY

RENEWAL_DATE

ISSUE_DATE

EXPIRATION_DATE

BUS_BUSINESS_NAME

BUS_DBA_BUSINESS_NAME

BUS_DESCRIPTION

BUS_INDUSTRY_ID

BUS_OWNERSHIP_TYPE

BUS_FEMALE_OWNED_FLAG

BUS_MINORITY_OWNED_FLAG

BUS_DISADV_OWNED_FLAG

FILER_ID

AGENCY_ID

RECORD_NAME

RECORD_NUMBER

CREATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

Query

SQL_Statement
SELECT FR.FEE_RECORD_KEY FEE_RECORD_KEY, FR.LNP_RECORD_KEY LNP_RECORD_KEY, FR.LNP_RECORD_ID LNP_RECORD_ID, FR.EVENT_ID EVENT_ID, FR.FEE_SCHEDULE_ID FEE_SCHEDULE_ID, FR.FEE_SCHEDULE_LINE FEE_SCHEDULE_LINE, FR.FEE_ITEM_ID FEE_ITEM_ID, RT.RECORD_TYPE RECORD_TYPE, FR.DEPARTMENT_ID DEPARTMENT_ID, FR.FEE_AMOUNT FEE_AMOUNT, FR.CURRENCY_CODE CURRENCY_CODE, CAST (NULL AS DATE) AS CUR_CONVERSION_DATE, CAST (NULL AS NUMBER) AS CUR_CONVERSION_RATE, CAST (NULL AS VARCHAR2(30)) AS CUR_CONVERSION_TYPE, FR.FEE_MEMO FEE_MEMO, FR.PAYMENT_DATE PAYMENT_DATE, FR.ACCOUNTING_DATE ACCOUNTING_DATE, FR.INVOICE INVOICE, FR.INVOICE_LINE INVOICE_LINE, FR.PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID, FR.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, FR.FEE_SOURCE FEE_SOURCE, R.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, R.CLASSIFICATION CLASSIFICATION, R.STATUS STATUS, R.APPLICANT APPLICANT, R.PERSON_TITLE PERSON_TITLE, R.PERSON_NAME PERSON_NAME, R.GENDER GENDER, R.ORGANIZATION_NAME ORGANIZATION_NAME, R.COUNTRY COUNTRY, R.STATE STATE, R.PROVINCE PROVINCE, R.COUNTY COUNTY, R.POSTAL_CODE POSTAL_CODE, R.POSTAL_PLUS4_CODE POSTAL_PLUS4_CODE, R.ORIGINATOR ORIGINATOR, R.MOBILE_FLAG MOBILE_FLAG, R.PROJECT_KEY PROJECT_KEY, R.SUBMIT_DATE SUBMIT_DATE, R.SUBMITTED_BY SUBMITTED_BY, R.RENEWAL_DATE RENEWAL_DATE, R.ISSUE_DATE ISSUE_DATE, R.EXPIRATION_DATE EXPIRATION_DATE, R.BUS_BUSINESS_NAME BUS_BUSINESS_NAME, R.BUS_DBA_BUSINESS_NAME BUS_DBA_BUSINESS_NAME, R.BUS_DESCRIPTION BUS_DESCRIPTION, R.BUS_INDUSTRY_ID BUS_INDUSTRY_ID, R.BUS_OWNERSHIP_TYPE BUS_OWNERSHIP_TYPE, R.BUS_FEMALE_OWNED_FLAG BUS_FEMALE_OWNED_FLAG, R.BUS_MINORITY_OWNED_FLAG BUS_MINORITY_OWNED_FLAG, R.BUS_DISADV_OWNED_FLAG BUS_DISADV_OWNED_FLAG, R.FILER_ID FILER_ID, R.AGENCY_ID AGENCY_ID, R.RECORD_NAME RECORD_NAME, R.RECORD_NUMBER RECORD_NUMBER, FR.CREATED_BY CREATED_BY, FR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FR.CREATION_DATE CREATION_DATE, FR.LAST_UPDATED_BY LAST_UPDATED_BY, FR.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM PSC_LNP_FEE_RECORD FR, PSC_LNP_RECORD_TYPE_TL RT, PSC_LNP_RECORD R WHERE FR.LNP_RECORD_KEY = R.LNP_RECORD_KEY AND R.ATTRIBUTE_CATEGORY = RT.RECORD_TYPE_ID AND RT.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

FR.FEE_RECORD_KEY FEE_RECORD_KEY,

FR.LNP_RECORD_KEY LNP_RECORD_KEY,

FR.LNP_RECORD_ID LNP_RECORD_ID,

FR.EVENT_ID EVENT_ID,

FR.FEE_SCHEDULE_ID FEE_SCHEDULE_ID,

FR.FEE_SCHEDULE_LINE FEE_SCHEDULE_LINE,

FR.FEE_ITEM_ID FEE_ITEM_ID,

RT.RECORD_TYPE RECORD_TYPE,

FR.DEPARTMENT_ID DEPARTMENT_ID,

FR.FEE_AMOUNT FEE_AMOUNT,

FR.CURRENCY_CODE CURRENCY_CODE,

CAST (NULL AS DATE) AS CUR_CONVERSION_DATE,

CAST (NULL AS NUMBER) AS CUR_CONVERSION_RATE,

CAST (NULL AS VARCHAR2(30)) AS CUR_CONVERSION_TYPE,

FR.FEE_MEMO FEE_MEMO,

FR.PAYMENT_DATE PAYMENT_DATE,

FR.ACCOUNTING_DATE ACCOUNTING_DATE,

FR.INVOICE INVOICE,

FR.INVOICE_LINE INVOICE_LINE,

FR.PAYMENT_REFERENCE_ID PAYMENT_REFERENCE_ID,

FR.PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE,

FR.FEE_SOURCE FEE_SOURCE,

R.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

R.CLASSIFICATION CLASSIFICATION,

R.STATUS STATUS,

R.APPLICANT APPLICANT,

R.PERSON_TITLE PERSON_TITLE,

R.PERSON_NAME PERSON_NAME,

R.GENDER GENDER,

R.ORGANIZATION_NAME ORGANIZATION_NAME,

R.COUNTRY COUNTRY,

R.STATE STATE,

R.PROVINCE PROVINCE,

R.COUNTY COUNTY,

R.POSTAL_CODE POSTAL_CODE,

R.POSTAL_PLUS4_CODE POSTAL_PLUS4_CODE,

R.ORIGINATOR ORIGINATOR,

R.MOBILE_FLAG MOBILE_FLAG,

R.PROJECT_KEY PROJECT_KEY,

R.SUBMIT_DATE SUBMIT_DATE,

R.SUBMITTED_BY SUBMITTED_BY,

R.RENEWAL_DATE RENEWAL_DATE,

R.ISSUE_DATE ISSUE_DATE,

R.EXPIRATION_DATE EXPIRATION_DATE,

R.BUS_BUSINESS_NAME BUS_BUSINESS_NAME,

R.BUS_DBA_BUSINESS_NAME BUS_DBA_BUSINESS_NAME,

R.BUS_DESCRIPTION BUS_DESCRIPTION,

R.BUS_INDUSTRY_ID BUS_INDUSTRY_ID,

R.BUS_OWNERSHIP_TYPE BUS_OWNERSHIP_TYPE,

R.BUS_FEMALE_OWNED_FLAG BUS_FEMALE_OWNED_FLAG,

R.BUS_MINORITY_OWNED_FLAG BUS_MINORITY_OWNED_FLAG,

R.BUS_DISADV_OWNED_FLAG BUS_DISADV_OWNED_FLAG,

R.FILER_ID FILER_ID,

R.AGENCY_ID AGENCY_ID,

R.RECORD_NAME RECORD_NAME,

R.RECORD_NUMBER RECORD_NUMBER,

FR.CREATED_BY CREATED_BY,

FR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

FR.CREATION_DATE CREATION_DATE,

FR.LAST_UPDATED_BY LAST_UPDATED_BY,

FR.LAST_UPDATE_DATE LAST_UPDATE_DATE

FROM

PSC_LNP_FEE_RECORD FR,

PSC_LNP_RECORD_TYPE_TL RT,

PSC_LNP_RECORD R

WHERE

FR.LNP_RECORD_KEY = R.LNP_RECORD_KEY AND R.ATTRIBUTE_CATEGORY = RT.RECORD_TYPE_ID AND RT.LANGUAGE = USERENV('LANG')