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_SUM_V

Object Details

Object Name:	PA_AP_INV_EXCEPTIONS_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_AP_INV_EXCEPTIONS_SUM_V
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.

PA_AP_INV_EXCEPTIONS_SUM_V is a summary view that identifies the Oracle Payables invoices that can prevent an Oracle Projects period from being closed.

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
INVOICE_ID	NUMBER	(15)
INVOICE_NUMBER	VARCHAR2	(50)
INVOICE_LINE_NUMBER	NUMBER		Invoice Line Number.
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Invoice Distribution Identifier.
INVOICE_DATE	DATE
VENDOR_ID	NUMBER	(15)
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_AMOUNT	NUMBER
ACCT_CURRENCY_CODE	VARCHAR2	(15)
AMOUNT	NUMBER
ACCT_RATE_DATE	DATE
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_EXCHANGE_RATE	NUMBER
EXCEPTION_CODE	VARCHAR2	(1)
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_ITEM_DATE	DATE
QUANTITY	NUMBER
GL_DATE	DATE
PA_DATE	DATE
PERIOD_NAME	VARCHAR2	(4000)
GL_PERIOD_NAME	VARCHAR2	(15)
POSTED_FLAG	VARCHAR2	(1)
EXCEPTION_REASON	VARCHAR2	(4000)
CORRECTIVE_ACTION	VARCHAR2	(4000)
ORG_ID	NUMBER	(15)
SAME_PA_GL_PERIOD	VARCHAR2	(1)
OU_NAME	VARCHAR2	(4000)	Operating Unit Name
SET_OF_BOOKS_ID	NUMBER	(15)	set of books identifier
VENDOR_NUMBER	VARCHAR2	(30)
VENDOR_NAME	VARCHAR2	(240)
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
,      TASK_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      INVOICE_LINE_NUMBER
,      DISTRIBUTION_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_DATE
,      VENDOR_ID
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      ACCT_CURRENCY_CODE
,      AMOUNT
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      EXCEPTION_CODE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      QUANTITY
,      GL_DATE
,      PA_DATE
,      PERIOD_NAME
,      GL_PERIOD_NAME
,      POSTED_FLAG
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      PAYMENT_NUM
,      CHECK_NUMBER
FROM APPS.PA_AP_INV_EXCEPTIONS_SUM_V;

Dependencies

[top of page]

APPS.PA_AP_INV_EXCEPTIONS_SUM_V references the following:

APPS: AP_CHECKS_ALL; AP_INVOICES_ALL; AP_INVOICE_DISTRIBUTIONS_ALL; AP_INVOICE_LINES_ALL; AP_INVOICE_PAYMENTS_ALL; AP_PAYMENT_HISTORY_ALL; AP_PAYMENT_HIST_DISTS; AP_SELF_ASSESSED_TAX_DIST_ALL; GL_LEDGERS; MTL_SYSTEM_ITEMS; PA_EXCEPTION_REASONS_PUB - show dependent code; PA_EXPENDITURES_UTILS - show dependent code; PA_IMPLEMENTATIONS_ALL; PA_NL_INSTALLED - show dependent code; PA_UTILS2 - show dependent code; PO_DISTRIBUTIONS; PO_DISTRIBUTIONS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_VENDORS

APPS.PA_AP_INV_EXCEPTIONS_SUM_V is referenced by following:

APPS: PA_AP_INV_EXCEPTIONS_DET_V