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

VIEW: APPS.PA_INV_BURDEN_DETAILS_V

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

View Type

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


This view shows the individual burden cost components of the invoice amount of expenditure items that are invoiced using burden schedules.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_NUMBER VARCHAR2 (25) Yes Refer to base table.
PROJECT_NAME VARCHAR2 (30) Yes Refer to base table.
PROJECT_ID NUMBER (15) Yes Refer to base table.
DRAFT_INVOICE_NUM NUMBER (15)
Refer to base table.
RA_INVOICE_NUMBER VARCHAR2 (20)
Refer to base table.
BILL_THROUGH_DATE DATE

Refer to base table.
RELEASED_DATE DATE

Refer to base table.
INVOICE_DATE DATE

Refer to base table.
GL_DATE DATE

Refer to base table.
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
Refer to base table.
EXPENDITURE_ITEM_ID NUMBER (15) Yes Refer to base table.
RDL_LINE_NUM NUMBER (15) Yes Refer to base table.
TASK_NUMBER VARCHAR2 (25) Yes Refer to base table.
TASK_NAME VARCHAR2 (20) Yes Refer to base table.
TASK_ID NUMBER (15) Yes Refer to base table.
EXPENDITURE_ORGANIZATION VARCHAR2 (240) Yes Refer to base table.
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Yes Refer to base table.
EXPENDITURE_TYPE VARCHAR2 (30) Yes Refer to base table.
EXPENDITURE_ITEM_DATE DATE
Yes Refer to base table.
RAW_COST NUMBER (22)
Refer to base table.
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project functional currency code
BILL_AMOUNT NUMBER (22)
Refer to base table.
BURDEN_COST NUMBER

Refer to base table.
COST_BASE VARCHAR2 (30) Yes Refer to base table.
CB_SORT_ORDER NUMBER (15) Yes Refer to base table.
BURDEN_COST_CODE VARCHAR2 (30) Yes Refer to base table.
BCC_PRECEDENCE NUMBER (15) Yes Refer to base table.
INPUT_MULTIPLIER NUMBER (22) Yes Refer to base table.
COMPILED_MULTIPLIER NUMBER (22) Yes Refer to base table.
BURDEN_SCHEDULE VARCHAR2 (30) Yes Refer to base table.
BURDEN_SCHEDULE_ID NUMBER (15) Yes Refer to base table.
BURDEN_SCHEDULE_REVISION VARCHAR2 (30) Yes Refer to base table.
BURDEN_SCHEDULE_REVISION_ID NUMBER (15) Yes Refer to base table.
BURDEN_STRUCTURE VARCHAR2 (30) Yes Refer to base table.
COMPILED_SET_ID NUMBER (15) Yes Refer to base table.
ORG_ID NUMBER (15)
Operating Unit Identifier
Query Text

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


SELECT PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ID
,      DRAFT_INVOICE_NUM
,      RA_INVOICE_NUMBER
,      BILL_THROUGH_DATE
,      RELEASED_DATE
,      INVOICE_DATE
,      GL_DATE
,      DRAFT_INVOICE_ITEM_LINE_NUM
,      EXPENDITURE_ITEM_ID
,      RDL_LINE_NUM
,      TASK_NUMBER
,      TASK_NAME
,      TASK_ID
,      EXPENDITURE_ORGANIZATION
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      RAW_COST
,      PROJECT_CURRENCY_CODE
,      BILL_AMOUNT
,      BURDEN_COST
,      COST_BASE
,      CB_SORT_ORDER
,      BURDEN_COST_CODE
,      BCC_PRECEDENCE
,      INPUT_MULTIPLIER
,      COMPILED_MULTIPLIER
,      BURDEN_SCHEDULE
,      BURDEN_SCHEDULE_ID
,      BURDEN_SCHEDULE_REVISION
,      BURDEN_SCHEDULE_REVISION_ID
,      BURDEN_STRUCTURE
,      COMPILED_SET_ID
,      ORG_ID
FROM APPS.PA_INV_BURDEN_DETAILS_V;

Dependencies

[top of page]

APPS.PA_INV_BURDEN_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPA_BURDEN_DETAILS_BASE_V
PL/SQL PackagePA_CURRENCY - show dependent code
SynonymPA_CUST_REV_DIST_LINES_ALL
SynonymPA_DRAFT_INVOICES
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
APPS.PA_INV_BURDEN_DETAILS_V is referenced by following:

SchemaAPPS
ViewPA_INV_BURDEN_DETAILS_LM_V