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]

VIEW: PA.PA_DRAFT_INV_DETS_AR#

Object Details

Object Name:	PA_DRAFT_INV_DETS_AR#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PURGE_BATCH_ID	NUMBER	(15)	Yes
ACCT_CURRENCY_CODE	VARCHAR2	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LINE_NUM	NUMBER	(22)
LINE_NUM_REVERSED	NUMBER	(22)
MARKUP_CALC_BASE_CODE	VARCHAR2	(1)
ORG_ID	NUMBER	(15)
ORIG_DRAFT_INVOICE_LINE_NUM	NUMBER	(22)
ORIG_DRAFT_INVOICE_NUM	NUMBER	(22)
OUTPUT_TAX_EXEMPT_FLAG	VARCHAR2	(1)
OUTPUT_TAX_EXEMPT_NUMBER	VARCHAR2	(80)
OUTPUT_TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)
OUTPUT_VAT_TAX_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
PROJACCT_BILL_AMOUNT	NUMBER	(22)
PROJACCT_COST_AMOUNT	NUMBER	(22)
PROJACCT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_ID	NUMBER	(15)
PROJECT_TP_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_TP_RATE_DATE	DATE
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)
PROJECT_TRANSFER_PRICE	NUMBER	(22)
PROJFUNC_TP_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_TP_EXCHANGE_RATE	NUMBER	(22)
PROJFUNC_TP_RATE_DATE	DATE
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_TRANSFER_PRICE	NUMBER	(22)
PROV_PROJ_BILL_JOB_ID	NUMBER	(15)
PURGE_PROJECT_ID	NUMBER	(15)	Yes
PURGE_RELEASE	VARCHAR2	(50)	Yes
REQUEST_ID	NUMBER	(15)
REVERSED_FLAG	VARCHAR2	(1)
REV_CODE_COMBINATION_ID	NUMBER	(15)
RULE_PERCENTAGE	NUMBER	(22)
SCHEDULE_LINE_PERCENTAGE	NUMBER	(22)
TP_AMT_TYPE_CODE	VARCHAR2	(30)
TP_JOB_ID	NUMBER	(15)
ACCT_EXCHANGE_RATE	NUMBER	(22)
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
BASE_AMOUNT	NUMBER	(22)
BILL_AMOUNT	NUMBER	(22)
BILL_MARKUP_PERCENTAGE	NUMBER	(22)
BILL_RATE	NUMBER	(22)
CC_PROJECT_ID	NUMBER	(15)
CC_TAX_TASK_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
DENOM_BILL_AMOUNT	NUMBER	(22)
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DETAIL_ID_REVERSED	NUMBER	(22)
DRAFT_INVOICE_DETAIL_ID	NUMBER	(15)
DRAFT_INVOICE_LINE_NUM	NUMBER	(22)
DRAFT_INVOICE_NUM	NUMBER	(22)
EXPENDITURE_ITEM_ID	NUMBER	(15)
IND_COMPILED_SET_ID	NUMBER	(15)
INVOICED_FLAG	VARCHAR2	(1)
LAST_UPDATED_BY	NUMBER	(15)	Yes
PROJECT_TP_EXCHANGE_RATE	NUMBER	(22)
OUTPUT_TAX_CLASSIFICATION_CODE	VARCHAR2	(50)

Query Text

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


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

Dependencies

[top of page]

PA.PA_DRAFT_INV_DETS_AR# references the following:

PA: PA_DRAFT_INV_DETS_AR

PA.PA_DRAFT_INV_DETS_AR# is referenced by following:

APPS: PA_DRAFT_INV_DETS_AR