PJB_BILL_PLANS_VL

Details

• Schema: FUSION

• Object owner: PJB

• Object type: VIEW

Columns

Name

BILL_PLAN_ID MAJOR_VERSION VERSION_TYPE BILL_METHOD_ID CONTRACT_ID BILL_PLAN_NAME BILL_PLAN_DESC BILL_SET_NUM LAST_BILL_TO_DATE ON_HOLD_FLAG BILL_TO_CUST_ACCT_ID BILL_TO_SITE_USE_ID BILL_TO_CONTACT_ID INVOICE_CURRENCY_OPT_CODE PAYMENT_TERM_ID BILLING_CYCLE_ID FIRST_BILLING_OFFSET_DAYS LABOR_INVOICE_FORMAT_ID NL_INVOICE_FORMAT_ID EVENTS_INVOICE_FORMAT_ID EMP_BILL_RATE_SCH_ID LABOR_SCH_FIXED_DATE LABOR_DISCOUNT_PERCENTAGE LABOR_DISCOUNT_REASON_CODE NL_BILL_RATE_SCH_ID ORGANIZATION_ID NL_SCH_FIXED_DATE NL_DISCOUNT_PERCENTAGE NL_DISCOUNT_REASON_CODE JOB_BILL_RATE_SCH_ID JOB_SET_ID BURDEN_SCH_ID BURDEN_SCH_FIXED_DATE ENABLE_LBR_BILL_XTNSN_FLAG ENABLE_NL_BILL_XTNSN_FLAG BILL_TYPE_CLASS_CODE LABOR_TP_SCHEDULE_ID LABOR_TP_SCH_FIXED_DATE NL_TP_SCHEDULE_ID NL_TP_SCH_FIXED_DATE BILL_TO_CUSTOMER_LE_ID OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 EXTERNAL_KEY1 EXTERNAL_KEY2 INVOICE_CURRENCY_CODE INVOICE_CURR_RATE_TYPE INVOICE_CURR_DATE_TYPE INVOICE_CURR_EXCHG_DATE INVOICE_COMMENT INVOICE_INSTRUCTIONS SOURCE_BILL_PLAN_ID LABOR_BILL_BASIS_CODE LABOR_MARKUP_PERCENTAGE NL_BILL_BASIS_CODE NL_MARKUP_PERCENTAGE DOC_NUMBER LOC_FLAG REPORT_TYPE_CODE LANGUAGE SOURCE_LANG CURRENCY_OVRRD_FLAG INV_HDR_GROUPING_OPTIONS ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR31 ATTRIBUTE_CHAR32 ATTRIBUTE_CHAR33 ATTRIBUTE_CHAR34 ATTRIBUTE_CHAR35 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT B.BILL_PLAN_ID, B.MAJOR_VERSION, B.VERSION_TYPE, B.BILL_METHOD_ID, B.CONTRACT_ID, TL.BILL_PLAN_NAME, TL.BILL_PLAN_DESC, B.BILL_SET_NUM, B.LAST_BILL_TO_DATE, B.ON_HOLD_FLAG, B.BILL_TO_CUST_ACCT_ID, B.BILL_TO_SITE_USE_ID, B.BILL_TO_CONTACT_ID, B.INVOICE_CURRENCY_OPT_CODE, B.PAYMENT_TERM_ID, B.BILLING_CYCLE_ID, B.FIRST_BILLING_OFFSET_DAYS, B.LABOR_INVOICE_FORMAT_ID, B.NL_INVOICE_FORMAT_ID, B.EVENTS_INVOICE_FORMAT_ID, B.EMP_BILL_RATE_SCH_ID, B.LABOR_SCH_FIXED_DATE, B.LABOR_DISCOUNT_PERCENTAGE, B.LABOR_DISCOUNT_REASON_CODE, B.NL_BILL_RATE_SCH_ID, B.ORGANIZATION_ID, B.NL_SCH_FIXED_DATE, B.NL_DISCOUNT_PERCENTAGE, B.NL_DISCOUNT_REASON_CODE, B.JOB_BILL_RATE_SCH_ID, B.JOB_SET_ID, B.BURDEN_SCH_ID, B.BURDEN_SCH_FIXED_DATE, B.ENABLE_LBR_BILL_XTNSN_FLAG, B.ENABLE_NL_BILL_XTNSN_FLAG, B.BILL_TYPE_CLASS_CODE, B.LABOR_TP_SCHEDULE_ID, B.LABOR_TP_SCH_FIXED_DATE, B.NL_TP_SCHEDULE_ID, B.NL_TP_SCH_FIXED_DATE, B.BILL_TO_CUSTOMER_LE_ID, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.EXTERNAL_KEY1, B.EXTERNAL_KEY2, B.INVOICE_CURRENCY_CODE, B.INVOICE_CURR_RATE_TYPE, B.INVOICE_CURR_DATE_TYPE, B.INVOICE_CURR_EXCHG_DATE, TL.INVOICE_COMMENT, TL.INVOICE_INSTRUCTIONS, B.SOURCE_BILL_PLAN_ID, B.LABOR_BILL_BASIS_CODE, B.LABOR_MARKUP_PERCENTAGE, B.NL_BILL_BASIS_CODE, B.NL_MARKUP_PERCENTAGE, B.DOC_NUMBER, B.LOC_FLAG, B.REPORT_TYPE_CODE, TL.LANGUAGE, TL.SOURCE_LANG, B.CURRENCY_OVRRD_FLAG, B.INV_HDR_GROUPING_OPTIONS, B.ATTRIBUTE_CHAR16, B.ATTRIBUTE_CHAR17, B.ATTRIBUTE_CHAR18, B.ATTRIBUTE_CHAR19, B.ATTRIBUTE_CHAR20, B.ATTRIBUTE_CHAR21, B.ATTRIBUTE_CHAR22, B.ATTRIBUTE_CHAR23, B.ATTRIBUTE_CHAR24, B.ATTRIBUTE_CHAR25, B.ATTRIBUTE_CHAR26, B.ATTRIBUTE_CHAR27, B.ATTRIBUTE_CHAR28, B.ATTRIBUTE_CHAR29, B.ATTRIBUTE_CHAR30, B.ATTRIBUTE_CHAR31, B.ATTRIBUTE_CHAR32, B.ATTRIBUTE_CHAR33, B.ATTRIBUTE_CHAR34, B.ATTRIBUTE_CHAR35, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_DATE6, B.ATTRIBUTE_DATE7, B.ATTRIBUTE_DATE8, B.ATTRIBUTE_DATE9, B.ATTRIBUTE_DATE10, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5 FROM PJB_BILL_PLANS_B B, PJB_BILL_PLANS_TL TL WHERE B.BILL_PLAN_ID = TL.BILL_PLAN_ID AND B.MAJOR_VERSION = TL.MAJOR_VERSION AND TL.LANGUAGE = USERENV('LANG')