[Home] [Help] [Dependency Information]
Object Name: | CM_APCM_MST_EFC# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_LINE_NO | NUMBER | Yes | ||
POLINE_ID | NUMBER | Yes | ||
AQUI_COST_ID | NUMBER | Yes | ||
LINE_TYPE | NUMBER | Yes | ||
INVOICE_NO | VARCHAR2 | (50) | Yes | |
INVOICE_BASE_AMOUNT | NUMBER | Yes | ||
PO_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | Yes | ||
UNIT_BASE_PRICE | NUMBER | Yes | ||
SET_OF_BOOKS_ID | NUMBER | Yes | ||
BASE_CURRENCY | VARCHAR2 | (4) | Yes | |
EXCHANGE_RATE | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_LINE_NO
, POLINE_ID
, AQUI_COST_ID
, LINE_TYPE
, INVOICE_NO
, INVOICE_BASE_AMOUNT
, PO_ID
, ITEM_ID
, UNIT_BASE_PRICE
, SET_OF_BOOKS_ID
, BASE_CURRENCY
, EXCHANGE_RATE
FROM GMF.CM_APCM_MST_EFC#;
|
|
|