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

TABLE: AP.AP_MRC_INQ_INVOICE_DISTS

Object Details
Object Name: AP_MRC_INQ_INVOICE_DISTS
Object Type: TABLE
Owner: AP
Subobject Name:
Status: VALID

Temporary Table Details

AP.AP_MRC_INQ_INVOICE_DISTS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER

INVOICE_DISTRIBUTION_ID NUMBER

INVOICE_CURRENCY_CODE VARCHAR2 (3)
AMOUNT NUMBER

LINE_TYPE_LOOKUP_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (200)
BASE_AMOUNT_0 NUMBER

BASE_AMOUNT_1 NUMBER

BASE_AMOUNT_2 NUMBER

BASE_AMOUNT_3 NUMBER

BASE_AMOUNT_4 NUMBER

BASE_AMOUNT_5 NUMBER

BASE_AMOUNT_6 NUMBER

BASE_AMOUNT_7 NUMBER

BASE_AMOUNT_8 NUMBER

BASE_CURR_0 VARCHAR2 (3)
BASE_CURR_1 VARCHAR2 (3)
BASE_CURR_2 VARCHAR2 (3)
BASE_CURR_3 VARCHAR2 (3)
BASE_CURR_4 VARCHAR2 (3)
BASE_CURR_5 VARCHAR2 (3)
BASE_CURR_6 VARCHAR2 (3)
BASE_CURR_7 VARCHAR2 (3)
BASE_CURR_8 VARCHAR2 (3)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_CURRENCY_CODE
,      AMOUNT
,      LINE_TYPE_LOOKUP_CODE
,      DESCRIPTION
,      BASE_AMOUNT_0
,      BASE_AMOUNT_1
,      BASE_AMOUNT_2
,      BASE_AMOUNT_3
,      BASE_AMOUNT_4
,      BASE_AMOUNT_5
,      BASE_AMOUNT_6
,      BASE_AMOUNT_7
,      BASE_AMOUNT_8
,      BASE_CURR_0
,      BASE_CURR_1
,      BASE_CURR_2
,      BASE_CURR_3
,      BASE_CURR_4
,      BASE_CURR_5
,      BASE_CURR_6
,      BASE_CURR_7
,      BASE_CURR_8
FROM AP.AP_MRC_INQ_INVOICE_DISTS;

Dependencies

[top of page]

AP.AP_MRC_INQ_INVOICE_DISTS does not reference any database object

AP.AP_MRC_INQ_INVOICE_DISTS is referenced by following:

SchemaAPPS
SynonymAP_MRC_INQ_INVOICE_DISTS