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: APPS.PA_AP_INV_EXCEPTIONS_DET_V

Object Details

Object Name:	PA_AP_INV_EXCEPTIONS_DET_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_AP_INV_EXCEPTIONS_DET_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PA_AP_INV_EXCEPTIONS_DET_V is a detail view that identifies the Oracle Payables invoices that can prevent an Oracle Projects period from being closed. This view is based on PA_AP_INV_EXCEPTIONS_SUM_V.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)		Refer to the base table
PROJECT_NUMBER	VARCHAR2	(25)	Yes	Refer to the base table
TASK_ID	NUMBER	(15)		Refer to the base table
TASK_NUMBER	VARCHAR2	(25)	Yes	Refer to the base table
INVOICE_ID	NUMBER	(15)		Refer to the base table
INVOICE_NUMBER	VARCHAR2	(50)		Refer to the base table
INVOICE_DATE	DATE			Refer to the base table
INVOICE_LINE_NUMBER	NUMBER			Refer to the base table
INVOICE_DISTRIBUTION_ID	NUMBER	(15)		Refer to the base table
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)		Refer to the base table
VENDOR_ID	NUMBER	(15)		Refer to the base table
VENDOR_NUMBER	VARCHAR2	(30)	Yes	Refer to the base table
VENDOR_NAME	VARCHAR2	(240)		Refer to the base table
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		Refer to the base table
EXPENDITURE_TYPE	VARCHAR2	(30)		Refer to the base table
QUANTITY	NUMBER	(22)		Refer to the base table
DENOM_CURRENCY_CODE	VARCHAR2	(15)		Refer to the base table
DENOM_AMOUNT	NUMBER			Refer to the base table
ACCT_CURRENCY_CODE	VARCHAR2	(15)		Refer to the base table
AMOUNT	NUMBER			Refer to the base table
ACCT_RATE_DATE	DATE			Refer to the base table
ACCT_RATE_TYPE	VARCHAR2	(30)		Refer to the base table
ACCT_EXCHANGE_RATE	NUMBER			Refer to the base table
PA_DATE	DATE			Refer to the base table
PERIOD_NAME	VARCHAR2	(4000)		Refer to the base table
GL_DATE	DATE			Refer to the base table
GL_PERIOD_NAME	VARCHAR2	(15)		Refer to the base table
POSTED_FLAG	VARCHAR2	(1)		Refer to the base table
EXCEPTION_CODE	VARCHAR2	(1)		Refer to the base table
EXCEPTION_REASON	VARCHAR2	(4000)		Refer to the base table
CORRECTIVE_ACTION	VARCHAR2	(4000)		Refer to the base table
ORG_ID	NUMBER	(15)		Operating Unit Identifier
SAME_PA_GL_PERIOD	VARCHAR2	(1)		same pa gl period
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger identifier
PAYMENT_NUM	NUMBER			Payment Number
CHECK_NUMBER	NUMBER			check number

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      INVOICE_ID
,      INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      DISTRIBUTION_LINE_NUMBER
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      QUANTITY
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      PA_DATE
,      PERIOD_NAME
,      GL_DATE
,      GL_PERIOD_NAME
,      POSTED_FLAG
,      EXCEPTION_CODE
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      SET_OF_BOOKS_ID
,      PAYMENT_NUM
,      CHECK_NUMBER
FROM APPS.PA_AP_INV_EXCEPTIONS_DET_V;

Dependencies

[top of page]

APPS.PA_AP_INV_EXCEPTIONS_DET_V references the following:

APPS: PA_AP_INV_EXCEPTIONS_SUM_V; PA_EXCEPTION_REASONS_PUB - show dependent code; PA_EXPENDITURES_UTILS - show dependent code; PA_IMPLEMENTATIONS_ALL; PA_PROJECTS_ALL; PA_TASKS; PA_UTILS2 - show dependent code; PO_VENDORS

APPS.PA_AP_INV_EXCEPTIONS_DET_V is not referenced by any database object