eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_PROJECT_ASSET_LINES_ALL

Object Details

Object Name:	PA_PROJECT_ASSET_LINES_ALL
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJECT_ASSET_LINES_ALL
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_ASSET_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ASSET_LINE_ID
PA_PROJECT_ASSET_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ASSET_ID
PA_PROJECT_ASSET_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
PA_PROJECT_ASSET_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REV_PROJ_ASSET_LINE_ID
PA_PROJECT_ASSET_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFER_STATUS_CODE
PA_PROJECT_ASSET_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ASSET_LINE_DETAIL_ID
PA_PROJECT_ASSET_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID
PA_PROJECT_ASSET_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_VENDOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ASSET_LINE_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the asset line
DESCRIPTION	VARCHAR2	(255)		Description of the asset line, derived from the CIP grouping method
PROJECT_ASSET_ID	NUMBER	(15)	Yes	The identifier of the asset assigned to the line; value is 0 on unassigned lines
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the CIP cost was charged
TASK_ID	NUMBER	(15)		The identifier of the task against which the CIP cost is charged
CIP_CCID	NUMBER	(15)		The identifier of the GL account to which CIP cost is charged
ASSET_COST_CCID	NUMBER	(15)		Not currently used
ORIGINAL_ASSET_COST	NUMBER	(22)		The cost amount of the line at the time the line was originally created
CURRENT_ASSET_COST	NUMBER	(22)		The line's current cost amount; split lines have a current cost <> original cost
PROJECT_ASSET_LINE_DETAIL_ID	NUMBER	(15)	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	(15)		Asset category derived from inventory item on lines with supplier invoice cost
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
REV_PROJ_ASSET_LINE_ID	NUMBER	(15)		The id of the asset line which is reversed by this line.
REV_FROM_PROJ_ASSET_LINE_ID	NUMBER	(15)		Not currently used
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
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	(15)		Vendor ID from purchasing throup AP
PO_NUMBER	VARCHAR2	(20)		Purchase Order Number entered by the user from purchasing through AP
INVOICE_DATE	DATE			Invoice Date
INVOICE_CREATED_BY	NUMBER	(15)		User ID of the person who created the invoice
INVOICE_UPDATED_BY	NUMBER	(15)		User ID of the person who updated the invoice
INVOICE_ID	NUMBER	(15)		Invoice Identification Number in AP
PAYABLES_BATCH_NAME	VARCHAR2	(50)		AP batch name of invoices
AP_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Distribution Line Number from AP
ORIGINAL_ASSET_ID	NUMBER	(15)		Asset id before calling client extension
CAPITAL_EVENT_ID	NUMBER	(15)	Yes	Capital Event Identifier
FA_PERIOD_NAME	VARCHAR2	(15)		FA Period into which asset was posted
LINE_TYPE	VARCHAR2	(30)	Yes	Asset Line Classification. Available values are C = Capital and R = Retirement.
RET_ADJUSTMENT_TXN_ID	NUMBER	(15)		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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ASSET_LINE_ID
,      DESCRIPTION
,      PROJECT_ASSET_ID
,      PROJECT_ID
,      TASK_ID
,      CIP_CCID
,      ASSET_COST_CCID
,      ORIGINAL_ASSET_COST
,      CURRENT_ASSET_COST
,      PROJECT_ASSET_LINE_DETAIL_ID
,      GL_DATE
,      TRANSFER_STATUS_CODE
,      TRANSFER_REJECTION_REASON
,      AMORTIZE_FLAG
,      NEW_MASTER_FLAG
,      ASSET_CATEGORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REV_PROJ_ASSET_LINE_ID
,      REV_FROM_PROJ_ASSET_LINE_ID
,      ORG_ID
,      INVOICE_NUMBER
,      VENDOR_NUMBER
,      PO_VENDOR_ID
,      PO_NUMBER
,      INVOICE_DATE
,      INVOICE_CREATED_BY
,      INVOICE_UPDATED_BY
,      INVOICE_ID
,      PAYABLES_BATCH_NAME
,      AP_DISTRIBUTION_LINE_NUMBER
,      ORIGINAL_ASSET_ID
,      CAPITAL_EVENT_ID
,      FA_PERIOD_NAME
,      LINE_TYPE
,      RET_ADJUSTMENT_TXN_ID
,      RETIREMENT_COST_TYPE
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
FROM PA.PA_PROJECT_ASSET_LINES_ALL;

Dependencies

[top of page]

PA.PA_PROJECT_ASSET_LINES_ALL does not reference any database object

PA.PA_PROJECT_ASSET_LINES_ALL is referenced by following:

PA: PA_PROJECT_ASSET_LINES_ALL#