VIEW: PA.PA_IMPLEMENTATIONS_ALL#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID, START_ORGANIZATION_ID START_ORGANIZATION_ID, USER_DEFINED_PROJECT_NUM_CODE USER_DEFINED_PROJECT_NUM_CODE, MANUAL_PROJECT_NUM_TYPE MANUAL_PROJECT_NUM_TYPE, PROJECT_ORGANIZATION_TYPE PROJECT_ORGANIZATION_TYPE, EXP_CYCLE_START_DAY_CODE EXP_CYCLE_START_DAY_CODE, OVERTIME_CALC_ENABLED_FLAG OVERTIME_CALC_ENABLED_FLAG, INTERFACE_LABOR_TO_GL_FLAG INTERFACE_LABOR_TO_GL_FLAG, INTERFACE_USAGE_TO_GL_FLAG INTERFACE_USAGE_TO_GL_FLAG, INTERFACE_REVENUE_TO_GL_FLAG INTERFACE_REVENUE_TO_GL_FLAG, BILLING_CYCLE BILLING_CYCLE, BILLING_OFFSET BILLING_OFFSET, USER_DEFINED_INVOICE_NUM_CODE USER_DEFINED_INVOICE_NUM_CODE, MANUAL_INVOICE_NUM_TYPE MANUAL_INVOICE_NUM_TYPE, INVOICE_ORGANIZATION_TYPE INVOICE_ORGANIZATION_TYPE, INVOICE_BATCH_SOURCE_ID INVOICE_BATCH_SOURCE_ID, ACCUMULATION_PERIOD_TYPE ACCUMULATION_PERIOD_TYPE, PA_PERIOD_TYPE PA_PERIOD_TYPE, NEXT_AUTOMATIC_INVOICE_NUMBER NEXT_AUTOMATIC_INVOICE_NUMBER, ORG_ID ORG_ID, EXP_ORG_STRUCTURE_ID EXP_ORG_STRUCTURE_ID, EXP_ORG_STRUCTURE_VERSION_ID EXP_ORG_STRUCTURE_VERSION_ID, EXP_START_ORG_ID EXP_START_ORG_ID, PROJ_ORG_STRUCTURE_ID PROJ_ORG_STRUCTURE_ID, PROJ_ORG_STRUCTURE_VERSION_ID PROJ_ORG_STRUCTURE_VERSION_ID, PROJ_START_ORG_ID PROJ_START_ORG_ID, CENTRALIZED_INVOICING_FLAG CENTRALIZED_INVOICING_FLAG, ALLOW_FOREIGN_CURR_TXN_FLAG ALLOW_FOREIGN_CURR_TXN_FLAG, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_RATE_DATE_CODE ACCT_RATE_DATE_CODE, ALLOW_ACCT_USER_RATE_TYPE_FLAG ALLOW_ACCT_USER_RATE_TYPE_FLAG, OUTPUT_TAX_USE_CUST_FLAG OUTPUT_TAX_USE_CUST_FLAG, OUTPUT_TAX_USE_SITE_FLAG OUTPUT_TAX_USE_SITE_FLAG, OUTPUT_TAX_USE_PROJECT_FLAG OUTPUT_TAX_USE_PROJECT_FLAG, OUTPUT_TAX_USE_EXP_EV_FLAG OUTPUT_TAX_USE_EXP_EV_FLAG, OUTPUT_TAX_USE_EXTN_FLAG OUTPUT_TAX_USE_EXTN_FLAG, OUTPUT_TAX_USE_AR_PARAM_FLAG OUTPUT_TAX_USE_AR_PARAM_FLAG, OUTPUT_TAX_HIER_CUST OUTPUT_TAX_HIER_CUST, OUTPUT_TAX_HIER_SITE OUTPUT_TAX_HIER_SITE, OUTPUT_TAX_HIER_PROJECT OUTPUT_TAX_HIER_PROJECT, OUTPUT_TAX_HIER_EXP_EV OUTPUT_TAX_HIER_EXP_EV, OUTPUT_TAX_HIER_EXTN OUTPUT_TAX_HIER_EXTN, OUTPUT_TAX_HIER_AR_PARAM OUTPUT_TAX_HIER_AR_PARAM, DEFAULT_RATE_TYPE DEFAULT_RATE_TYPE, DEFAULT_RATE_DATE_CODE DEFAULT_RATE_DATE_CODE, CC_PROCESS_IO_CODE CC_PROCESS_IO_CODE, CC_DEFAULT_RATE_TYPE CC_DEFAULT_RATE_TYPE, CC_DEFAULT_RATE_DATE_CODE CC_DEFAULT_RATE_DATE_CODE, CC_ALLOW_IU_FLAG CC_ALLOW_IU_FLAG, CC_PROCESS_IU_CODE CC_PROCESS_IU_CODE, CC_IC_BILLING_PRVDR_FLAG CC_IC_BILLING_PRVDR_FLAG, VENDOR_ID VENDOR_ID, CC_MANUAL_INVOICE_NUM_TYPE CC_MANUAL_INVOICE_NUM_TYPE, CC_MANUAL_INVOICE_NUM_CODE CC_MANUAL_INVOICE_NUM_CODE, CC_NEXT_AUTOMATIC_INVOICE_NUM CC_NEXT_AUTOMATIC_INVOICE_NUM, CC_IC_AR_BATCH_SOURCE_ID CC_IC_AR_BATCH_SOURCE_ID, CC_PRVDR_CAC_COST_RECLASS_CODE CC_PRVDR_CAC_COST_RECLASS_CODE, CC_PRVDR_OTH_COST_RECLASS_CODE CC_PRVDR_OTH_COST_RECLASS_CODE, CC_IC_BILLING_RECVR_FLAG CC_IC_BILLING_RECVR_FLAG, CUSTOMER_ID CUSTOMER_ID, COMPETENCE_MATCH_WT COMPETENCE_MATCH_WT, AVAILABILITY_MATCH_WT AVAILABILITY_MATCH_WT, JOB_LEVEL_MATCH_WT JOB_LEVEL_MATCH_WT, MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG, SHARE_ACROSS_OU_BR_SCH_FLAG SHARE_ACROSS_OU_BR_SCH_FLAG, ALLOW_FUNDING_ACROSS_OU_FLAG ALLOW_FUNDING_ACROSS_OU_FLAG, PERIOD_SET_NAME PERIOD_SET_NAME, SAME_PA_GL_PERIOD SAME_PA_GL_PERIOD, ADV_ACTION_SET_ID ADV_ACTION_SET_ID, RETN_ACCOUNTING_FLAG RETN_ACCOUNTING_FLAG, FTE_DAY FTE_DAY, FTE_WEEK FTE_WEEK, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG, ENABLE_MRC_FOR_FUND_FLAG ENABLE_MRC_FOR_FUND_FLAG, REVAL_MRC_FUNDING_FLAG REVAL_MRC_FUNDING_FLAG, ENABLE_MRC_FOR_FINPLAN_FLAG ENABLE_MRC_FOR_FINPLAN_FLAG, FINPLAN_MRC_OPTION_CODE FINPLAN_MRC_OPTION_CODE, RATE_DISCOUNT_REASON_FLAG RATE_DISCOUNT_REASON_FLAG, BR_OVERRIDE_FLAG BR_OVERRIDE_FLAG, BR_DISCOUNT_OVERRIDE_FLAG BR_DISCOUNT_OVERRIDE_FLAG, CREDIT_MEMO_REASON_FLAG CREDIT_MEMO_REASON_FLAG, CUST_ACC_REL_CODE CUST_ACC_REL_CODE, SALES_CREDIT_TYPE_CODE SALES_CREDIT_TYPE_CODE, BOOK_TYPE_CODE BOOK_TYPE_CODE, XFACE_CWK_LABOR_TO_GL_FLAG XFACE_CWK_LABOR_TO_GL_FLAG, XFACE_CWK_TIMECARDS_FLAG XFACE_CWK_TIMECARDS_FLAG, DEF_SUPPLIER_COST_CR_CCID DEF_SUPPLIER_COST_CR_CCID, INVOICE_NZ_LINES INVOICE_NZ_LINES, CREATE_ON_ACCOUNT_CM CREATE_ON_ACCOUNT_CM, ALLOW_NEGATIVE_ACCRUAL ALLOW_NEGATIVE_ACCRUAL from "PA"."PA_IMPLEMENTATIONS_ALL"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, START_ORGANIZATION_ID START_ORGANIZATION_ID
, USER_DEFINED_PROJECT_NUM_CODE USER_DEFINED_PROJECT_NUM_CODE
, MANUAL_PROJECT_NUM_TYPE MANUAL_PROJECT_NUM_TYPE
, PROJECT_ORGANIZATION_TYPE PROJECT_ORGANIZATION_TYPE
, EXP_CYCLE_START_DAY_CODE EXP_CYCLE_START_DAY_CODE
, OVERTIME_CALC_ENABLED_FLAG OVERTIME_CALC_ENABLED_FLAG
, INTERFACE_LABOR_TO_GL_FLAG INTERFACE_LABOR_TO_GL_FLAG
, INTERFACE_USAGE_TO_GL_FLAG INTERFACE_USAGE_TO_GL_FLAG
, INTERFACE_REVENUE_TO_GL_FLAG INTERFACE_REVENUE_TO_GL_FLAG
, BILLING_CYCLE BILLING_CYCLE
, BILLING_OFFSET BILLING_OFFSET
, USER_DEFINED_INVOICE_NUM_CODE USER_DEFINED_INVOICE_NUM_CODE
, MANUAL_INVOICE_NUM_TYPE MANUAL_INVOICE_NUM_TYPE
, INVOICE_ORGANIZATION_TYPE INVOICE_ORGANIZATION_TYPE
, INVOICE_BATCH_SOURCE_ID INVOICE_BATCH_SOURCE_ID
, ACCUMULATION_PERIOD_TYPE ACCUMULATION_PERIOD_TYPE
, PA_PERIOD_TYPE PA_PERIOD_TYPE
, NEXT_AUTOMATIC_INVOICE_NUMBER NEXT_AUTOMATIC_INVOICE_NUMBER
, ORG_ID ORG_ID
, EXP_ORG_STRUCTURE_ID EXP_ORG_STRUCTURE_ID
, EXP_ORG_STRUCTURE_VERSION_ID EXP_ORG_STRUCTURE_VERSION_ID
, EXP_START_ORG_ID EXP_START_ORG_ID
, PROJ_ORG_STRUCTURE_ID PROJ_ORG_STRUCTURE_ID
, PROJ_ORG_STRUCTURE_VERSION_ID PROJ_ORG_STRUCTURE_VERSION_ID
, PROJ_START_ORG_ID PROJ_START_ORG_ID
, CENTRALIZED_INVOICING_FLAG CENTRALIZED_INVOICING_FLAG
, ALLOW_FOREIGN_CURR_TXN_FLAG ALLOW_FOREIGN_CURR_TXN_FLAG
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_RATE_DATE_CODE ACCT_RATE_DATE_CODE
, ALLOW_ACCT_USER_RATE_TYPE_FLAG ALLOW_ACCT_USER_RATE_TYPE_FLAG
, OUTPUT_TAX_USE_CUST_FLAG OUTPUT_TAX_USE_CUST_FLAG
, OUTPUT_TAX_USE_SITE_FLAG OUTPUT_TAX_USE_SITE_FLAG
, OUTPUT_TAX_USE_PROJECT_FLAG OUTPUT_TAX_USE_PROJECT_FLAG
, OUTPUT_TAX_USE_EXP_EV_FLAG OUTPUT_TAX_USE_EXP_EV_FLAG
, OUTPUT_TAX_USE_EXTN_FLAG OUTPUT_TAX_USE_EXTN_FLAG
, OUTPUT_TAX_USE_AR_PARAM_FLAG OUTPUT_TAX_USE_AR_PARAM_FLAG
, OUTPUT_TAX_HIER_CUST OUTPUT_TAX_HIER_CUST
, OUTPUT_TAX_HIER_SITE OUTPUT_TAX_HIER_SITE
, OUTPUT_TAX_HIER_PROJECT OUTPUT_TAX_HIER_PROJECT
, OUTPUT_TAX_HIER_EXP_EV OUTPUT_TAX_HIER_EXP_EV
, OUTPUT_TAX_HIER_EXTN OUTPUT_TAX_HIER_EXTN
, OUTPUT_TAX_HIER_AR_PARAM OUTPUT_TAX_HIER_AR_PARAM
, DEFAULT_RATE_TYPE DEFAULT_RATE_TYPE
, DEFAULT_RATE_DATE_CODE DEFAULT_RATE_DATE_CODE
, CC_PROCESS_IO_CODE CC_PROCESS_IO_CODE
, CC_DEFAULT_RATE_TYPE CC_DEFAULT_RATE_TYPE
, CC_DEFAULT_RATE_DATE_CODE CC_DEFAULT_RATE_DATE_CODE
, CC_ALLOW_IU_FLAG CC_ALLOW_IU_FLAG
, CC_PROCESS_IU_CODE CC_PROCESS_IU_CODE
, CC_IC_BILLING_PRVDR_FLAG CC_IC_BILLING_PRVDR_FLAG
, VENDOR_ID VENDOR_ID
, CC_MANUAL_INVOICE_NUM_TYPE CC_MANUAL_INVOICE_NUM_TYPE
, CC_MANUAL_INVOICE_NUM_CODE CC_MANUAL_INVOICE_NUM_CODE
, CC_NEXT_AUTOMATIC_INVOICE_NUM CC_NEXT_AUTOMATIC_INVOICE_NUM
, CC_IC_AR_BATCH_SOURCE_ID CC_IC_AR_BATCH_SOURCE_ID
, CC_PRVDR_CAC_COST_RECLASS_CODE CC_PRVDR_CAC_COST_RECLASS_CODE
, CC_PRVDR_OTH_COST_RECLASS_CODE CC_PRVDR_OTH_COST_RECLASS_CODE
, CC_IC_BILLING_RECVR_FLAG CC_IC_BILLING_RECVR_FLAG
, CUSTOMER_ID CUSTOMER_ID
, COMPETENCE_MATCH_WT COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT JOB_LEVEL_MATCH_WT
, MULTI_CURRENCY_BILLING_FLAG MULTI_CURRENCY_BILLING_FLAG
, SHARE_ACROSS_OU_BR_SCH_FLAG SHARE_ACROSS_OU_BR_SCH_FLAG
, ALLOW_FUNDING_ACROSS_OU_FLAG ALLOW_FUNDING_ACROSS_OU_FLAG
, PERIOD_SET_NAME PERIOD_SET_NAME
, SAME_PA_GL_PERIOD SAME_PA_GL_PERIOD
, ADV_ACTION_SET_ID ADV_ACTION_SET_ID
, RETN_ACCOUNTING_FLAG RETN_ACCOUNTING_FLAG
, FTE_DAY FTE_DAY
, FTE_WEEK FTE_WEEK
, INCLUDE_GAINS_LOSSES_FLAG INCLUDE_GAINS_LOSSES_FLAG
, ENABLE_MRC_FOR_FUND_FLAG ENABLE_MRC_FOR_FUND_FLAG
, REVAL_MRC_FUNDING_FLAG REVAL_MRC_FUNDING_FLAG
, ENABLE_MRC_FOR_FINPLAN_FLAG ENABLE_MRC_FOR_FINPLAN_FLAG
, FINPLAN_MRC_OPTION_CODE FINPLAN_MRC_OPTION_CODE
, RATE_DISCOUNT_REASON_FLAG RATE_DISCOUNT_REASON_FLAG
, BR_OVERRIDE_FLAG BR_OVERRIDE_FLAG
, BR_DISCOUNT_OVERRIDE_FLAG BR_DISCOUNT_OVERRIDE_FLAG
, CREDIT_MEMO_REASON_FLAG CREDIT_MEMO_REASON_FLAG
, CUST_ACC_REL_CODE CUST_ACC_REL_CODE
, SALES_CREDIT_TYPE_CODE SALES_CREDIT_TYPE_CODE
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, XFACE_CWK_LABOR_TO_GL_FLAG XFACE_CWK_LABOR_TO_GL_FLAG
, XFACE_CWK_TIMECARDS_FLAG XFACE_CWK_TIMECARDS_FLAG
, DEF_SUPPLIER_COST_CR_CCID DEF_SUPPLIER_COST_CR_CCID
, INVOICE_NZ_LINES INVOICE_NZ_LINES
, CREATE_ON_ACCOUNT_CM CREATE_ON_ACCOUNT_CM
, ALLOW_NEGATIVE_ACCRUAL ALLOW_NEGATIVE_ACCRUAL
FROM "PA"."PA_IMPLEMENTATIONS_ALL"