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


VIEW: APPS.IGF_GR_RFMS_DISB

Object Details
Object Name: IGF_GR_RFMS_DISB
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_GR_RFMS_DISB
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RFMD_ID NUMBER (15) Yes
ORIGINATION_ID VARCHAR2 (30) Yes
DISB_REF_NUM VARCHAR2 (30) Yes
DISB_DT DATE

DISB_AMT NUMBER (12) Yes
DB_CR_FLAG VARCHAR2 (1) Yes
DISB_ACK_ACT_STATUS VARCHAR2 (1)
DISB_STATUS_DT DATE

ACCPT_DISB_DT DATE

DISB_ACCPT_AMT NUMBER (12)
ACCPT_DB_CR_FLAG VARCHAR2 (1)
DISB_YTD_AMT NUMBER (12)
PYMT_PRD_START_DT DATE

ACCPT_PYMT_PRD_START_DT DATE

EDIT_CODE VARCHAR2 (75)
RFMB_ID NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
ORG_ID NUMBER (15)
ED_USE_FLAGS VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      RFMD_ID
,      ORIGINATION_ID
,      DISB_REF_NUM
,      DISB_DT
,      DISB_AMT
,      DB_CR_FLAG
,      DISB_ACK_ACT_STATUS
,      DISB_STATUS_DT
,      ACCPT_DISB_DT
,      DISB_ACCPT_AMT
,      ACCPT_DB_CR_FLAG
,      DISB_YTD_AMT
,      PYMT_PRD_START_DT
,      ACCPT_PYMT_PRD_START_DT
,      EDIT_CODE
,      RFMB_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
,      ED_USE_FLAGS
FROM APPS.IGF_GR_RFMS_DISB;

Dependencies

[top of page]

APPS.IGF_GR_RFMS_DISB references the following:

SchemaAPPS
SynonymIGF_GR_RFMS_DISB_ALL
APPS.IGF_GR_RFMS_DISB is referenced by following:

SchemaAPPS
Package BodyIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_DB_DISB - show dependent code
Package BodyIGF_GR_GEN - show dependent code
Package BodyIGF_GR_LI_IMPORT - show dependent code
Package BodyIGF_GR_PELL - show dependent code
Package BodyIGF_GR_REPACKAGE - show dependent code
Package BodyIGF_GR_RFMS_DISB_ORIG - show dependent code
ViewIGF_GR_RFMS_DISB_V
Package BodyIGF_GR_RFMS_ORIG - show dependent code