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_TSK_BILL_SCH_OVRD_TMP

Object Details

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

Temporary Table Details

PA.PA_TSK_BILL_SCH_OVRD_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
OBJECT_ID	NUMBER
OBJECT_TYPE	VARCHAR2	(15)
LABOR_SCH_TYPE	VARCHAR2	(1)
EMP_BILL_RATE_SCHEDULE_ID	NUMBER
JOB_BILL_RATE_SCHEDULE_ID	NUMBER
LABOR_SCHEDULE_FIXED_DATE	DATE
LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)
LABOR_DISC_REASON_CODE	VARCHAR2	(30)
NON_LABOR_SCH_TYPE	VARCHAR2	(1)
NON_LABOR_BILL_RATE_ORG_ID	NUMBER	(15)
NON_LABOR_STD_BILL_RATE_SCHDL	VARCHAR2	(30)
NON_LAB_STD_BILL_RT_SCH_ID	NUMBER	(15)
NON_LABOR_SCHEDULE_FIXED_DATE	DATE
NON_LABOR_SCHEDULE_DISCOUNT	NUMBER	(7)
NON_LABOR_DISC_REASON_CODE	VARCHAR2	(30)
REV_IND_RATE_SCH_ID	NUMBER	(15)
REV_IND_SCH_FIXED_DATE	DATE
INV_IND_RATE_SCH_ID	NUMBER	(15)
INV_IND_SCH_FIXED_DATE	DATE
BILL_SCHE_OVRD_FLAG	VARCHAR2	(1)

Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE
,      LABOR_SCH_TYPE
,      EMP_BILL_RATE_SCHEDULE_ID
,      JOB_BILL_RATE_SCHEDULE_ID
,      LABOR_SCHEDULE_FIXED_DATE
,      LABOR_SCHEDULE_DISCOUNT
,      LABOR_DISC_REASON_CODE
,      NON_LABOR_SCH_TYPE
,      NON_LABOR_BILL_RATE_ORG_ID
,      NON_LABOR_STD_BILL_RATE_SCHDL
,      NON_LAB_STD_BILL_RT_SCH_ID
,      NON_LABOR_SCHEDULE_FIXED_DATE
,      NON_LABOR_SCHEDULE_DISCOUNT
,      NON_LABOR_DISC_REASON_CODE
,      REV_IND_RATE_SCH_ID
,      REV_IND_SCH_FIXED_DATE
,      INV_IND_RATE_SCH_ID
,      INV_IND_SCH_FIXED_DATE
,      BILL_SCHE_OVRD_FLAG
FROM PA.PA_TSK_BILL_SCH_OVRD_TMP;

Dependencies

[top of page]

PA.PA_TSK_BILL_SCH_OVRD_TMP does not reference any database object

PA.PA_TSK_BILL_SCH_OVRD_TMP is referenced by following:

APPS: PA_TSK_BILL_SCH_OVRD_TMP