[Home] [Help] [Dependency Information]
Object Name: | PA_RCV_EXCEPTIONS_DET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_RCV_EXCEPTIONS_DET_V |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
APPS.PA_RCV_EXCEPTIONS_DET_V is not referenced by any database object
|
|
|