[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMS_DRAFT_INVOICES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMS.GMS_DRAFT_INVOICES_V
|
| 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) | ||
| BILL_ANOTHER_PROJECT_FLAG | VARCHAR2 | (1) | ||
| CC_PRVDR_FLAG | VARCHAR2 | (1) | ||
| PROJECT_ROLE_TYPE | VARCHAR2 | (20) | Yes | |
| PERSON_ID | NUMBER | (15) | Yes |
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
, BILL_ANOTHER_PROJECT_FLAG
, CC_PRVDR_FLAG
, PROJECT_ROLE_TYPE
, PERSON_ID
FROM APPS.GMS_DRAFT_INVOICES_V;
APPS
FND_LANGUAGES
GL_SETS_OF_BOOKS
GMS_AWARDS
GMS_SECURITY
- show dependent code
HR_ALL_ORGANIZATION_UNITS
HZ_CUST_ACCOUNTS
HZ_CUST_SITE_USES
HZ_PARTIES
PA_AGREEMENTS_ALL
PA_CONVERSION_TYPES_V
PA_DISTRIBUTION_RULES
PA_DRAFT_INVOICES
PA_DRAFT_INVOICES_ALL
PA_DRAFT_INV_ITEMS_BAS
PA_IMPLEMENTATIONS_ALL
PA_LOOKUPS
PA_MULTI_CURRENCY
- show dependent code
PA_OUTPUT_TAX
- show dependent code
PA_PROJECTS_ALL
PA_PROJECT_CUSTOMERS
PA_PROJECT_PARTIES
PA_PROJECT_ROLE_TYPES_B
PA_PROJECT_STATUSES
PA_PROJECT_TYPES
PA_ROLE_CONTROLS
PA_SECURITY
- show dependent code
PER_ALL_PEOPLE_F
RA_TERMS
SYS
DUAL
APPS.GMS_DRAFT_INVOICES_V is not referenced by any database object
|
|
|
|