DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PA_RCV_EXCEPTIONS_DET_V

Object Details
Object Name: PA_RCV_EXCEPTIONS_DET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_RCV_EXCEPTIONS_DET_V
Subobject Name:
Status: VALID

View Type

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


Pa_rcv_exceptions_det_v is a view that identifies the receipts that prevent a period from being closed


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER

Project Identifier
PROJECT_NUMBER VARCHAR2 (25) Yes Project Number
TASK_ID NUMBER

Task Identifier
TASK_NUMBER VARCHAR2 (25) Yes Task Number
RCV_TRANSACTION_ID NUMBER
Yes Receipt Identifier
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
VENDOR_ID NUMBER

Vendor Identifier
VENDOR_NUMBER VARCHAR2 (30) Yes Vendor Number
VENDOR_NAME VARCHAR2 (240)
Vendor Name
EXPENDITURE_ORGANIZATION_ID NUMBER

Expenditure Organization
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type
DENOM_CURRENCY_CODE VARCHAR2 (15)
Transaction Currency
DENOM_AMOUNT NUMBER

Transaction Amount
ACCT_CURRENCY_CODE VARCHAR2 (15)
Functional Currency
AMOUNT NUMBER

Functional Amount
ACCT_RATE_DATE DATE

Conversion Rate Date
ACCT_RATE_TYPE VARCHAR2 (30)
Conversion Rate Type
ACCT_EXCHANGE_RATE NUMBER

Conversion Rate
PA_DATE DATE

PA Date
PERIOD_NAME VARCHAR2 (4000)
PA Period
GL_DATE DATE
Yes GL date
GL_PERIOD_NAME VARCHAR2 (15)
GL Period
EXCEPTION_CODE VARCHAR2 (1)
Exception Code
EXCEPTION_REASON VARCHAR2 (4000)
Exception Reason
CORRECTIVE_ACTION VARCHAR2 (4000)
Corrective Action
ORG_ID NUMBER

Operating Unit identifier
SAME_PA_GL_PERIOD VARCHAR2 (1)
pa gl period implementation
SET_OF_BOOKS_ID NUMBER (15) Yes set of books identifier
PO_NUM VARCHAR2 (20) Yes Purchase Order Number
LINE_NUM NUMBER
Yes Purchase Order Line Number
SHIPMENT_NUM NUMBER

Purchase Order Shipment Number
DISTRIBUTION_NUM NUMBER
Yes Purchse Order Distribution Number
OU_NAME VARCHAR2 (4000)
Operating Unit Name
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      RCV_TRANSACTION_ID
,      RECEIPT_NUMBER
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      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
,      EXCEPTION_CODE
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      SET_OF_BOOKS_ID
,      PO_NUM
,      LINE_NUM
,      SHIPMENT_NUM
,      DISTRIBUTION_NUM
,      OU_NAME
FROM APPS.PA_RCV_EXCEPTIONS_DET_V;

Dependencies

[top of page]

APPS.PA_RCV_EXCEPTIONS_DET_V references the following:

SchemaAPPS
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
ViewPA_RCV_EXCEPTIONS_SUM_V
SynonymPA_TASKS
PL/SQL PackagePA_UTILS - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_VENDORS
SynonymRCV_SHIPMENT_HEADERS

APPS.PA_RCV_EXCEPTIONS_DET_V is not referenced by any database object