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

VIEW: APPS.GMS_DRAFT_INV_LINE_DETAILS_V

Object Details
Object Name: GMS_DRAFT_INV_LINE_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMS.GMS_DRAFT_INV_LINE_DETAILS_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)
LINE_NUM NUMBER (15)
PROJECT_ID NUMBER (15)
DRAFT_INVOICE_NUM NUMBER (15)
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
RAW_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
USER_PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_EXCHANGE_RATE NUMBER

DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
USER_ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

BILL_AMOUNT NUMBER (22)
LINE_NUM_REVERSED NUMBER

REVERSED_FLAG VARCHAR2 (0)
EXPENDITURE_ID NUMBER (15)
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 (15)
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
JOB_ID NUMBER (15)
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)
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

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN 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)
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 CHAR (7)
ACTUAL_PROJECT_NUMBER VARCHAR2 (25)
ACTUAL_PROJECT_NAME VARCHAR2 (30)
ACTUAL_PROJECT_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

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 (22)
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 (22)
FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_RATE_TYPE VARCHAR2 (30)
FUNDING_RATE_DATE DATE

FUNDING_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER (22)
PROJECT_RAW_COST NUMBER

PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_EXCHANGE_RATE NUMBER

IC_BILLING_PROJ_CURR_CODE CHAR (0)
IC_BILLING_PROJFUNC_CURR_CODE CHAR (0)
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 (15)
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 (15)
WORK_TYPE_ID NUMBER (15)
WORK_TYPE_NAME VARCHAR2 (4000)
TP_AMT_TYPE_CODE VARCHAR2 (30)
TRANSACTION_TYPE VARCHAR2 (80)
RATE_DISC_REASON_CODE CHAR (0)
Bill rate discount reason code
DISCOUNT_PERCENTAGE NUMBER

Discount percentage
PROJFUNC_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_BILL_AMOUNT_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
IC_PFC_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
RAW_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_RAW_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_BURDENED_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
ACCT_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
RETAINED_AMOUNT NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJECT_BURDEN_COST NUMBER

Burden Cost in Project currency
ORG_ID NUMBER (15)
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)
ALLOW_BURDEN_FLAG VARCHAR2 (1)
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
,      ACTUAL_PROJECT_NUMBER
,      ACTUAL_PROJECT_NAME
,      ACTUAL_PROJECT_ID
,      CREATED_BY
,      CREATION_DATE
,      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
,      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
,      PROJFUNC_CURRENCY_CODE_MRC
,      PROJFUNC_RATE_TYPE_MRC
,      PROJFUNC_RATE_DATE_MRC
,      PROJFUNC_EXCHANGE_RATE_MRC
,      PROJFUNC_BILL_AMOUNT_MRC
,      IC_PFC_CURRENCY_CODE_MRC
,      ACCT_TP_RATE_TYPE_MRC
,      ACCT_TP_RATE_DATE_MRC
,      ACCT_TP_EXCHANGE_RATE_MRC
,      RAW_COST_MRC
,      ACCT_RAW_COST_MRC
,      ACCT_BURDENED_COST_MRC
,      ACCT_CURRENCY_CODE_MRC
,      ACCT_RATE_DATE_MRC
,      ACCT_EXCHANGE_RATE_MRC
,      RETAINED_AMOUNT
,      ACCT_RATE_TYPE_MRC
,      PROJECT_BURDEN_COST
,      ORG_ID
,      DOCUMENT_HEADER_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      DOCUMENT_PAYMENT_ID
,      ALLOW_BURDEN_FLAG
FROM APPS.GMS_DRAFT_INV_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.GMS_DRAFT_INV_LINE_DETAILS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGMS_AWARD_DISTRIBUTIONS
SynonymGMS_BURDEN_COMPONENTS
SynonymGMS_EVENT_INTERSECT
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPA_CONVERSION_TYPES_V
SynonymPA_COST_DISTRIBUTION_LINES_ALL
SynonymPA_DRAFT_INVOICES
SynonymPA_DRAFT_INVOICE_ITEMS
SynonymPA_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_COMMENTS
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_EXPENDITURE_TYPES
ViewPA_LOOKUPS
SynonymPA_PROJECTS_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.GMS_DRAFT_INV_LINE_DETAILS_V is referenced by following:

SchemaAPPS
ViewGMS_1034_REPORT_V