PJB_BILLING_METHODS_VL

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name
BILL_METHOD_ID BILL_METHOD_FLAG BILL_TYPE_CLASS_CODE INTERCOMPANY_METHOD LABOR_RATE_TYPE_CODE NL_RATE_TYPE_CODE ACTIVE_FLAG OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN BILL_METHOD_NAME BILL_METHOD_DESC METHOD_CFG_TYPE CALCULATION_LEVEL_CODE

Query

SQL_Statement

SELECT PJB_BILLING_METHODS_B.BILL_METHOD_ID BILL_METHOD_ID, PJB_BILLING_METHODS_B.BILL_METHOD_FLAG BILL_METHOD_FLAG, PJB_BILLING_METHODS_B.BILL_TYPE_CLASS_CODE BILL_TYPE_CLASS_CODE, PJB_BILLING_METHODS_B.INTERCOMPANY_METHOD INTERCOMPANY_METHOD, PJB_BILLING_METHODS_B.LABOR_RATE_TYPE_CODE LABOR_RATE_TYPE_CODE, PJB_BILLING_METHODS_B.NL_RATE_TYPE_CODE NL_RATE_TYPE_CODE, PJB_BILLING_METHODS_B.ACTIVE_FLAG ACTIVE_FLAG, PJB_BILLING_METHODS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJB_BILLING_METHODS_B.CREATION_DATE CREATION_DATE, PJB_BILLING_METHODS_B.CREATED_BY CREATED_BY, PJB_BILLING_METHODS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJB_BILLING_METHODS_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJB_BILLING_METHODS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJB_BILLING_METHODS_TL.BILL_METHOD_NAME BILL_METHOD_NAME, PJB_BILLING_METHODS_TL.BILL_METHOD_DESC BILL_METHOD_DESC, PJB_BILLING_METHODS_B.METHOD_CFG_TYPE METHOD_CFG_TYPE, PJB_BILLING_METHODS_B.CALCULATION_LEVEL_CODE CALCULATION_LEVEL_CODE FROM PJB_BILLING_METHODS_B, PJB_BILLING_METHODS_TL WHERE PJB_BILLING_METHODS_B.BILL_METHOD_ID = PJB_BILLING_METHODS_TL.BILL_METHOD_ID AND PJB_BILLING_METHODS_TL.LANGUAGE = USERENV('LANG')