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


VIEW: APPS.PA_EXPEND_ITEMS_ADJUST_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_ITEM_ID NUMBER (15) Yes
EXPENDITURE_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
PROJECT_NUMBER VARCHAR2 (25) Yes
PROJECT_NAME VARCHAR2 (30) Yes
PROJECT_TYPE VARCHAR2 (20) Yes
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
PROJECT_CLASS VARCHAR2 (80) Yes
TASK_ID NUMBER (15) Yes
TASK_NUMBER VARCHAR2 (25) Yes
TASK_NAME VARCHAR2 (20) Yes
EXPENDITURE_ITEM_DATE DATE
Yes
EXPENDITURE_TYPE VARCHAR2 (30) Yes
EXPENDITURE_CATEGORY VARCHAR2 (30) Yes
REVENUE_CATEGORY_CODE VARCHAR2 (30) Yes
INCURRED_BY_PERSON_ID NUMBER (15)
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
JOB_ID NUMBER (15)
JOB_NAME VARCHAR2 (700)
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240) Yes
VENDOR_ID NUMBER

VENDOR_NUMBER VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NUMBER VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
NLR_ORGANIZATION_ID NUMBER (15)
NLR_ORGANIZATION_NAME VARCHAR2 (240)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Yes
SYSTEM_LINKAGE_M VARCHAR2 (80) Yes
EXPENDITURE_COMMENT VARCHAR2 (240)
TRANSACTION_SOURCE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
EXPENDITURE_GROUP VARCHAR2 (240) Yes
EXPENDITURE_STATUS_CODE VARCHAR2 (30) Yes
EXPENDITURE_STATUS_M VARCHAR2 (80) Yes
EXPENDITURE_ENDING_DATE DATE
Yes
QUANTITY NUMBER

BURDEN_COST NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
UNIT_OF_MEASURE_M VARCHAR2 (80) Yes
RAW_COST NUMBER

RAW_COST_RATE NUMBER

COST_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
COST_DIST_REJECTION_CODE VARCHAR2 (30)
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
BURDENED_COST NUMBER

BURDENED_COST_RATE NUMBER

COST_BURDEN_DISTRIBUTED_FLAG VARCHAR2 (1)
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_EXCHANGE_RATE NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_RATE_DATE DATE

ACCT_EXCHANGE_RATE NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_RATE_DATE DATE

PROJECT_EXCHANGE_RATE NUMBER

IND_COST_DIST_REJECTION_CODE VARCHAR2 (30)
COST_IND_COMPILED_SET_ID NUMBER (15)
CAPITALIZABLE_FLAG VARCHAR2 (1)
ACCRUED_REVENUE NUMBER (22)
ACCRUAL_RATE NUMBER (22)
RAW_REVENUE NUMBER (22)
FORECAST_REVENUE NUMBER (22)
BILL_AMOUNT NUMBER (22)
BILL_RATE NUMBER (22)
BILL_RATE_MULTIPLIER NUMBER (22)
ADJUSTED_REVENUE NUMBER (22)
ADJUSTED_RATE NUMBER (22)
BILLABLE_FLAG VARCHAR2 (1)
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Yes
BILL_HOLD_FLAG VARCHAR2 (1) Yes
REV_DIST_REJECTION_CODE VARCHAR2 (30)
BILL_JOB_ID NUMBER (15)
BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
EVENT_PROJECT_ID NUMBER (15)
EVENT_NUM NUMBER (15)
EVENT_TASK_ID NUMBER (15)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER (15)
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER (15)
CONVERTED_FLAG VARCHAR2 (1)
SOURCE_EXPENDITURE_ITEM_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
EXPENDITURE_ORG_ID NUMBER (15)
SYSTEM_REFERENCE2 VARCHAR2 (30)
ORG_ID NUMBER (15)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
ALLOW_ADJUSTMENTS_FLAG VARCHAR2 (1)
COSTED_FLAG VARCHAR2 (1)
COST_BURDENED_FLAG VARCHAR2 (1)
GL_ACCOUNTED_FLAG VARCHAR2 (1)
ALLOW_REVERSAL_FLAG VARCHAR2 (1)
ALLOW_BURDEN_FLAG VARCHAR2 (1)
BURDEN_SUM_DEST_RUN_ID NUMBER (15)
BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
BURDEN_SUM_REJECTION_M VARCHAR2 (80)
PROJECT_STATUS_CODE VARCHAR2 (30) Yes
USER_ACCT_RATE_TYPE VARCHAR2 (30)
USER_PROJECT_RATE_TYPE VARCHAR2 (30)
ORIG_EXP_TXN_REFERENCE1 VARCHAR2 (60)
ORIG_USER_EXP_TXN_REFERENCE VARCHAR2 (60)
ORIG_EXP_TXN_REFERENCE2 VARCHAR2 (60)
ORIG_EXP_TXN_REFERENCE3 VARCHAR2 (60)
OVERRIDING_APPROVER_PERSON_ID NUMBER

WF_STATUS_CODE VARCHAR2 (30)
TRANSFER_STATUS_CODE VARCHAR2 (1)
USER_BATCH_NAME VARCHAR2 (50)
BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
PROJECT_BILL_AMOUNT NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_BILL_AMOUNT NUMBER

INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE DATE

INVPROC_EXCHANGE_RATE NUMBER

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJECT_RAW_COST NUMBER

PROJECT_BURDENED_COST NUMBER

ASSIGNMENT_ID NUMBER (15)
WORK_TYPE_ID NUMBER (15)
PROJECT_TP_RATE_DATE DATE

PROJECT_TP_RATE_TYPE VARCHAR2 (30)
PROJECT_TP_EXCHANGE_RATE NUMBER

PROJECT_TRANSFER_PRICE NUMBER

TP_AMT_TYPE_CODE VARCHAR2 (30)
PROJFUNC_TP_RATE_DATE DATE

PROJFUNC_TP_RATE_TYPE VARCHAR2 (30)
PROJFUNC_TP_EXCHANGE_RATE NUMBER

PROJFUNC_TRANSFER_PRICE NUMBER

BILL_TRANS_BILL_AMOUNT NUMBER

PRVDR_ACCRUAL_DATE DATE

RECVR_ACCRUAL_DATE DATE

CC_CROSS_CHARGE_CODE VARCHAR2 (1) Yes
CC_CROSS_CHARGE_TYPE VARCHAR2 (2)
CC_BL_DISTRIBUTED_CODE VARCHAR2 (1) Yes
CC_IC_PROCESSED_CODE VARCHAR2 (1) Yes
CC_REJECTION_CODE VARCHAR2 (30)
PRVDR_ORG_ID NUMBER (15)
RECVR_ORG_ID NUMBER

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)
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
MRC_RAW_REVENUE VARCHAR2 (0)
MRC_BILL_RATE VARCHAR2 (0)
MRC_ACCRUED_REVENUE VARCHAR2 (0)
MRC_ACCRUAL_RATE VARCHAR2 (0)
MRC_ADJUSTED_REVENUE VARCHAR2 (0)
MRC_ADJUSTED_RATE VARCHAR2 (0)
MRC_BILL_AMOUNT VARCHAR2 (0)
MRC_FORECAST_REVENUE VARCHAR2 (0)
MRC_ACCT_CURRENCY_CODE VARCHAR2 (0)
MRC_ACCT_RATE_DATE VARCHAR2 (0)
MRC_ACCT_RATE_TYPE VARCHAR2 (0)
MRC_ACCT_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_RAW_COST VARCHAR2 (0)
MRC_ACCT_BURDENED_COST VARCHAR2 (0)
MRC_REVENUE_RATE_TYPE VARCHAR2 (0)
MRC_REVENUE_CONVERSION_DATE VARCHAR2 (0)
MRC_REVENUE_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_TP_RATE_TYPE VARCHAR2 (0)
MRC_ACCT_TP_RATE_DATE VARCHAR2 (0)
MRC_ACCT_TP_EXCHANGE_RATE VARCHAR2 (0)
MRC_ACCT_TRANSFER_PRICE VARCHAR2 (0)
MRC_PROJFUNC_INV_RATE_TYPE VARCHAR2 (0)
MRC_PROJFUNC_INV_RATE_DATE VARCHAR2 (0)
MRC_PROJFUNC_INV_EXCHANGE_RATE VARCHAR2 (0)
MRC_PROJFUNC_FCST_RATE_TYPE VARCHAR2 (0)
MRC_PROJFUNC_FCST_RATE_DATE VARCHAR2 (0)
MRC_PROJFUNC_FCST_XCHANGE_RATE VARCHAR2 (0)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_LINE_NUMBER NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
DOCUMENT_PAYMENT_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_TYPE
,      PROJECT_TYPE_CLASS_CODE
,      PROJECT_CLASS
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      INCURRED_BY_PERSON_ID
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      JOB_ID
,      JOB_NAME
,      INCURRED_BY_ORGANIZATION_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
,      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
,      EXPENDITURE_STATUS_M
,      EXPENDITURE_ENDING_DATE
,      QUANTITY
,      BURDEN_COST
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_M
,      RAW_COST
,      RAW_COST_RATE
,      COST_DISTRIBUTED_FLAG
,      COST_DIST_REJECTION_CODE
,      LABOR_COST_MULTIPLIER_NAME
,      BURDENED_COST
,      BURDENED_COST_RATE
,      COST_BURDEN_DISTRIBUTED_FLAG
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      ACCT_CURRENCY_CODE
,      ACCT_RATE_TYPE
,      ACCT_RATE_DATE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      IND_COST_DIST_REJECTION_CODE
,      COST_IND_COMPILED_SET_ID
,      CAPITALIZABLE_FLAG
,      ACCRUED_REVENUE
,      ACCRUAL_RATE
,      RAW_REVENUE
,      FORECAST_REVENUE
,      BILL_AMOUNT
,      BILL_RATE
,      BILL_RATE_MULTIPLIER
,      ADJUSTED_REVENUE
,      ADJUSTED_RATE
,      BILLABLE_FLAG
,      REVENUE_DISTRIBUTED_FLAG
,      BILL_HOLD_FLAG
,      REV_DIST_REJECTION_CODE
,      BILL_JOB_ID
,      BILL_JOB_BILLING_TITLE
,      BILL_EMPLOYEE_BILLING_TITLE
,      REV_IND_COMPILED_SET_ID
,      INV_IND_COMPILED_SET_ID
,      EVENT_PROJECT_ID
,      EVENT_NUM
,      EVENT_TASK_ID
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      CONVERTED_FLAG
,      SOURCE_EXPENDITURE_ITEM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      EXPENDITURE_ORG_ID
,      SYSTEM_REFERENCE2
,      ORG_ID
,      USER_TRANSACTION_SOURCE
,      ALLOW_ADJUSTMENTS_FLAG
,      COSTED_FLAG
,      COST_BURDENED_FLAG
,      GL_ACCOUNTED_FLAG
,      ALLOW_REVERSAL_FLAG
,      ALLOW_BURDEN_FLAG
,      BURDEN_SUM_DEST_RUN_ID
,      BURDEN_SUM_REJECTION_CODE
,      BURDEN_SUM_REJECTION_M
,      PROJECT_STATUS_CODE
,      USER_ACCT_RATE_TYPE
,      USER_PROJECT_RATE_TYPE
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_USER_EXP_TXN_REFERENCE
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      OVERRIDING_APPROVER_PERSON_ID
,      WF_STATUS_CODE
,      TRANSFER_STATUS_CODE
,      USER_BATCH_NAME
,      BILL_TRANS_CURRENCY_CODE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BILL_AMOUNT
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      ASSIGNMENT_ID
,      WORK_TYPE_ID
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      TP_AMT_TYPE_CODE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
,      PROJFUNC_TRANSFER_PRICE
,      BILL_TRANS_BILL_AMOUNT
,      PRVDR_ACCRUAL_DATE
,      RECVR_ACCRUAL_DATE
,      CC_CROSS_CHARGE_CODE
,      CC_CROSS_CHARGE_TYPE
,      CC_BL_DISTRIBUTED_CODE
,      CC_IC_PROCESSED_CODE
,      CC_REJECTION_CODE
,      PRVDR_ORG_ID
,      RECVR_ORG_ID
,      ACCT_TP_RATE_TYPE
,      USER_ACCT_TP_RATE_TYPE
,      ACCT_TP_RATE_DATE
,      ACCT_TP_EXCHANGE_RATE
,      USER_PROJFUNC_COST_RATE_TYPE
,      DENOM_TP_CURRENCY_CODE
,      MRC_RAW_REVENUE
,      MRC_BILL_RATE
,      MRC_ACCRUED_REVENUE
,      MRC_ACCRUAL_RATE
,      MRC_ADJUSTED_REVENUE
,      MRC_ADJUSTED_RATE
,      MRC_BILL_AMOUNT
,      MRC_FORECAST_REVENUE
,      MRC_ACCT_CURRENCY_CODE
,      MRC_ACCT_RATE_DATE
,      MRC_ACCT_RATE_TYPE
,      MRC_ACCT_EXCHANGE_RATE
,      MRC_ACCT_RAW_COST
,      MRC_ACCT_BURDENED_COST
,      MRC_REVENUE_RATE_TYPE
,      MRC_REVENUE_CONVERSION_DATE
,      MRC_REVENUE_EXCHANGE_RATE
,      MRC_ACCT_TP_RATE_TYPE
,      MRC_ACCT_TP_RATE_DATE
,      MRC_ACCT_TP_EXCHANGE_RATE
,      MRC_ACCT_TRANSFER_PRICE
,      MRC_PROJFUNC_INV_RATE_TYPE
,      MRC_PROJFUNC_INV_RATE_DATE
,      MRC_PROJFUNC_INV_EXCHANGE_RATE
,      MRC_PROJFUNC_FCST_RATE_TYPE
,      MRC_PROJFUNC_FCST_RATE_DATE
,      MRC_PROJFUNC_FCST_XCHANGE_RATE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      DOCUMENT_PAYMENT_ID
FROM APPS.PA_EXPEND_ITEMS_ADJUST_V;

Dependencies

[top of page]

APPS.PA_EXPEND_ITEMS_ADJUST_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
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_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_COMMENTS
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_EXPENDITURE_TYPES
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_TYPES
SynonymPA_SYSTEM_LINKAGES
SynonymPA_TASKS
SynonymPA_TRANSACTION_SOURCES
SynonymPER_JOBS
ViewPER_PEOPLE_F
ViewPO_VENDORS
APPS.PA_EXPEND_ITEMS_ADJUST_V is referenced by following:

SchemaAPPS
ViewPA_ASSET_LINE_DETAILS_V
ViewPA_CUST_REV_DIST_LINES_V
ViewPA_DRAFT_INV_LINE_DETAILS_V