[Home] [Help] [Dependency Information]
Object Name: | IGI_PO_TRAN_TEMP |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_PO_TRAN_TEMP |
Subobject Name: | |
Status: | VALID |
IGI_PO_TRAN_TEMP stores the temporary data used for GBV migration from 10.7/11.03 to 11i.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIST_ID | NUMBER | Distribution Identifier | ||
TAX_NAME | VARCHAR2 | (15) | Tax Name | |
TAX_ID | NUMBER | (15) | Tax Identifier | |
TAX_RATE | NUMBER | Tax Rate | ||
VAT_FACTOR | NUMBER | VAT Factor | ||
RECOVERY_RATE | NUMBER | Recovery rate | ||
RECOVERABLE_TAX | NUMBER | Recoverable Tax | ||
NON_RECOVERABLE_TAX | NUMBER | Non Recoverable Tax | ||
QUANTITY | NUMBER | Quantity | ||
PRICE | NUMBER | Price | ||
QUANTITY_BILLED | NUMBER | Quantity Billed | ||
AMOUNT_BILLED | NUMBER | Amount Billed | ||
FUNC_CURR_CODE | VARCHAR2 | (15) | Functional Currency | |
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DIST_ID
, TAX_NAME
, TAX_ID
, TAX_RATE
, VAT_FACTOR
, RECOVERY_RATE
, RECOVERABLE_TAX
, NON_RECOVERABLE_TAX
, QUANTITY
, PRICE
, QUANTITY_BILLED
, AMOUNT_BILLED
, FUNC_CURR_CODE
, ORG_ID
FROM IGI.IGI_PO_TRAN_TEMP;
IGI.IGI_PO_TRAN_TEMP does not reference any database object
IGI.IGI_PO_TRAN_TEMP is referenced by following:
|
|
|