[Home] [Help]
[Dependency Information]
Object Name: | GMS_DRAFT_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
AWARD_ID | NUMBER | (15) | Yes | |
AWARD_NUMBER | VARCHAR2 | (15) | Yes | |
AWARD_SHORT_NAME | VARCHAR2 | (30) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | |
PROJECT_NAME | VARCHAR2 | (30) | Yes | |
DISTRIBUTION_RULE | VARCHAR2 | (30) | ||
DISTRIBUTION_RULE_M | VARCHAR2 | (80) | Yes | |
PROJECT_TYPE | VARCHAR2 | (20) | Yes | |
PROJECT_STATUS_M | VARCHAR2 | (80) | Yes | |
PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | |
PROJECT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
PROJECT_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
CUSTOMER_ID | NUMBER | (15) | Yes | |
CUSTOMER_NAME | VARCHAR2 | (50) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | Yes | |
AGREEMENT_ID | NUMBER | (15) | Yes | |
AGREEMENT_NUM | VARCHAR2 | (50) | Yes | |
AGREEMENT_TYPE | VARCHAR2 | (30) | ||
TERM_ID | NUMBER | (15) | Yes | |
TERM_NAME | VARCHAR2 | (15) | Yes | |
DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | |
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | Yes | |
INVOICE_STATUS_CODE | VARCHAR2 | (30) | Yes | |
INVOICE_STATUS_M | VARCHAR2 | (80) | Yes | |
CHK_STATUS | VARCHAR2 | (11) | ||
BILL_THROUGH_DATE | DATE | |||
APPROVED_DATE | DATE | |||
APPROVED_BY_PERSON_ID | NUMBER | (9) | ||
APPROVED_BY_PERSON_NAME | VARCHAR2 | (240) | ||
APPROVED_BY_PERSON_NUMBER | VARCHAR2 | (30) | ||
RELEASED_DATE | DATE | |||
RELEASED_BY_PERSON_ID | NUMBER | (9) | ||
RELEASED_BY_PERSON_NAME | VARCHAR2 | (240) | ||
RELEASED_BY_PERSON_NUMBER | VARCHAR2 | (30) | ||
INVOICE_DATE | DATE | |||
RA_INVOICE_NUMBER | VARCHAR2 | (20) | ||
PA_DATE | DATE | |||
GL_DATE | DATE | |||
CREATION_DATE | DATE | Yes | ||
INVOICE_COMMENT | VARCHAR2 | (240) | ||
DRAFT_INVOICE_NUM_CREDITED | NUMBER | (15) | ||
CANCELED_FLAG | VARCHAR2 | (1) | ||
CANCEL_CREDIT_MEMO_FLAG | VARCHAR2 | (1) | ||
WRITE_OFF_FLAG | VARCHAR2 | (1) | ||
CONVERTED_FLAG | VARCHAR2 | (1) | ||
EXTRACTED_DATE | DATE | |||
RETENTION_PERCENTAGE | NUMBER | (15) | ||
RA_INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | ||
INV_RATE_TYPE | VARCHAR2 | (30) | ||
INV_RATE_DATE | DATE | |||
INV_EXCHANGE_RATE | NUMBER | |||
INV_USER_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
INVOICE_CLASS | VARCHAR2 | (80) | 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) | ||
GENERATION_ERROR_FLAG | VARCHAR2 | (1) | Yes | |
TRANSFERRED_DATE | DATE | |||
TRANSFER_REJECTION_REASON | VARCHAR2 | (250) | ||
EXCEPTION_FLAG | VARCHAR2 | (1) | ||
UNEARNED_REVENUE_CR | NUMBER | |||
UNBILLED_RECEIVABLE_DR | NUMBER | |||
SYSTEM_REFERENCE | NUMBER | (15) | ||
CUSTOMER_BILL_SPLIT | NUMBER | (7) | ||
INVOICE_SET_ID | NUMBER | (15) | ||
INVOICE_AMOUNT | NUMBER | |||
AMOUNT | NUMBER | |||
ORIGINAL_BALANCE | NUMBER | |||
BALANCE_DUE | NUMBER | |||
AMOUNT_APPLIED | VARCHAR2 | (0) | ||
AMOUNT_CREDITED | VARCHAR2 | (0) | ||
WRITE_OFF | VARCHAR2 | (0) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
BILL_TO_ADDRESS_ID | NUMBER | |||
SHIP_TO_ADDRESS_ID | NUMBER | |||
UPDATE_ALLOWED | VARCHAR2 | (4000) | ||
VIEW_LABOR_COSTS_ALLOWED | VARCHAR2 | (4000) | ||
RECEIVABLE_CODE_COMBINATION_ID | NUMBER | |||
ROUNDING_CODE_COMBINATION_ID | NUMBER | |||
UNBILLED_CODE_COMBINATION_ID | NUMBER | |||
UNEARNED_CODE_COMBINATION_ID | NUMBER | |||
WOFF_CODE_COMBINATION_ID | NUMBER | |||
RECV_INV_AMT | NUMBER | |||
ROUND_AMT | NUMBER | |||
LANGUAGE | VARCHAR2 | (30) | ||
NLS_LANGUAGE | VARCHAR2 | (30) | ||
ACCTD_CURR_CODE | VARCHAR2 | (15) | ||
ACCTD_RATE_TYPE | VARCHAR2 | (30) | ||
ACCTD_RATE_DATE | DATE | |||
ACCTD_EXCHG_RATE | NUMBER | |||
TAX_AMOUNT | NUMBER | |||
INVOICE_CATEGORY | VARCHAR2 | (23) | ||
INVOICE_BATCH_SOURCE_ID | NUMBER | (15) | ||
CC_IC_AR_BATCH_SOURCE_ID | NUMBER | (20) | ||
CC_PROJECT_ID | NUMBER | |||
IB_AP_TRANSFER_STATUS_CODE | VARCHAR2 | (1) | ||
IB_AP_TRANSFER_ERROR_CODE | VARCHAR2 | (80) | ||
UPDATE_ALLOW | VARCHAR2 | (1) | ||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_BILL_AMOUNT | NUMBER | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_BILL_AMOUNT | NUMBER | |||
PROJ_BILL_AMOUNT | NUMBER | |||
FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | ||
FUNDING_BILL_AMOUNT | NUMBER | |||
PROJFUNC_INVTRANS_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INVTRANS_RATE_TY_NAME | VARCHAR2 | (4000) | Exchange User rate type to use for conversion from project punctional currency to invoice transaction currency | |
PROJFUNC_INVTRANS_RATE_DATE | DATE | |||
PROJFUNC_INVTRANS_EX_RATE | NUMBER | |||
RETENTION_INVOICE_FLAG | VARCHAR2 | (1) | ||
RETN_CODE_COMBINATION_ID | NUMBER | Retention account code combination Id. This is generated based on the auto accounting rules | ||
CREDIT_MEMO_REASON_CODE | VARCHAR2 | (30) | Credit Memo Reason Code is used while releasing invoices of Credit memo invoice class | |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Customer Id of the Bill to Customer i.e LOC customer | |
SHIP_TO_CUSTOMER_ID | NUMBER | (15) | Customer Id of the ship to customer i.e Funding Source | |
BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number of the Bill to Customer i.e LOC Customer Number | |
BILL_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Customer Name of the Bill to Customer i.e LOC Customer Name | |
SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number of the Ship to Customer i.e Funding Souce Customer Number | |
SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (50) | Customer Name of the Ship to Customer i.e Funding Souce Customer Name | |
UNEARNED_REVENUE_CR_MRC | VARCHAR2 | (0) | Data associated with Multi Reporting Currecncy Schema Elimination | |
UNBILLED_RECEIVABLE_DR_MRC | VARCHAR2 | (0) | Data associated with Multi Reporting Currecncy Schema Elimination | |
PROJFUNC_CURRENCY_CODE_MRC | VARCHAR2 | (0) | Data associated with Multi Reporting Currecncy Schema Elimination | |
PROJFUNC_BILL_AMOUNT_MRC | VARCHAR2 | (0) | Data associated with Multi Reporting Currecncy Schema Elimination | |
CONCESSION_FLAG | VARCHAR2 | (1) | Indicates whether invoice is of type: Concession | |
RECORD_VERSION_NUMBER | NUMBER | |||
LAST_CREDIT_REQUEST_ID | NUMBER | |||
ENABLE_TOP_TASK_INV_MTH_FLAG | VARCHAR2 | (1) | ||
REVENUE_ACCRUAL_METHOD | VARCHAR2 | (30) | ||
INVOICE_METHOD | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | ||
REVENUE_ACCRUAL_METHOD_DISP | VARCHAR2 | (80) | Yes | |
INVOICE_METHOD_DISP | VARCHAR2 | (80) | Yes | |
BILL_TO_PARTY_ID | NUMBER | (15) | ||
SHIP_TO_PARTY_ID | NUMBER | (15) | ||
BILL_TO_SITE_USE_ID | NUMBER | (15) | ||
SHIP_TO_SITE_USE_ID | NUMBER | (15) | ||
CUSTOMER_ORDER_NUMBER | VARCHAR2 | (240) | ||
LINE_OF_ACCOUNT | VARCHAR2 | (240) | ||
PAYMENT_SET_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, AWARD_ID
, AWARD_NUMBER
, AWARD_SHORT_NAME
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, DISTRIBUTION_RULE
, DISTRIBUTION_RULE_M
, PROJECT_TYPE
, PROJECT_STATUS_M
, PROJECT_STATUS_CODE
, PROJECT_ORGANIZATION_ID
, PROJECT_ORGANIZATION_NAME
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, AGREEMENT_ID
, AGREEMENT_NUM
, AGREEMENT_TYPE
, TERM_ID
, TERM_NAME
, DRAFT_INVOICE_NUM
, TRANSFER_STATUS_CODE
, INVOICE_STATUS_CODE
, INVOICE_STATUS_M
, CHK_STATUS
, BILL_THROUGH_DATE
, APPROVED_DATE
, APPROVED_BY_PERSON_ID
, APPROVED_BY_PERSON_NAME
, APPROVED_BY_PERSON_NUMBER
, RELEASED_DATE
, RELEASED_BY_PERSON_ID
, RELEASED_BY_PERSON_NAME
, RELEASED_BY_PERSON_NUMBER
, INVOICE_DATE
, RA_INVOICE_NUMBER
, PA_DATE
, GL_DATE
, CREATION_DATE
, INVOICE_COMMENT
, DRAFT_INVOICE_NUM_CREDITED
, CANCELED_FLAG
, CANCEL_CREDIT_MEMO_FLAG
, WRITE_OFF_FLAG
, CONVERTED_FLAG
, EXTRACTED_DATE
, RETENTION_PERCENTAGE
, RA_INVOICE_CURRENCY_CODE
, INV_CURRENCY_CODE
, INV_RATE_TYPE
, INV_RATE_DATE
, INV_EXCHANGE_RATE
, INV_USER_RATE_TYPE
, PROJECT_CURRENCY_CODE
, INVOICE_CLASS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, GENERATION_ERROR_FLAG
, TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON
, EXCEPTION_FLAG
, UNEARNED_REVENUE_CR
, UNBILLED_RECEIVABLE_DR
, SYSTEM_REFERENCE
, CUSTOMER_BILL_SPLIT
, INVOICE_SET_ID
, INVOICE_AMOUNT
, AMOUNT
, ORIGINAL_BALANCE
, BALANCE_DUE
, AMOUNT_APPLIED
, AMOUNT_CREDITED
, WRITE_OFF
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BILL_TO_ADDRESS_ID
, SHIP_TO_ADDRESS_ID
, UPDATE_ALLOWED
, VIEW_LABOR_COSTS_ALLOWED
, RECEIVABLE_CODE_COMBINATION_ID
, ROUNDING_CODE_COMBINATION_ID
, UNBILLED_CODE_COMBINATION_ID
, UNEARNED_CODE_COMBINATION_ID
, WOFF_CODE_COMBINATION_ID
, RECV_INV_AMT
, ROUND_AMT
, LANGUAGE
, NLS_LANGUAGE
, ACCTD_CURR_CODE
, ACCTD_RATE_TYPE
, ACCTD_RATE_DATE
, ACCTD_EXCHG_RATE
, TAX_AMOUNT
, INVOICE_CATEGORY
, INVOICE_BATCH_SOURCE_ID
, CC_IC_AR_BATCH_SOURCE_ID
, CC_PROJECT_ID
, IB_AP_TRANSFER_STATUS_CODE
, IB_AP_TRANSFER_ERROR_CODE
, UPDATE_ALLOW
, INVPROC_CURRENCY_CODE
, INVPROC_BILL_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BILL_AMOUNT
, PROJ_BILL_AMOUNT
, FUNDING_CURRENCY_CODE
, FUNDING_BILL_AMOUNT
, PROJFUNC_INVTRANS_RATE_TYPE
, PROJFUNC_INVTRANS_RATE_TY_NAME
, PROJFUNC_INVTRANS_RATE_DATE
, PROJFUNC_INVTRANS_EX_RATE
, RETENTION_INVOICE_FLAG
, RETN_CODE_COMBINATION_ID
, CREDIT_MEMO_REASON_CODE
, BILL_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_ID
, BILL_TO_CUSTOMER_NUMBER
, BILL_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_NAME
, UNEARNED_REVENUE_CR_MRC
, UNBILLED_RECEIVABLE_DR_MRC
, PROJFUNC_CURRENCY_CODE_MRC
, PROJFUNC_BILL_AMOUNT_MRC
, CONCESSION_FLAG
, RECORD_VERSION_NUMBER
, LAST_CREDIT_REQUEST_ID
, ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD
, ORG_ID
, REVENUE_ACCRUAL_METHOD_DISP
, INVOICE_METHOD_DISP
, BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, CUSTOMER_ORDER_NUMBER
, LINE_OF_ACCOUNT
, PAYMENT_SET_ID
FROM APPS.GMS_DRAFT_INVOICES_V;
APPS.GMS_DRAFT_INVOICES_V is not referenced by any database object
|
|
|