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_DRAFT_INVOICE_DETAILS_ALL

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_DRAFT_INVOICE_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DRAFT_INVOICE_DETAIL_ID
PA_DRAFT_INVOICE_DETAILS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID LINE_NUM
PA_DRAFT_INVOICE_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID PROJECT_ID INVOICED_FLAG
PA_DRAFT_INVOICE_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID DRAFT_INVOICE_NUM DRAFT_INVOICE_LINE_NUM
PA_DRAFT_INVOICE_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID ORIG_DRAFT_INVOICE_NUM ORIG_DRAFT_INVOICE_LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
DRAFT_INVOICE_DETAIL_ID	NUMBER		Yes
EXPENDITURE_ITEM_ID	NUMBER		Yes
LINE_NUM	NUMBER		Yes
PROJECT_ID	NUMBER		Yes
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Yes
DENOM_BILL_AMOUNT	NUMBER		Yes
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes
BILL_AMOUNT	NUMBER		Yes
REQUEST_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_RATE_DATE	DATE
ACCT_EXCHANGE_RATE	NUMBER
CC_PROJECT_ID	NUMBER		Yes
CC_TAX_TASK_ID	NUMBER		Yes
ORG_ID	NUMBER
REV_CODE_COMBINATION_ID	NUMBER
DRAFT_INVOICE_NUM	NUMBER
DRAFT_INVOICE_LINE_NUM	NUMBER
OUTPUT_VAT_TAX_ID	NUMBER
OUTPUT_TAX_EXEMPT_FLAG	VARCHAR2	(1)
OUTPUT_TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)
OUTPUT_TAX_EXEMPT_NUMBER	VARCHAR2	(80)
LINE_NUM_REVERSED	NUMBER
DETAIL_ID_REVERSED	NUMBER
REVERSED_FLAG	VARCHAR2	(1)
PROJACCT_CURRENCY_CODE	VARCHAR2	(15)
PROJACCT_COST_AMOUNT	NUMBER
PROJACCT_BILL_AMOUNT	NUMBER
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)
IND_COMPILED_SET_ID	NUMBER
RULE_PERCENTAGE	NUMBER
BILL_RATE	NUMBER
BILL_MARKUP_PERCENTAGE	NUMBER
BASE_AMOUNT	NUMBER
SCHEDULE_LINE_PERCENTAGE	NUMBER
INVOICED_FLAG	VARCHAR2	(1)
ORIG_DRAFT_INVOICE_NUM	NUMBER
ORIG_DRAFT_INVOICE_LINE_NUM	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
TP_JOB_ID	NUMBER	(15)
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)
PROJECT_TP_CURRENCY_CODE	VARCHAR2	(15)		The currency code of the operating unit that owns the project for transfer price
PROJECT_TP_RATE_DATE	DATE			Rate date used to convert raw and burdened cost from transaction currency to project currency
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert raw and burdened cost from transaction currency to project currency
PROJECT_TP_EXCHANGE_RATE	NUMBER			Exchange rate for the project functional currency for the transafer price
PROJFUNC_TP_CURRENCY_CODE	VARCHAR2	(15)		The currency code of the operating unit that owns the project for transfer price
PROJFUNC_TP_RATE_DATE	DATE			Rate date used to convert raw and burdened cost from transaction currency to project currency for OU
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert raw and burdened cost from transaction currency to project currency for OU
PROJFUNC_TP_EXCHANGE_RATE	NUMBER			Exchange rate for the project functional currency for the transafer price for OU
PROJECT_TRANSFER_PRICE	NUMBER			Transfer price in project currency.
PROJFUNC_TRANSFER_PRICE	NUMBER			Transfer price in project functional
TP_AMT_TYPE_CODE	VARCHAR2	(30)
OUTPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(50)		eTax Change

Query Text

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


SELECT DRAFT_INVOICE_DETAIL_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      PROJECT_ID
,      DENOM_CURRENCY_CODE
,      DENOM_BILL_AMOUNT
,      ACCT_CURRENCY_CODE
,      BILL_AMOUNT
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ACCT_RATE_TYPE
,      ACCT_RATE_DATE
,      ACCT_EXCHANGE_RATE
,      CC_PROJECT_ID
,      CC_TAX_TASK_ID
,      ORG_ID
,      REV_CODE_COMBINATION_ID
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_LINE_NUM
,      OUTPUT_VAT_TAX_ID
,      OUTPUT_TAX_EXEMPT_FLAG
,      OUTPUT_TAX_EXEMPT_REASON_CODE
,      OUTPUT_TAX_EXEMPT_NUMBER
,      LINE_NUM_REVERSED
,      DETAIL_ID_REVERSED
,      REVERSED_FLAG
,      PROJACCT_CURRENCY_CODE
,      PROJACCT_COST_AMOUNT
,      PROJACCT_BILL_AMOUNT
,      MARKUP_CALC_BASE_CODE
,      IND_COMPILED_SET_ID
,      RULE_PERCENTAGE
,      BILL_RATE
,      BILL_MARKUP_PERCENTAGE
,      BASE_AMOUNT
,      SCHEDULE_LINE_PERCENTAGE
,      INVOICED_FLAG
,      ORIG_DRAFT_INVOICE_NUM
,      ORIG_DRAFT_INVOICE_LINE_NUM
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TP_JOB_ID
,      PROV_PROJ_BILL_JOB_ID
,      PROJECT_TP_CURRENCY_CODE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJFUNC_TP_CURRENCY_CODE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
FROM PA.PA_DRAFT_INVOICE_DETAILS_ALL;

Dependencies

[top of page]

PA.PA_DRAFT_INVOICE_DETAILS_ALL does not reference any database object

PA.PA_DRAFT_INVOICE_DETAILS_ALL is referenced by following:

APPS: PA_DRAFT_INVOICE_DETAILS; PA_DRAFT_INVOICE_DETAILS_ALL