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

VIEW: APPS.PA_GL_COST_EXCEPT_DET_V

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

View Type

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


PA_GL_COST_EXCEPT_DET_V is a view that identifies the Cost Distribution Lines that prevents the PA GL period from being closed.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Project Identifier
PROJECT_NUMBER VARCHAR2 (25) Yes Project Number
TASK_ID NUMBER (15)
Task Id
TASK_NUMBER VARCHAR2 (25) Yes Task Number
INVOICE_ID NUMBER (15)
Invoice Id
INVOICE_LINE_NUMBER NUMBER (15)
This column refers to a line-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_LINES_ALL.LINE_NUMBER. If the expenditure item originated in Oracle Purchasing, it holds the PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID. This column is not used for labor and usage expenditure items.
INVOICE_DISTRIBUTION_ID NUMBER (15)
This column refers to a distribution-level record identifier in another application. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID. If the expenditure item originated in Oracle Purchasing, it holds the RCV_TRANSACTIONS.TRANSACTION_ID. This column is not used for labor and usage expenditure items.
INVOICE_PAYMENT_ID NUMBER (15)
This column refers to the payment record identifier in Oracle Payables. It holds the AP_PAYMENT_DISTRIBUTIONS_ALL.PAYMENT_ID. This column is only populated when you enable cash basis accounting or, for payment discounts, when you use accrual basis accounting. This column is not used for labor and usage expenditure items.
DOCUMENT_TYPE VARCHAR2 (30)
Document Type.
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
Document distribution Type.
SI_ASSETS_ADDITION_FLAG VARCHAR2 (1)
Supplier assets adjustments assets addition flag for non capital projects.
EXPENDITURE_ID NUMBER (15)
Expenditure Id
EXPENDITURE_ITEM_ID NUMBER (15)
Expenditure Item Id
EXPENDITURE_ITEM_DATE DATE

Expenditure Item Date
EXPENDITURE_ENDING_DATE DATE
Yes Expenditure Ending Date
EXPENDITURE_GROUP VARCHAR2 (240) Yes Expenditure Group
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type
CDL_LINE_NUM NUMBER (15)
Line Num
GL_DATE DATE

GL Date
PERIOD_NAME VARCHAR2 (15)
Period Name
QUANTITY NUMBER

Quantity
AMOUNT NUMBER

Amount
DENOM_CURRENCY_CODE VARCHAR2 (15)
Transaction Currency Code
DENOM_AMOUNT NUMBER

Denomination Currency Amount
PROJECT_AMOUNT NUMBER

Project Currency Amount
VENDOR_ID NUMBER

Vendor Id
VENDOR_NUMBER VARCHAR2 (30)
Vendor Number
VENDOR_NAME VARCHAR2 (240)
Vendor Name
PERSON_ID NUMBER (15)
Person Id
PERSON_NAME VARCHAR2 (240)
Person Name
TRANSFER_STATUS_CODE VARCHAR2 (1)
Transfer Status Code
TRANSFER_REJECTION_REASON VARCHAR2 (250)
Transfer Rejection Reason
EXCEPTION_REASON VARCHAR2 (4000)
Exception Reason
CORRECTIVE_ACTION VARCHAR2 (4000)
Corrective Action
ORG_ID NUMBER (15)
Operating Unit Identifier.
SAME_PA_GL_PERIOD VARCHAR2 (1)
Refer to base table.
OU_NAME VARCHAR2 (4000)
Operating Unit Name
SET_OF_BOOKS_ID NUMBER (15)
set of books identifier
UNIT_OF_MEASURE VARCHAR2 (30)
Unit Of Measure
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_LINE_NUMBER
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_PAYMENT_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      SI_ASSETS_ADDITION_FLAG
,      EXPENDITURE_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ENDING_DATE
,      EXPENDITURE_GROUP
,      EXPENDITURE_TYPE
,      CDL_LINE_NUM
,      GL_DATE
,      PERIOD_NAME
,      QUANTITY
,      AMOUNT
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      PROJECT_AMOUNT
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      PERSON_ID
,      PERSON_NAME
,      TRANSFER_STATUS_CODE
,      TRANSFER_REJECTION_REASON
,      EXCEPTION_REASON
,      CORRECTIVE_ACTION
,      ORG_ID
,      SAME_PA_GL_PERIOD
,      OU_NAME
,      SET_OF_BOOKS_ID
,      UNIT_OF_MEASURE
FROM APPS.PA_GL_COST_EXCEPT_DET_V;

Dependencies

[top of page]

APPS.PA_GL_COST_EXCEPT_DET_V references the following:

SchemaAPPS
PL/SQL PackagePA_EXCEPTION_REASONS_PUB - show dependent code
SynonymPA_EXPENDITURES_ALL
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
ViewPA_GL_COST_EXCEPT_SUM_V
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPER_ALL_PEOPLE_F
ViewPO_VENDORS

APPS.PA_GL_COST_EXCEPT_DET_V is not referenced by any database object