POR_REQ_DISTRIBUTIONS_ALL
POR_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. You need one row for each requisition distribution you create. Each row includes the Accounting Flexfield ID and requisition line quantity. . POR_REQ_DISTRIBUTIONS_ALL is one of three tables storing your requisition information. This table corresponds to the requisition Distributions window, accessible through the Requisitions window. . .
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
POR_REQ_DISTRIBUTIONS_PK |
DISTRIBUTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
DISTRIBUTION_ID | NUMBER | 18 | Yes | Requisition distribution unique identifier | ||
REQUISITION_LINE_ID | NUMBER | 18 | Yes | Requisition line unique identifier | ||
PRIMARY_LEDGER_ID | NUMBER | 18 | Primary Ledger unique identifier for the charge account | |||
CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier for the General Ledger charge account | |||
ACCRUAL_ACCOUNT_ID | NUMBER | 18 | *OBSOLETE*Unique identifier for the General Ledger accrual account*OBSOLETE* | |||
VARIANCE_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the General Ledger variance account | |||
ACCOUNT_USER_OVERRIDE_FLAG | VARCHAR2 | 1 | Determine if the account is overriden by user | |||
DISTRIBUTION_QUANTITY | NUMBER | Quantity for the distribution | ||||
DISTRIBUTION_NUMBER | NUMBER | Yes | Distribution number | |||
PERCENT | NUMBER | Allocation split value | ||||
REQ_BU_ID | NUMBER | 18 | Yes | Business unit unique identifier | ||
RECOVERABLE_TAX | NUMBER | Recoverable tax amount | ||||
NONRECOVERABLE_TAX | NUMBER | Nonrecoverable tax amount | ||||
RECOVERABLE_CURRENCY_TAX | NUMBER | Foreign currency recoverable tax on the requisition distribution | ||||
NONRECOVERABLE_CURRENCY_TAX | NUMBER | Foreign currency non recoverable tax on the requisition distribution | ||||
DISTRIBUTION_AMOUNT | NUMBER | Amount on the req line | ||||
DISTRIBUTION_CURRENCY_AMOUNT | NUMBER | Foreign Currency Amount on the requisition distribution | ||||
FUNDS_STATUS | VARCHAR2 | 30 | This attribute captures the budgetary control status for the requisition distribution. | |||
BUDGET_DATE | DATE | This attribute captures the date to be used for reserving the distribution. | ||||
PJC_CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to biuld the transaction descriptive flexfield for project-related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_EXPENDITURE_ITEM_DATE | DATE | Date on which project-related transaction is incurred | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
PJC_ORGANIZATION_ID | NUMBER | 18 | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is available to be billed to customers | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_WORK_TYPE_ID | NUMBER | 18 | Identifier for project-related classification of the work performed | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_CONTRACT_ID | NUMBER | 18 | Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | |||
PJC_CONTRACT_LINE_ID | NUMBER | 18 | Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | |||
PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Specified the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. | |||
PJC_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for future project-related functionality | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
PJC_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable project information | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Distributions (POR_REQ_DISTRIBUTIONS) | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
POR_REQ_DISTRIBUTIONS_ALL | por_requisition_lines_all | REQUISITION_LINE_ID |
rcv_transactions | por_req_distributions_all | REQ_DISTRIBUTION_ID |
rcv_transactions_interface | por_req_distributions_all | REQ_DISTRIBUTION_ID |
por_req_bcea_data | por_req_distributions_all | DISTRIBUTION_ID |
rcv_shipment_lines | por_req_distributions_all | REQ_DISTRIBUTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
POR_REQ_DISTRIBUTIONS_N1 | Non Unique | Default | REQUISITION_LINE_ID |
POR_REQ_DISTRIBUTIONS_N2 | Non Unique | Default | LAST_UPDATE_DATE |
POR_REQ_DISTRIBUTIONS_N3 | Non Unique | Default | PJC_PROJECT_ID, PJC_TASK_ID |
POR_REQ_DISTRIBUTIONS_N4 | Non Unique | Default | DISTRIBUTION_NUMBER |
POR_REQ_DISTRIBUTIONS_N5 | Non Unique | Default | REQ_BU_ID |
POR_REQ_DISTRIBUTIONS_U1 | Unique | Default | DISTRIBUTION_ID |