[Home] [Help] [Dependency Information]
Object Name: | GMF_INVOICE_DISTRIBUTIONS# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISTRIBUTION_ID | NUMBER | Yes | ||
CALENDAR_CODE | VARCHAR2 | (4) | ||
PERIOD_CODE | VARCHAR2 | (4) | ||
COST_MTHD_CODE | VARCHAR2 | (4) | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | |
ITEM_ID | NUMBER | (10) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
COST_CMPNTCLS_ID | NUMBER | (10) | Yes | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Yes | |
QUANTITY_INVOICED | NUMBER | |||
QUANTITY_COSTED | NUMBER | |||
TOTAL_QUANTITY | NUMBER | |||
UNIT_BASE_PRICE | NUMBER | |||
QUANTITY_UOM | VARCHAR2 | (25) | ||
BASE_IPV_AMOUNT | NUMBER | |||
IPV_AMOUNT | NUMBER | |||
BASE_IPV_ADJ_AMOUNT | NUMBER | |||
IPV_ADJ_AMOUNT | NUMBER | |||
ACCOUNTED_DATE | DATE | |||
OUT_OF_PERIOD_IND | NUMBER | (1) | ||
GL_POSTED_IND | NUMBER | (1) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
BASE_ERV_ADJ_AMOUNT | NUMBER | |||
BASE_ERV_AMOUNT | NUMBER | |||
ERV_ADJ_AMOUNT | NUMBER | |||
ERV_AMOUNT | NUMBER | |||
INVOICE_VARIANCE_TYPE | NUMBER | (1) | ||
PERIOD_ID | NUMBER | (15) | ||
COST_TYPE_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
FINAL_POSTING_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_ID
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, INVOICE_DISTRIBUTION_ID
, ITEM_ID
, WHSE_CODE
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, QUANTITY_INVOICED
, QUANTITY_COSTED
, TOTAL_QUANTITY
, UNIT_BASE_PRICE
, QUANTITY_UOM
, BASE_IPV_AMOUNT
, IPV_AMOUNT
, BASE_IPV_ADJ_AMOUNT
, IPV_ADJ_AMOUNT
, ACCOUNTED_DATE
, OUT_OF_PERIOD_IND
, GL_POSTED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BASE_ERV_ADJ_AMOUNT
, BASE_ERV_AMOUNT
, ERV_ADJ_AMOUNT
, ERV_AMOUNT
, INVOICE_VARIANCE_TYPE
, PERIOD_ID
, COST_TYPE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, LEGAL_ENTITY_ID
, ACCOUNTED_FLAG
, FINAL_POSTING_DATE
FROM GMF.GMF_INVOICE_DISTRIBUTIONS#;
|
|
|