[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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| ORGANIZATION_STRUCTURE_ID | NUMBER | (15) | Yes | |
| ORG_STRUCTURE_VERSION_ID | NUMBER | (15) | Yes | |
| START_ORGANIZATION_ID | NUMBER | (15) | Yes | |
| USER_DEFINED_PROJECT_NUM_CODE | VARCHAR2 | (25) | Yes | |
| MANUAL_PROJECT_NUM_TYPE | VARCHAR2 | (25) | Yes | |
| PROJECT_ORGANIZATION_TYPE | VARCHAR2 | (30) | Yes | |
| EXP_CYCLE_START_DAY_CODE | VARCHAR2 | (30) | Yes | |
| OVERTIME_CALC_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| INTERFACE_LABOR_TO_GL_FLAG | VARCHAR2 | (1) | Yes | |
| INTERFACE_USAGE_TO_GL_FLAG | VARCHAR2 | (1) | Yes | |
| INTERFACE_REVENUE_TO_GL_FLAG | VARCHAR2 | (1) | ||
| BILLING_CYCLE | NUMBER | (15) | ||
| BILLING_OFFSET | NUMBER | (15) | ||
| USER_DEFINED_INVOICE_NUM_CODE | VARCHAR2 | (25) | ||
| MANUAL_INVOICE_NUM_TYPE | VARCHAR2 | (25) | ||
| INVOICE_ORGANIZATION_TYPE | VARCHAR2 | (30) | ||
| INVOICE_BATCH_SOURCE_ID | NUMBER | (15) | ||
| ACCUMULATION_PERIOD_TYPE | VARCHAR2 | (30) | Yes | |
| PA_PERIOD_TYPE | VARCHAR2 | (15) | Yes | |
| NEXT_AUTOMATIC_INVOICE_NUMBER | NUMBER | |||
| ORG_ID | NUMBER | (15) | ||
| EXP_ORG_STRUCTURE_ID | NUMBER | Yes | ||
| EXP_ORG_STRUCTURE_VERSION_ID | NUMBER | Yes | ||
| EXP_START_ORG_ID | NUMBER | Yes | ||
| PROJ_ORG_STRUCTURE_ID | NUMBER | Yes | ||
| PROJ_ORG_STRUCTURE_VERSION_ID | NUMBER | Yes | ||
| PROJ_START_ORG_ID | NUMBER | Yes | ||
| CENTRALIZED_INVOICING_FLAG | VARCHAR2 | (1) | Yes | |
| 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 the customer will be used for customer invoice | |
| OUTPUT_TAX_USE_SITE_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for the customers business purpose for customer invoice | |
| OUTPUT_TAX_USE_PROJECT_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for the project will be used | |
| OUTPUT_TAX_USE_EXP_EV_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined for the 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 extension will be used for customer invoices | |
| OUTPUT_TAX_USE_AR_PARAM_FLAG | VARCHAR2 | (1) | Indicates whether tax rate defined in AR 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 extension returned tax code for customer invoices | ||
| OUTPUT_TAX_HIER_AR_PARAM | NUMBER | Indicates tax code defaulting hierarchy associated with AR system options for customer invoices | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | (30) | Default value for rate type | |
| DEFAULT_RATE_DATE_CODE | VARCHAR2 | (1) | Rate date code. Will be used to derive rate date | |
| CC_PROCESS_IO_CODE | VARCHAR2 | (1) | ||
| CC_DEFAULT_RATE_TYPE | VARCHAR2 | (30) | ||
| CC_DEFAULT_RATE_DATE_CODE | VARCHAR2 | (1) | ||
| CC_ALLOW_IU_FLAG | VARCHAR2 | (1) | ||
| CC_PROCESS_IU_CODE | VARCHAR2 | (1) | ||
| CC_IC_BILLING_PRVDR_FLAG | VARCHAR2 | (1) | ||
| VENDOR_ID | NUMBER | |||
| CC_MANUAL_INVOICE_NUM_TYPE | VARCHAR2 | (30) | ||
| CC_MANUAL_INVOICE_NUM_CODE | VARCHAR2 | (30) | ||
| CC_NEXT_AUTOMATIC_INVOICE_NUM | NUMBER | |||
| CC_IC_AR_BATCH_SOURCE_ID | NUMBER | (20) | ||
| CC_PRVDR_CAC_COST_RECLASS_CODE | VARCHAR2 | (1) | ||
| CC_PRVDR_OTH_COST_RECLASS_CODE | VARCHAR2 | (1) | ||
| CC_IC_BILLING_RECVR_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_ID | NUMBER | |||
| 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) | Allows users to enter agreements, bill rates, and events in any currency | |
| SHARE_ACROSS_OU_BR_SCH_FLAG | VARCHAR2 | (1) | Allows users to use the bill rate schedules owned by other operating units | |
| ALLOW_FUNDING_ACROSS_OU_FLAG | VARCHAR2 | (1) | Allows users to fund projects belonging to other operating units from agreements | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | ||
| SAME_PA_GL_PERIOD | VARCHAR2 | (1) | ||
| ADV_ACTION_SET_ID | NUMBER | (15) | ||
| RETN_ACCOUNTING_FLAG | VARCHAR2 | (1) | ||
| FTE_DAY | NUMBER | |||
| FTE_WEEK | NUMBER | |||
| INCLUDE_GAINS_LOSSES_FLAG | VARCHAR2 | (1) | This column indicates whether realized gains and losses shold be included in project revenue or not. | |
| ENABLE_MRC_FOR_FUND_FLAG | VARCHAR2 | (1) | This flag allows users to enable MRC for funding and budgets 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) | Controls the access to Rate and Markup % override fields. | |
| BR_DISCOUNT_OVERRIDE_FLAG | VARCHAR2 | (1) | Controls the access to Bill Rate Discount override field. | |
| CREDIT_MEMO_REASON_FLAG | VARCHAR2 | (1) | Credit Memo Reason Flag | |
| CUST_ACC_REL_CODE | VARCHAR2 | (30) | Customer Account Relationship Code | |
| 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) | Interface Contingent Worker Labor Costs | |
| XFACE_CWK_TIMECARDS_FLAG | VARCHAR2 | (1) | Import Contingent Worker Timecards with Purchase Order Integration | |
| DEF_SUPPLIER_COST_CR_CCID | NUMBER | Default Supplier Cost Credit Account |
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
FROM PA.PA_IMPLEMENTATIONS_ALL;
PA.PA_IMPLEMENTATIONS_ALL does not reference any database object
PA.PA_IMPLEMENTATIONS_ALL is referenced by following:
APPS
PA_IMPLEMENTATIONS
PA_IMPLEMENTATIONS_ALL
PA_IMPLEMENTATIONS_MRC_V
PJI_TIME_PA_RPT_STR_MV
|
|
|
|