[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_IMPLEMENTATIONS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_IMPLEMENTATIONS_ALL
|
| Subobject Name: | |
| Status: | VALID |
PA_IMPLEMENTATIONS_ALL stores the parameters and defaults that
define the configuration of your Oracle Projects installation.
.
If you have a multi-organization installation, you define one row for
each operating unit.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 3 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_IMPLEMENTATIONS_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 ORG_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | The identifier of the ledger used by Oracle Projects. |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | The identifier of the Personnel business group used |
| ORGANIZATION_STRUCTURE_ID | NUMBER | (15) | Yes | Identifier of the default organization hierarchy used for reporting |
| ORG_STRUCTURE_VERSION_ID | NUMBER | (15) | Yes | Identifier of the default organization hierarchy version used for reporting |
| START_ORGANIZATION_ID | NUMBER | (15) | Yes | Identifier of the highest organization used in default reporting organization hierarchy version |
| USER_DEFINED_PROJECT_NUM_CODE | VARCHAR2 | (25) | Yes | The method by which project numbers are entered or generated |
| MANUAL_PROJECT_NUM_TYPE | VARCHAR2 | (25) | Yes | The type of project numbers allowed |
| PROJECT_ORGANIZATION_TYPE | VARCHAR2 | (30) | Yes | The organization type that determines which organizations can be selected as project and task organizations |
| EXP_CYCLE_START_DAY_CODE | VARCHAR2 | (30) | Yes | The code for the week day on which the expenditure week period begins. This value determines the valid expenditure ending dates for expenditure groups, expenditures, and labor cost rates |
| OVERTIME_CALC_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether the Overtime Calculation program is enabled. If the program is enabled, Distribute Labor Costs will run the Overtime Calculation program |
| INTERFACE_LABOR_TO_GL_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether to transfer labor costs to GL. If the flag is set to 'N', the costs are accumulated but not transferred to GL by the Transfer Labor Costs to GL process |
| INTERFACE_USAGE_TO_GL_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether to transfer usage costs to GL. If the flag is set to 'N', usage costs are accumulated but not transferred to GL by the Transfer Usage Costs to GL process |
| INTERFACE_REVENUE_TO_GL_FLAG | VARCHAR2 | (1) | Flag that indicates whether to transfer revenue to GL. If the flag is set to 'N', the revenue is accumulated but not transferred to GL by the Transfer Revenue to GL process. This column is blank for Project Costing installations | |
| BILLING_CYCLE | NUMBER | (15) | Obsolete | |
| BILLING_OFFSET | NUMBER | (15) | Obsolete | |
| USER_DEFINED_INVOICE_NUM_CODE | VARCHAR2 | (25) | The method by which AR invoice numbers are entered or generated upon release of draft invoices. This column is blank for Project Costing installations | |
| MANUAL_INVOICE_NUM_TYPE | VARCHAR2 | (25) | The type of AR invoice numbers allowed. This column is blank for Project Costing installations | |
| INVOICE_ORGANIZATION_TYPE | VARCHAR2 | (30) | The organization type that determines the organization level where invoice collection processing is done. Invoices in Oracle Receivables may be classified by invoice types of an invoice organization if the feature is fully implemented | |
| INVOICE_BATCH_SOURCE_ID | NUMBER | (15) | The identifier of the Oracle Receivables batch source to use when transferring invoices to Receivables. This column is blank for Project Costing installations | |
| ACCUMULATION_PERIOD_TYPE | VARCHAR2 | (30) | Yes | The period type that determines whether amounts are accumulated by PA period or GL period |
| PA_PERIOD_TYPE | VARCHAR2 | (15) | Yes | The GL period type that identifies the PA periods associated with the ledger in the GL calendar. |
| NEXT_AUTOMATIC_INVOICE_NUMBER | NUMBER | Next automatic invoice number if automatic invoice numbering is used. Blank for project costing installations. | ||
| ORG_ID | NUMBER | (15) | Yes | Operating unit identifier for multi-organization installations |
| EXP_ORG_STRUCTURE_ID | NUMBER | Yes | Identifier of the organization hierarchy used for expenditure organizations | |
| EXP_ORG_STRUCTURE_VERSION_ID | NUMBER | Yes | Identifier of the organization hierarchy version used for expenditure organizations | |
| EXP_START_ORG_ID | NUMBER | Yes | Identifier of the highest organization used in expenditure organization hierarchy version | |
| PROJ_ORG_STRUCTURE_ID | NUMBER | Yes | Identifier of the organization hierarchy used for project organizations | |
| PROJ_ORG_STRUCTURE_VERSION_ID | NUMBER | Yes | Identifier of the organization hierarchy version used for project organizations | |
| PROJ_START_ORG_ID | NUMBER | Yes | Identifier of the highest organization used in project organization hierarchy version | |
| CENTRALIZED_INVOICING_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates centralized or decentralized invoices |
| ALLOW_FOREIGN_CURR_TXN_FLAG | VARCHAR2 | (1) | Flag to include whether foreign currency transactions allowed in this operating unit or not | |
| ACCT_RATE_TYPE | VARCHAR2 | (30) | Accounting Currency Rate Type (eg Spot, Corporate) This value can be overridden at ANY project level This will be the default value for Invoice acct_rate_date on pa_expenditures (for Expense Reports) which can be overriden | |
| ACCT_RATE_DATE_CODE | VARCHAR2 | (1) | Indicates the code used to derive account rate dates | |
| ALLOW_ACCT_USER_RATE_TYPE_FLAG | VARCHAR2 | (1) | Can user enter a rate type (USER) for a accounting currency conversion? Value is required allow foreign currency txt flag = (Y) | |
| OUTPUT_TAX_USE_CUST_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for Customer will be used for Customer Invoices | |
| OUTPUT_TAX_USE_SITE_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for Customer business purpose will be used for Customer Invoices | |
| OUTPUT_TAX_USE_PROJECT_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for Project will be used for Customer Invoices | |
| OUTPUT_TAX_USE_EXP_EV_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for Expenditure type or Event Type will be used for Customer Invoices | |
| OUTPUT_TAX_USE_EXTN_FLAG | VARCHAR2 | (1) | Indicates whether tax rate returned by client extention will be used for Customer Invoices | |
| OUTPUT_TAX_USE_AR_PARAM_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined in Oracle Receivable system options will be used for Customer Invoices | |
| OUTPUT_TAX_HIER_CUST | NUMBER | Indicates tax code defaulting hierarchy associated with customer level tax code for Customer Invoices. | ||
| OUTPUT_TAX_HIER_SITE | NUMBER | Indicates tax code defaulting hierarchy associated with customer site level tax code for Customer Invoices. | ||
| OUTPUT_TAX_HIER_PROJECT | NUMBER | Indicates tax code defaulting hierarchy associated with project level tax code for Customer Invoices. | ||
| OUTPUT_TAX_HIER_EXP_EV | NUMBER | Indicates tax code defaulting hierarchy associated with expenditure type/event type level tax code for Customer Invoices. | ||
| OUTPUT_TAX_HIER_EXTN | NUMBER | Indicates tax code defaulting hierarchy associated with using client extention returned tax code for Customer Invoices. | ||
| OUTPUT_TAX_HIER_AR_PARAM | NUMBER | Indicates tax code defaulting hierarchy associated with the Oracle Receivables system options for Customer Invoices. | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | (30) | Default value for rate type | |
| DEFAULT_RATE_DATE_CODE | VARCHAR2 | (1) | Indicates the code used to derive default rate dates. | |
| CC_PROCESS_IO_CODE | VARCHAR2 | (1) | Indicates whether to perform cross charge processing for intra-operating unit (IO) transactions, which are within the same operating unit but not the same provider and receiver organization. | |
| CC_DEFAULT_RATE_TYPE | VARCHAR2 | (30) | Default rate type to be used when converting the transfer price from the transaction currency to the functional currency of the provider operating unit. | |
| CC_DEFAULT_RATE_DATE_CODE | VARCHAR2 | (1) | Default rate date code to be used when converting the transfer price from the transaction currency to the functional currency. | |
| CC_ALLOW_IU_FLAG | VARCHAR2 | (1) | Indicates if the operating unit may incur inter-operating unit (IU) cross charge within the legal entity | |
| CC_PROCESS_IU_CODE | VARCHAR2 | (1) | Indicates if the operating unit may incur inter operating (IU) cross charge within the legal entity | |
| CC_IC_BILLING_PRVDR_FLAG | VARCHAR2 | (1) | Indicates if the operating unit may incur cross charge (provide to another operating unit) that requires processing by intercompany billing | |
| VENDOR_ID | NUMBER | Supplier identifier for the operating unit to be used for intercompany AP invoice. This is required if cc_ic_billing_prvdr_flag = Y | ||
| CC_MANUAL_INVOICE_NUM_TYPE | VARCHAR2 | (30) | Numbering type of intercompany invoices. This is required if cc_ic_billing_prvdr_flag = Y. | |
| CC_MANUAL_INVOICE_NUM_CODE | VARCHAR2 | (30) | Type of numbering to be used for manually numbered intercompany invoices. Lookup Type: MANUAL INVOICE NUMBER | |
| CC_NEXT_AUTOMATIC_INVOICE_NUM | NUMBER | Next automatic invoice sequence number if automatic numbering is used for intercompany invoices | ||
| CC_IC_AR_BATCH_SOURCE_ID | NUMBER | (20) | AR batch source used for intercompany invoices. This is required if cc_ic_billing_prvdr_flag =' Y' | |
| CC_PRVDR_CAC_COST_RECLASS_CODE | VARCHAR2 | (1) | Indicates if cost for cross-charged transactions processed by intercompany billing on cost accrual projects needs to be reclassified into different accounts. . This is required if cc_ic_billing_prvdr_flag = Y | |
| CC_PRVDR_OTH_COST_RECLASS_CODE | VARCHAR2 | (1) | Indicates if cost for cross-charged transactions processed by intercompany billing on non-cost accrual projects needs to be reclassified into different accounts. . This is required if cc_ic_billing_prvdr_flag = Y | |
| CC_IC_BILLING_RECVR_FLAG | VARCHAR2 | (1) | Indicates if the operating unit may accept cross charge transactions (be a receiver) that requires processing by intercompany billing. | |
| CUSTOMER_ID | NUMBER | Customer identifier for the operating unit to be used for intercompany AR invoice. This is required if cc_ic_billing_recvr_flag = Y | ||
| COMPETENCE_MATCH_WT | NUMBER | Weighting value for competence match used to calculate Score | ||
| AVAILABILITY_MATCH_WT | NUMBER | Weighting value for availability match used to calculate Score | ||
| JOB_LEVEL_MATCH_WT | NUMBER | Weighting value for job level match used to calculate score | ||
| MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | (1) | Flag indicating if multi-currency billing is allowed for this operating unit. | |
| SHARE_ACROSS_OU_BR_SCH_FLAG | VARCHAR2 | (1) | Flag indicating if bill rate schedules across operating units are allowed for this operating unit. | |
| ALLOW_FUNDING_ACROSS_OU_FLAG | VARCHAR2 | (1) | Flag indicatesFlag indicating if funding projects across operating unit operating units projects is allowed for this operating unit operating unit. | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Calendar name.. | |
| SAME_PA_GL_PERIOD | VARCHAR2 | (1) | Defines whether users will use a comon period definition for PA GL periods. | |
| ADV_ACTION_SET_ID | NUMBER | (15) | Indicates the default advertisement action set of the Operating Unit. | |
| RETN_ACCOUNTING_FLAG | VARCHAR2 | (1) | Indicates the retention accounting is enabled for the operating Unit. | |
| FTE_DAY | NUMBER | Full Time Equivalent hours per day | ||
| FTE_WEEK | NUMBER | Full Time Equivalent hours per week. | ||
| INCLUDE_GAINS_LOSSES_FLAG | VARCHAR2 | (1) | This column indicates whether gains and losses to be included in project revenue or not. Valid values are Y or N | |
| ENABLE_MRC_FOR_FUND_FLAG | VARCHAR2 | (1) | This flag allows users to enable MRC for funding provided the MRC for projects is implemented | |
| REVAL_MRC_FUNDING_FLAG | VARCHAR2 | (1) | This flag indicates where the funding revaluation process has to revaluate the reporting currency funding. | |
| ENABLE_MRC_FOR_FINPLAN_FLAG | VARCHAR2 | (1) | Indicates whether the financial planning amounts are generated in each reporting currency. | |
| FINPLAN_MRC_OPTION_CODE | VARCHAR2 | (1) | Indicates whether financial planning amounts are generated in each reporting currency for all working versions or only for baselined versions. | |
| RATE_DISCOUNT_REASON_FLAG | VARCHAR2 | (1) | Determine whether Discount Reason is required with entry of override information and also if reason is required when entering discount % in billing schedules. | |
| BR_OVERRIDE_FLAG | VARCHAR2 | (1) | Flag to indicate if bill rate override is allowed or not. | |
| BR_DISCOUNT_OVERRIDE_FLAG | VARCHAR2 | (1) | Flag to indicate if discount override is allowed or not. | |
| CREDIT_MEMO_REASON_FLAG | VARCHAR2 | (1) | The identifier of the Credit Memo Reason | |
| CUST_ACC_REL_CODE | VARCHAR2 | (30) | The identifier of the Customer Account Relationship Code implemented for project Implementation | |
| SALES_CREDIT_TYPE_CODE | VARCHAR2 | (240) | Name of Sales Credit Type | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Default Corporate Asset Book identifier. | |
| XFACE_CWK_LABOR_TO_GL_FLAG | VARCHAR2 | (1) | Flag that indicates whether to transfer contingent worker labor costs to GL. If the flag is set to 'N', the costs are accumulated but not transferred to GL by the Transfer Labor Costs to GL process | |
| XFACE_CWK_TIMECARDS_FLAG | VARCHAR2 | (1) | Flag that indicates whether contingent workers are required to enter timecards. If the flag is set to `N`, contingent worker labor costs are interfaced to PA as supplier cost | |
| DEF_SUPPLIER_COST_CR_CCID | NUMBER | Default Supplier Cost Credit Account | ||
| INVOICE_NZ_LINES | VARCHAR2 | (1) | Flag indicating whether to create invoice lines for net zero amounts. | |
| CREATE_ON_ACCOUNT_CM | VARCHAR2 | (1) | Flag indicating creation of On Account Credit Memo. | |
| ALLOW_NEGATIVE_ACCRUAL | VARCHAR2 | (1) | Flag Indicating Negative Expenditure Accruals Allowed. |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_STRUCTURE_ID
, ORG_STRUCTURE_VERSION_ID
, START_ORGANIZATION_ID
, USER_DEFINED_PROJECT_NUM_CODE
, MANUAL_PROJECT_NUM_TYPE
, PROJECT_ORGANIZATION_TYPE
, EXP_CYCLE_START_DAY_CODE
, OVERTIME_CALC_ENABLED_FLAG
, INTERFACE_LABOR_TO_GL_FLAG
, INTERFACE_USAGE_TO_GL_FLAG
, INTERFACE_REVENUE_TO_GL_FLAG
, BILLING_CYCLE
, BILLING_OFFSET
, USER_DEFINED_INVOICE_NUM_CODE
, MANUAL_INVOICE_NUM_TYPE
, INVOICE_ORGANIZATION_TYPE
, INVOICE_BATCH_SOURCE_ID
, ACCUMULATION_PERIOD_TYPE
, PA_PERIOD_TYPE
, NEXT_AUTOMATIC_INVOICE_NUMBER
, ORG_ID
, EXP_ORG_STRUCTURE_ID
, EXP_ORG_STRUCTURE_VERSION_ID
, EXP_START_ORG_ID
, PROJ_ORG_STRUCTURE_ID
, PROJ_ORG_STRUCTURE_VERSION_ID
, PROJ_START_ORG_ID
, CENTRALIZED_INVOICING_FLAG
, ALLOW_FOREIGN_CURR_TXN_FLAG
, ACCT_RATE_TYPE
, ACCT_RATE_DATE_CODE
, ALLOW_ACCT_USER_RATE_TYPE_FLAG
, OUTPUT_TAX_USE_CUST_FLAG
, OUTPUT_TAX_USE_SITE_FLAG
, OUTPUT_TAX_USE_PROJECT_FLAG
, OUTPUT_TAX_USE_EXP_EV_FLAG
, OUTPUT_TAX_USE_EXTN_FLAG
, OUTPUT_TAX_USE_AR_PARAM_FLAG
, OUTPUT_TAX_HIER_CUST
, OUTPUT_TAX_HIER_SITE
, OUTPUT_TAX_HIER_PROJECT
, OUTPUT_TAX_HIER_EXP_EV
, OUTPUT_TAX_HIER_EXTN
, OUTPUT_TAX_HIER_AR_PARAM
, DEFAULT_RATE_TYPE
, DEFAULT_RATE_DATE_CODE
, CC_PROCESS_IO_CODE
, CC_DEFAULT_RATE_TYPE
, CC_DEFAULT_RATE_DATE_CODE
, CC_ALLOW_IU_FLAG
, CC_PROCESS_IU_CODE
, CC_IC_BILLING_PRVDR_FLAG
, VENDOR_ID
, CC_MANUAL_INVOICE_NUM_TYPE
, CC_MANUAL_INVOICE_NUM_CODE
, CC_NEXT_AUTOMATIC_INVOICE_NUM
, CC_IC_AR_BATCH_SOURCE_ID
, CC_PRVDR_CAC_COST_RECLASS_CODE
, CC_PRVDR_OTH_COST_RECLASS_CODE
, CC_IC_BILLING_RECVR_FLAG
, CUSTOMER_ID
, COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT
, MULTI_CURRENCY_BILLING_FLAG
, SHARE_ACROSS_OU_BR_SCH_FLAG
, ALLOW_FUNDING_ACROSS_OU_FLAG
, PERIOD_SET_NAME
, SAME_PA_GL_PERIOD
, ADV_ACTION_SET_ID
, RETN_ACCOUNTING_FLAG
, FTE_DAY
, FTE_WEEK
, INCLUDE_GAINS_LOSSES_FLAG
, ENABLE_MRC_FOR_FUND_FLAG
, REVAL_MRC_FUNDING_FLAG
, ENABLE_MRC_FOR_FINPLAN_FLAG
, FINPLAN_MRC_OPTION_CODE
, RATE_DISCOUNT_REASON_FLAG
, BR_OVERRIDE_FLAG
, BR_DISCOUNT_OVERRIDE_FLAG
, CREDIT_MEMO_REASON_FLAG
, CUST_ACC_REL_CODE
, SALES_CREDIT_TYPE_CODE
, BOOK_TYPE_CODE
, XFACE_CWK_LABOR_TO_GL_FLAG
, XFACE_CWK_TIMECARDS_FLAG
, DEF_SUPPLIER_COST_CR_CCID
, INVOICE_NZ_LINES
, CREATE_ON_ACCOUNT_CM
, ALLOW_NEGATIVE_ACCRUAL
FROM PA.PA_IMPLEMENTATIONS_ALL;
PA.PA_IMPLEMENTATIONS_ALL does not reference any database object
PA.PA_IMPLEMENTATIONS_ALL is referenced by following:
PA
PA_IMPLEMENTATIONS_ALL#
|
|
|
|