PJC_PRJ_ASSET_LNS_ALL
PA_PROJECT_ASSET_LINES_ALL stores summarized project CIP cost lines. The level of summarization in this table is controlled by the CIP Grouping Method for the project type, as well as by the level (task or project) of asset assignments.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_PRJ_ASSET_LNS_ALL_PK |
PROJECT_ASSET_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJECT_ASSET_LINE_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the asset line | |
| LINE_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Distribution type.Validated against AP_LOOKUP_CODES.Lookup type is INVOICE DISTRIBUTION TYPE. | ||
| DESCRIPTION | VARCHAR2 | 255 | Description of the asset line, derived from the CIP grouping method | ||
| PROJECT_ASSET_ID | NUMBER | 18 | Yes | The identifier of the asset assigned to the line; value is 0 on unassigned lines | |
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project to which the CIP cost was charged | |
| TASK_ID | NUMBER | 18 | The identifier of the task against which the CIP cost is charged | ||
| CIP_CCID | NUMBER | 18 | The identifier of the GL account to which CIP cost is charged | ||
| ASSET_COST_CCID | NUMBER | 18 | Not currently used | ||
| ORIGINAL_ASSET_COST | NUMBER | The cost amount of the line at the time the line was originally created | |||
| CURRENT_ASSET_COST | NUMBER | The line's current cost amount; split lines have a current cost <> original cost | |||
| PROJECT_ASSET_LINE_DETAIL_ID | NUMBER | 18 | Yes | Identifier of the asset line details linking this line to cost distribution lines | |
| GL_DATE | DATE | Not currently used | |||
| TRANSFER_STATUS_CODE | VARCHAR2 | 1 | Yes | Status of the asset line as the cost information is transferred to Oracle Assets | |
| TRANSFER_REJECTION_REASON | VARCHAR2 | 30 | The reason why the line was rejected by the Interface Assets program | ||
| AMORTIZE_FLAG | VARCHAR2 | 1 | The amortize flag of the related asset at the time this line was interfaced | ||
| NEW_MASTER_FLAG | VARCHAR2 | 1 | Not currently used | ||
| ASSET_CATEGORY_ID | NUMBER | 18 | Asset category derived from inventory item on lines with supplier invoice cost | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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_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. | ||
| REV_PROJ_ASSET_LINE_ID | NUMBER | 18 | The id of the asset line which is reversed by this line. | ||
| REV_FROM_PROJ_ASSET_LINE_ID | NUMBER | 18 | Not currently used | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| INVOICE_NUMBER | VARCHAR2 | 50 | Invoice Number from AP | ||
| VENDOR_NUMBER | VARCHAR2 | 30 | Vendor Number entered by the user from purchasing through AP | ||
| PO_VENDOR_ID | NUMBER | 18 | Vendor ID from purchasing throup AP | ||
| PO_NUMBER | VARCHAR2 | 50 | Purchase Order Number entered by the user from purchasing through AP | ||
| INVOICE_DATE | DATE | Invoice Date | |||
| INVOICE_CREATED_BY | VARCHAR2 | 64 | User ID of the person who created the invoice | ||
| INVOICE_UPDATED_BY | VARCHAR2 | 64 | User ID of the person who updated the invoice | ||
| INVOICE_ID | NUMBER | 18 | Invoice Identification Number in AP | ||
| PAYABLES_BATCH_NAME | VARCHAR2 | 50 | AP batch name of invoices | ||
| AP_DISTRIBUTION_LINE_NUMBER | NUMBER | 18 | Distribution Line Number from AP | ||
| ORIGINAL_ASSET_ID | NUMBER | 18 | Asset id before calling client extension | ||
| CAPITAL_EVENT_ID | NUMBER | 18 | Yes | Capital Event Identifier | |
| FA_PERIOD_NAME | VARCHAR2 | 15 | Asset book depreciation calendar period name to which the asset cost was posted. | ||
| LINE_TYPE | VARCHAR2 | 30 | Yes | Asset Line Classification. Available values are C = Capital and R = Retirement. | |
| RET_ADJUSTMENT_TXN_ID | NUMBER | 18 | Transaction Identifier of the Group Retirement Adjustment Transaction. | ||
| RETIREMENT_COST_TYPE | VARCHAR2 | 30 | Retirement Cost Classification. Available values are COR = Cost of Removal and POS = Proceeds of Sale. | ||
| INVOICE_LINE_NUMBER | NUMBER | 38 | Invoice line number | ||
| INVOICE_DISTRIBUTION_ID | NUMBER | 38 | Distribution Identifier of invoice | ||
| 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. | |
| UNASSIGNED_LINE_FLAG | VARCHAR2 | 1 | Indicates that the asset line was generated as Unassigned. | ||
| CREATION_SOURCE | VARCHAR2 | 30 | The source that created the record, for example, FBDI, ADFdi, and so on. | ||
| UPDATION_SOURCE | VARCHAR2 | 30 | The source that updated the record, for example, FBDI, ADFdi, and so on. | ||
| CUSTOM_GROUPING_DETAILS | VARCHAR2 | 4000 | Capture process configurator ID as well as the source codes that were used for asset line grouping | ||
| FA_PERIOD_NAME_SOURCE | VARCHAR2 | 30 | The source, such as FBDI, REST, and so on, that was used to update the FA_PERIOD_NAME of a PPM asset line. If the Tieback process was used to tie the asset line details back from FA to Projects, this column should be blank. | ||
| TRANSFER_STATUS_CODE_SOURCE | VARCHAR2 | 30 | The source, such as FBDI, REST, and so on, that was used to update the TRANSFER_STATUS_CODE of a PPM asset line. If the Tieback process was used to tie the asset line details back from FA to Projects, this column should be blank. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_PRJ_ASSET_LNS_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_PRJ_ASSET_LNS_ALL | fa_categories_b | ASSET_CATEGORY_ID |
| PJC_PRJ_ASSET_LNS_ALL | pjc_prj_asset_lns_all | REV_PROJ_ASSET_LINE_ID |
| fa_adj_src_lines_t | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| fa_asset_invoices | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| pjc_prj_asset_ln_dets | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_DETAIL_ID |
| pjc_prj_asset_lns_all | pjc_prj_asset_lns_all | REV_PROJ_ASSET_LINE_ID |
| pjc_mc_prj_ast_lines_all | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| fa_deleted_mass_additions | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| fa_mc_asset_invoices | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
| fa_mass_additions | pjc_prj_asset_lns_all | PROJECT_ASSET_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_PRJ_ASSET_LNS_ALL_N1 | Non Unique | Default | PROJECT_ASSET_ID |
| PJC_PRJ_ASSET_LNS_ALL_N2 | Non Unique | Default | PROJECT_ID, TASK_ID |
| PJC_PRJ_ASSET_LNS_ALL_N3 | Non Unique | Default | REV_PROJ_ASSET_LINE_ID |
| PJC_PRJ_ASSET_LNS_ALL_N4 | Non Unique | Default | TRANSFER_STATUS_CODE |
| PJC_PRJ_ASSET_LNS_ALL_N5 | Non Unique | Default | PROJECT_ASSET_LINE_DETAIL_ID |
| PJC_PRJ_ASSET_LNS_ALL_N6 | Non Unique | Default | REQUEST_ID |
| PJC_PRJ_ASSET_LNS_ALL_U1 | Unique | Default | PROJECT_ASSET_LINE_ID |