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


VIEW: APPS.PA_DRAFT_INV_LINE_DETAILS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_ITEM_ID NUMBER

LINE_NUM NUMBER

PROJECT_ID NUMBER

DRAFT_INVOICE_NUM NUMBER

DRAFT_INVOICE_ITEM_LINE_NUM NUMBER

RAW_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project functional currency code
PROJECT_RATE_DATE DATE

Date for accounting currency rate for a given rate type
PROJECT_RATE_TYPE VARCHAR2 (30)
Project currency rate type
USER_PROJECT_RATE_TYPE VARCHAR2 (30)
Project user currency exchange rate type
PROJECT_EXCHANGE_RATE NUMBER

Project currency rate for a given rate date and rate type
RECEIPT_CURRENCY_AMOUNT NUMBER

For Expense report this value will be populated, for others, value will be null
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
This will be the currency in which the expense report was incurred
RECEIPT_EXCHANGE_RATE NUMBER

Conversion factor to convert receipt amount to denomination cost
DENOM_RAW_COST NUMBER

Denomination Cost
DENOM_BURDENED_COST NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
Denomination Currency code
ACCT_RAW_COST NUMBER

Sum of Denomination cost and acct exchange rate
ACCT_BURDENED_COST NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
Accounting Currency code
ACCT_RATE_DATE DATE

Date for accounting currency rate for a given rate type
ACCT_RATE_TYPE VARCHAR2 (30)
Accounting currency rate type
USER_ACCT_RATE_TYPE VARCHAR2 (30)
Accounting user currency exchange rate type
ACCT_EXCHANGE_RATE NUMBER

Accounting currency rate for a given rate date and rate type
ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

Accounting currency rounding off tolerance limit for imported transactions
BILL_AMOUNT NUMBER

LINE_NUM_REVERSED NUMBER

REVERSED_FLAG VARCHAR2 (1)
EXPENDITURE_ID NUMBER

TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_TYPE VARCHAR2 (30)
INCURRED_BY_PERSON_ID NUMBER

EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
JOB_ID NUMBER

JOB_NAME VARCHAR2 (700)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240)
VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
EMPLOYEE_VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NUMBER VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
NLR_ORGANIZATION_ID NUMBER

NLR_ORGANIZATION_NAME VARCHAR2 (240)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
SYSTEM_LINKAGE_M VARCHAR2 (80)
EXPENDITURE_COMMENT VARCHAR2 (240)
TRANSACTION_SOURCE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
EXPENDITURE_GROUP VARCHAR2 (240)
EXPENDITURE_STATUS_CODE VARCHAR2 (30)
QUANTITY NUMBER

BURDEN_COST NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
UNIT_OF_MEASURE_M VARCHAR2 (80)
COST_DISTRIBUTED_FLAG VARCHAR2 (1)
RAW_COST_RATE NUMBER

BILL_RATE NUMBER

BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER

NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER

CONVERTED_FLAG VARCHAR2 (1)
SOURCE_EXPENDITURE_ITEM_ID NUMBER

EVENT_PROJECT_ID NUMBER (15)
project_id
EVENT_TASK_ID NUMBER (15)
EVENT_NUM NUMBER (15)
BILLABLE_FLAG VARCHAR2 (1)
BILL_HOLD_FLAG VARCHAR2 (1)
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1)
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
USER_TRANSACTION_SOURCE VARCHAR2 (80)
ALLOW_ADJUSTMENTS_FLAG VARCHAR2 (1)
COSTED_FLAG VARCHAR2 (1)
COST_BURDENED_FLAG VARCHAR2 (1)
GL_ACCOUNTED_FLAG VARCHAR2 (1)
BURDEN_SUM_DEST_RUN_ID NUMBER

BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
BURDEN_SUM_REJECTION_M VARCHAR2 (80)
PROJECT_STATUS_CODE VARCHAR2 (30)
SYSTEM_REFERENCE2 VARCHAR2 (30)
MODE_IND VARCHAR2 (13)
Mode Indicator
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE DATE

INVPROC_EXCHANGE_RATE NUMBER

INVPROC_BILL_AMOUNT NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_RATE_TYPE VARCHAR2 (30)
PROJFUNC_RATE_DATE DATE

PROJFUNC_EXCHANGE_RATE NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

PROJ_RATE_TYPE VARCHAR2 (30)
PROJ_RATE_DATE DATE

PROJ_EXCHANGE_RATE NUMBER

PROJ_BILL_AMOUNT NUMBER

FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_RATE_TYPE VARCHAR2 (30)
FUNDING_RATE_DATE DATE

FUNDING_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER

PROJECT_RAW_COST NUMBER

Raw cost in Project Currency
PROJECT_BURDEN_COST NUMBER

Burden cost in Project Currency
PROJFUNC_COST_RATE_DATE DATE

Project functional rate date for Costing
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Project functional currency rate type for Costing
PROJFUNC_COST_EXCHANGE_RATE NUMBER

Project functional currency rate for a given rate date and rate type for Costing
IC_BILLING_PROJ_CURR_CODE VARCHAR2 (15)
Inter Company Billing Project Currency Code.
IC_BILLING_PROJFUNC_CURR_CODE VARCHAR2 (15)
Inter Company Billing Project Functional Currency Code.
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
ACCT_TP_RATE_TYPE VARCHAR2 (30)
USER_ACCT_TP_RATE_TYPE VARCHAR2 (30)
ACCT_TP_RATE_DATE DATE

ACCT_TP_EXCHANGE_RATE NUMBER

USER_PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PRVDR_ORG_ID NUMBER

RECVR_ORG_ID NUMBER

CC_CROSS_CHARGE_CODE VARCHAR2 (1)
CC_CROSS_CHARGE_TYPE VARCHAR2 (2)
CC_BL_DISTRIBUTED_CODE VARCHAR2 (1)
CC_IC_PROCESSED_CODE VARCHAR2 (1)
CC_REJECTION_CODE VARCHAR2 (30)
EXPENDITURE_ORG_ID NUMBER

WORK_TYPE_ID NUMBER

WORK_TYPE_NAME VARCHAR2 (4000)
TP_AMT_TYPE_CODE VARCHAR2 (30)
TRANSACTION_TYPE VARCHAR2 (80)
RATE_DISC_REASON_CODE VARCHAR2 (30)
Bill rate discount reason code
DISCOUNT_PERCENTAGE NUMBER

Discount Percentage
RETAINED_AMOUNT NUMBER

Retained Amount in Invoice Processing Currency
ORG_ID NUMBER

DOCUMENT_HEADER_ID NUMBER

DOCUMENT_LINE_NUMBER NUMBER

DOCUMENT_DISTRIBUTION_ID NUMBER

DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
ALLOW_BURDEN_FLAG VARCHAR2 (1)
DOCUMENT_PAYMENT_ID NUMBER

Query Text

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


SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUM
,      PROJECT_ID
,      DRAFT_INVOICE_NUM
,      DRAFT_INVOICE_ITEM_LINE_NUM
,      RAW_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      USER_PROJECT_RATE_TYPE
,      PROJECT_EXCHANGE_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_EXCHANGE_RATE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      DENOM_CURRENCY_CODE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_DATE
,      ACCT_RATE_TYPE
,      USER_ACCT_RATE_TYPE
,      ACCT_EXCHANGE_RATE
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      BILL_AMOUNT
,      LINE_NUM_REVERSED
,      REVERSED_FLAG
,      EXPENDITURE_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      INCURRED_BY_PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      JOB_ID
,      JOB_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      EMPLOYEE_VENDOR_NAME
,      EMPLOYEE_VENDOR_NUMBER
,      NON_LABOR_RESOURCE
,      NLR_ORGANIZATION_ID
,      NLR_ORGANIZATION_NAME
,      SYSTEM_LINKAGE_FUNCTION
,      SYSTEM_LINKAGE_M
,      EXPENDITURE_COMMENT
,      TRANSACTION_SOURCE
,      ORIG_TRANSACTION_REFERENCE
,      EXPENDITURE_GROUP
,      EXPENDITURE_STATUS_CODE
,      QUANTITY
,      BURDEN_COST
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_M
,      COST_DISTRIBUTED_FLAG
,      RAW_COST_RATE
,      BILL_RATE
,      BILL_JOB_BILLING_TITLE
,      BILL_EMPLOYEE_BILLING_TITLE
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      CONVERTED_FLAG
,      SOURCE_EXPENDITURE_ITEM_ID
,      EVENT_PROJECT_ID
,      EVENT_TASK_ID
,      EVENT_NUM
,      BILLABLE_FLAG
,      BILL_HOLD_FLAG
,      REVENUE_DISTRIBUTED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      USER_TRANSACTION_SOURCE
,      ALLOW_ADJUSTMENTS_FLAG
,      COSTED_FLAG
,      COST_BURDENED_FLAG
,      GL_ACCOUNTED_FLAG
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      BURDEN_SUM_REJECTION_M
,      PROJECT_STATUS_CODE
,      SYSTEM_REFERENCE2
,      MODE_IND
,      BILL_TRANS_CURRENCY_CODE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      INVPROC_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      PROJ_RATE_TYPE
,      PROJ_RATE_DATE
,      PROJ_EXCHANGE_RATE
,      PROJ_BILL_AMOUNT
,      FUNDING_CURRENCY_CODE
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      FUNDING_BILL_AMOUNT
,      PROJECT_RAW_COST
,      PROJECT_BURDEN_COST
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      IC_BILLING_PROJ_CURR_CODE
,      IC_BILLING_PROJFUNC_CURR_CODE
,      DENOM_TP_CURRENCY_CODE
,      ACCT_TP_RATE_TYPE
,      USER_ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      USER_PROJFUNC_COST_RATE_TYPE
,      PRVDR_ORG_ID
,      RECVR_ORG_ID
,      CC_CROSS_CHARGE_CODE
,      CC_CROSS_CHARGE_TYPE
,      CC_BL_DISTRIBUTED_CODE
,      CC_IC_PROCESSED_CODE
,      CC_REJECTION_CODE
,      EXPENDITURE_ORG_ID
,      WORK_TYPE_ID
,      WORK_TYPE_NAME
,      TP_AMT_TYPE_CODE
,      TRANSACTION_TYPE
,      RATE_DISC_REASON_CODE
,      DISCOUNT_PERCENTAGE
,      RETAINED_AMOUNT
,      ORG_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      ALLOW_BURDEN_FLAG
,      DOCUMENT_PAYMENT_ID
FROM APPS.PA_DRAFT_INV_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.PA_DRAFT_INV_LINE_DETAILS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymGL_DAILY_CONVERSION_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPA_CONVERSION_TYPES_V
SynonymPA_COST_DIST_LINES_ALL_BAS
SynonymPA_CUST_EVENT_REV_DIST_LINES
SynonymPA_CUST_REV_DIST_LINES
SynonymPA_DRAFT_INVOICE_DETAILS
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_EVENTS
SynonymPA_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_COMMENTS
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_EXPENDITURE_TYPES
ViewPA_EXPEND_ITEMS_ADJUST_V
ViewPA_LOOKUPS
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_TYPES_ALL
PL/SQL PackagePA_SECURITY - show dependent code
SynonymPA_SYSTEM_LINKAGES
SynonymPA_TASKS
SynonymPA_TRANSACTION_SOURCES
PL/SQL PackagePA_UTILS4 - show dependent code
SynonymPER_JOBS
ViewPER_PEOPLE_F
ViewPO_VENDORS

APPS.PA_DRAFT_INV_LINE_DETAILS_V is not referenced by any database object