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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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
PA_DRAFT_INVOICE_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CC_TAX_TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DRAFT_INVOICE_DETAIL_ID	NUMBER		Yes	The system generated number that uniquely identifies the invoice detail
EXPENDITURE_ITEM_ID	NUMBER		Yes	Identifier of the Expenditure Item to which the distribution belongs
LINE_NUM	NUMBER		Yes	The sequential line number that identifies the invoice detail for an expenditure item
PROJECT_ID	NUMBER		Yes	Identifier of the project which will be used to bill the transaction For cross charged transactions, this is the intercompany billing project
DENOM_CURRENCY_CODE	VARCHAR2	(15)	Yes	Transaction currency code of the transfer price
DENOM_BILL_AMOUNT	NUMBER		Yes	Transaction amount of the transfer price
ACCT_CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code of the provider operating unit
BILL_AMOUNT	NUMBER		Yes	Functional currency amount of the transfer price
REQUEST_ID	NUMBER		Yes	Identifier of the concurrent program that last processed the item
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
ACCT_RATE_TYPE	VARCHAR2	(30)		Rate type used to convert the transfer price from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price
ACCT_RATE_DATE	DATE			Rate date used to convert the transfer price from the transaction currency to the functional currency. Derived from the implementation options currency rate date code for transfer price conversion
ACCT_EXCHANGE_RATE	NUMBER			Exchange rate used to convert the transfer price from the transaction currency to the functional currency
CC_PROJECT_ID	NUMBER		Yes	Identifier of the cross charged project for the transaction.
CC_TAX_TASK_ID	NUMBER		Yes	Identifier of the task id used to capture non-recoverable tax on the cross charged project
ORG_ID	NUMBER			Identifier of the Operating Unit to which the detail line belongs
REV_CODE_COMBINATION_ID	NUMBER			Identifier of the GL account for intercompany revenue associated with the transaction
DRAFT_INVOICE_NUM	NUMBER			Invoice number of the draft invoice in which the invoice detail is billed
DRAFT_INVOICE_LINE_NUM	NUMBER			Line number in the draft invoice in which the invoice detail is billed
OUTPUT_VAT_TAX_ID	NUMBER			Identifier for default output tax code
OUTPUT_TAX_EXEMPT_FLAG	VARCHAR2	(1)		Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup
OUTPUT_TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Tax Exempt Reason for lines that have tax_exempt_flag set to (E-exempt)
OUTPUT_TAX_EXEMPT_NUMBER	VARCHAR2	(80)		Exemption Certificate Number for lines that have tax_exempt_flag set to (E-exempt)
LINE_NUM_REVERSED	NUMBER			The invoice detail line number for the same expenditure item that is reversed by this invoice detail line
DETAIL_ID_REVERSED	NUMBER			Identifier of the detail line that the line reverses.
REVERSED_FLAG	VARCHAR2	(1)		Indicates whether the line has been reversed
PROJACCT_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code of the receiver operating unit. Populated but not currently used
PROJACCT_COST_AMOUNT	NUMBER			Cost amount at the time of creating the invoice detail in the project currency. This column is for future use
PROJACCT_BILL_AMOUNT	NUMBER			Transfer price amount in the project functional currency. This currency amount does not have other currency attributes since it is determined by proration. This column is for future use
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)		Audit column. Transaction amount on which the cross charge rate will be based.
IND_COMPILED_SET_ID	NUMBER			Audit column. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price
RULE_PERCENTAGE	NUMBER			Audit column. Percentage applied to the calculated transfer price from the rule definition
BILL_RATE	NUMBER			Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule
BILL_MARKUP_PERCENTAGE	NUMBER			Audit column. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule
BASE_AMOUNT	NUMBER			Audit column. Base amount used to derive the bill amount held in transaction currency
SCHEDULE_LINE_PERCENTAGE	NUMBER			Audit column. Percentage applied to the calculated transfer price from the schedule line
INVOICED_FLAG	VARCHAR2	(1)		Indicates whether the detail line has been invoiced(included on an invoice). Default value is 'N'.
ORIG_DRAFT_INVOICE_NUM	NUMBER			Draft Invoice Number on which the reversed line is invoiced. The column is populated for reversing lines only.
ORIG_DRAFT_INVOICE_LINE_NUM	NUMBER			Draft Invoice Number on which the reversed line is invoiced. The column is populated for reversing lines only.
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
TP_JOB_ID	NUMBER	(15)		Identifies the Job for the transaction for which the Transfer Price is based on.
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)		Identifies the Job for the transaction for which the IC billing is based on.
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)		Cross charge classification.
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:

PA: PA_DRAFT_INVOICE_DETAILS_ALL#