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

TABLE: FII.FII_AR_RECAPP_MERGE_GT

Object Details
Object Name: FII_AR_RECAPP_MERGE_GT
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_RECAPP_MERGE_GT
Subobject Name:
Status: VALID

Temporary Table Details

FII.FII_AR_RECAPP_MERGE_GT 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
RECEIVABLE_APPLICATION_ID NUMBER (15)
TIME_ID NUMBER (15)
CASH_RECEIPT_ID NUMBER (15)
APPLICATION_STATUS VARCHAR2 (30)
HEADER_STATUS VARCHAR2 (30)
AMOUNT_APPLIED_RCT NUMBER

AMOUNT_APPLIED_TRX NUMBER

AMOUNT_APPLIED_RCT_FUNC NUMBER

AMOUNT_APPLIED_TRX_FUNC NUMBER

AMOUNT_APPLIED_RCT_PRIM NUMBER

AMOUNT_APPLIED_TRX_PRIM NUMBER

AMOUNT_APPLIED_RCT_SEC NUMBER

AMOUNT_APPLIED_TRX_SEC NUMBER

EARNED_DISCOUNT_AMOUNT_TRX NUMBER

EARNED_DISCOUNT_AMOUNT_FUNC NUMBER

EARNED_DISCOUNT_AMOUNT_PRIM NUMBER

EARNED_DISCOUNT_AMOUNT_SEC NUMBER

UNEARNED_DISCOUNT_AMOUNT_TRX NUMBER

UNEARNED_DISCOUNT_AMOUNT_FUNC NUMBER

UNEARNED_DISCOUNT_AMOUNT_PRIM NUMBER

UNEARNED_DISCOUNT_AMOUNT_SEC NUMBER

APPLY_DATE DATE

GL_DATE DATE

FILTER_DATE DATE

HEADER_FILTER_DATE DATE

APPLICATION_TYPE VARCHAR2 (20)
APPLIED_PAYMENT_SCHEDULE_ID NUMBER (15)
APPLIED_CUSTOMER_TRX_ID NUMBER (15)
CUSTOMER_TRX_ID NUMBER (15)
PAYMENT_SCHEDULE_ID NUMBER (15)
RECEIPT_NUMBER VARCHAR2 (30)
RECEIPT_TYPE VARCHAR2 (20)
RECEIPT_DATE DATE

RCT_ACTUAL_DATE_CLOSED DATE

RECEIPT_METHOD_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15)
USER_ID NUMBER (15)
AR_CREATION_DATE DATE

BILL_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
COLLECTOR_BILL_TO_CUSTOMER_ID NUMBER (15)
COLLECTOR_BILL_TO_SITE_USE_ID NUMBER (15)
ORG_ID NUMBER (15)
TRX_DATE DATE

DUE_DATE DATE

CM_PREVIOUS_CUSTOMER_TRX_ID NUMBER

TOTAL_RECEIPT_COUNT NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
TRXSCH_PAYMENT_SCHEDULE_ID NUMBER (15)
Query Text

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


SELECT RECEIVABLE_APPLICATION_ID
,      TIME_ID
,      CASH_RECEIPT_ID
,      APPLICATION_STATUS
,      HEADER_STATUS
,      AMOUNT_APPLIED_RCT
,      AMOUNT_APPLIED_TRX
,      AMOUNT_APPLIED_RCT_FUNC
,      AMOUNT_APPLIED_TRX_FUNC
,      AMOUNT_APPLIED_RCT_PRIM
,      AMOUNT_APPLIED_TRX_PRIM
,      AMOUNT_APPLIED_RCT_SEC
,      AMOUNT_APPLIED_TRX_SEC
,      EARNED_DISCOUNT_AMOUNT_TRX
,      EARNED_DISCOUNT_AMOUNT_FUNC
,      EARNED_DISCOUNT_AMOUNT_PRIM
,      EARNED_DISCOUNT_AMOUNT_SEC
,      UNEARNED_DISCOUNT_AMOUNT_TRX
,      UNEARNED_DISCOUNT_AMOUNT_FUNC
,      UNEARNED_DISCOUNT_AMOUNT_PRIM
,      UNEARNED_DISCOUNT_AMOUNT_SEC
,      APPLY_DATE
,      GL_DATE
,      FILTER_DATE
,      HEADER_FILTER_DATE
,      APPLICATION_TYPE
,      APPLIED_PAYMENT_SCHEDULE_ID
,      APPLIED_CUSTOMER_TRX_ID
,      CUSTOMER_TRX_ID
,      PAYMENT_SCHEDULE_ID
,      RECEIPT_NUMBER
,      RECEIPT_TYPE
,      RECEIPT_DATE
,      RCT_ACTUAL_DATE_CLOSED
,      RECEIPT_METHOD_ID
,      CURRENCY_CODE
,      USER_ID
,      AR_CREATION_DATE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      COLLECTOR_BILL_TO_CUSTOMER_ID
,      COLLECTOR_BILL_TO_SITE_USE_ID
,      ORG_ID
,      TRX_DATE
,      DUE_DATE
,      CM_PREVIOUS_CUSTOMER_TRX_ID
,      TOTAL_RECEIPT_COUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRXSCH_PAYMENT_SCHEDULE_ID
FROM FII.FII_AR_RECAPP_MERGE_GT;

Dependencies

[top of page]

FII.FII_AR_RECAPP_MERGE_GT does not reference any database object

FII.FII_AR_RECAPP_MERGE_GT is referenced by following:

SchemaAPPS
SynonymFII_AR_RECAPP_MERGE_GT