[Home] [Help] [Dependency Information]
Object Name: | PSP_REP_SSP_CHG1_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSP.PSP_REP_SSP_CHG1_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISTRIBUTION_LINE_ID | NUMBER | (10) | ||
PAYROLL_ID | NUMBER | (9) | Payroll identifier | |
TIME_PERIOD_ID | NUMBER | (15) | Time period identifier | |
PERSON_ID | NUMBER | (9) | Person identifier | |
ASSIGNMENT_ID | NUMBER | (9) | Assignment identifier | |
ELEMENT_TYPE_ID | NUMBER | (9) | Earnings element identifier | |
SUSPENSE_ORG_ACCOUNT_ID | NUMBER | (9) | Suspense organization account identifier | |
DISTRIBUTION_AMOUNT | NUMBER | Amount to be distributed | ||
SUSPENSE_REASON_CODE | VARCHAR2 | (50) | Reason for suspense charging instruction | |
ORGANIZATION_ID | NUMBER | (15) | Employee organization identifier | |
ACTUAL_PROJECT_ID | NUMBER | (15) | Project actually used for distribution | |
ACTUAL_EXP_ORG_ID | NUMBER | (15) | Expenditure organization actually used for distribution | |
ACTUAL_EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type actually used for distributing amount | |
ACTUAL_TASK_ID | NUMBER | (15) | Task actually used for distributing amount | |
ACTUAL_AWARD_ID | NUMBER | (15) | Award actually used for distributing amount | |
ACTUAL_GL_CCID | NUMBER | General Ledger account actually used for distributing amount | ||
DISTRIBUTION_DATE | DATE | Date when amount is distributed | ||
PROJECT_ID | NUMBER | Project originally specified for distributing amount | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | Expenditure organization originally specified for distributing amount | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure type originally specified for distributing amount | |
TASK_ID | NUMBER | Task originally specified for distributing amount | ||
AWARD_ID | NUMBER | Award originally specified for distributing amount | ||
GL_CODE_COMBINATION_ID | NUMBER | General Ledger account originally specified for distributing amount | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group Identifier | |
SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_LINE_ID
, PAYROLL_ID
, TIME_PERIOD_ID
, PERSON_ID
, ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, SUSPENSE_ORG_ACCOUNT_ID
, DISTRIBUTION_AMOUNT
, SUSPENSE_REASON_CODE
, ORGANIZATION_ID
, ACTUAL_PROJECT_ID
, ACTUAL_EXP_ORG_ID
, ACTUAL_EXPENDITURE_TYPE
, ACTUAL_TASK_ID
, ACTUAL_AWARD_ID
, ACTUAL_GL_CCID
, DISTRIBUTION_DATE
, PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, TASK_ID
, AWARD_ID
, GL_CODE_COMBINATION_ID
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, CURRENCY_CODE
FROM APPS.PSP_REP_SSP_CHG1_V;
APPS.PSP_REP_SSP_CHG1_V is not referenced by any database object
|
|
|