DBA Data[Home] [Help] [Dependency Information]

TABLE: IGI.IGI_PO_TRAN_TEMP

Object Details
Object Name: IGI_PO_TRAN_TEMP
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.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.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

IGI.IGI_PO_TRAN_TEMP does not reference any database object

IGI.IGI_PO_TRAN_TEMP is referenced by following:

SchemaIGI
ViewIGI_PO_TRAN_TEMP#