[Home] [Help] [Dependency Information]

TABLE: FII.EDW_AP_PAYMENT_M_TEMP

Object Details

Temporary Table Details

FII.EDW_AP_PAYMENT_M_TEMP 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:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT PPYT_PAYMENT_PK_KEY
,      PPYT_INVOICE_PAYMENT_ID
,      PMTH_PAYMENT_METHOD_PK_KEY
,      PCHK_CHECK_ID
,      PCHK_CHECK_PK_KEY
,      A_ALL_PK_KEY
,      PPYT_USER_ATTRIBUTE5
,      PPYT_USER_ATTRIBUTE4
,      PPYT_USER_ATTRIBUTE3
,      PPYT_USER_ATTRIBUTE2
,      PPYT_USER_ATTRIBUTE1
,      PPYT_PAYMENT_DP
,      PPYT_PAYMENT
,      PPYT_NAME
,      PPYT_PAYMENT_PK
,      PMTH_USER_ATTRIBUTE5
,      PMTH_USER_ATTRIBUTE4
,      PMTH_USER_ATTRIBUTE3
,      PMTH_USER_ATTRIBUTE2
,      PMTH_USER_ATTRIBUTE1
,      PMTH_PAYMENT_METHOD_PK
,      PMTH_PAYMENT_METHOD_DP
,      PMTH_PAYMENT_METHOD
,      PMTH_NAME
,      PMTH_DESCRIPTION
,      PCHK_USER_ATTRIBUTE5
,      PCHK_USER_ATTRIBUTE4
,      PCHK_USER_ATTRIBUTE3
,      PCHK_USER_ATTRIBUTE2
,      PCHK_USER_ATTRIBUTE1
,      PCHK_STATUS_LOOKUP_CODE
,      PCHK_NAME
,      PCHK_CHECK_PK
,      PCHK_CHECK_NAME
,      PCHK_CHECK_DP
,      PCHK_BANK_ACCOUNT_NAME
,      A_NAME
,      A_ALL_PK
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM FII.EDW_AP_PAYMENT_M_TEMP;

Dependencies

[top of page]

FII.EDW_AP_PAYMENT_M_TEMP does not reference any database object

FII.EDW_AP_PAYMENT_M_TEMP is referenced by following:

APPS

EDW_AP_PAYMENT_M_TEMP