eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IBY_EXT_FD_INS_1_0_V

Object Details

Object Name:	IBY_EXT_FD_INS_1_0_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBY.IBY_EXT_FD_INS_1_0_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYMENT_INSTRUCTION_ID	NUMBER	(15)	Yes
INSTRUCTION_CREATED_DATE	DATE		Yes
PAYMENT_INSTRUCTION_STATUS	VARCHAR2	(30)	Yes
INSTRUCTION_STATUS_MEANING	VARCHAR2	(80)	Yes	QuickCode meaning
PROCESSING_TYPE	VARCHAR2	(30)	Yes
PAY_ADMIN_ASSIGNED_REF_CODE	VARCHAR2	(255)
BANK_ASSIGNED_REF_CODE	VARCHAR2	(30)
PERIODIC_SEQUENCE_NAME_1	VARCHAR2	(80)
LAST_USED_NUMBER_1	NUMBER	(15)
PERIODIC_SEQUENCE_NAME_2	VARCHAR2	(80)
LAST_USED_NUMBER_2	NUMBER	(15)
PERIODIC_SEQUENCE_NAME_3	VARCHAR2	(80)
LAST_USED_NUMBER_3	NUMBER	(15)
BANK_INSTRUCTION1_CODE	VARCHAR2	(30)
BANK_INSTRUCTION1_MEANING	VARCHAR2	(80)
BANK_INSTRUCTION1_FORMAT_VALUE	VARCHAR2	(80)
BANK_INSTRUCTION2_CODE	VARCHAR2	(30)
BANK_INSTRUCTION2_MEANING	VARCHAR2	(80)
BANK_INSTRUCTION2_FORMAT_VALUE	VARCHAR2	(80)
BANK_INSTRUCTION_DETAILS	VARCHAR2	(255)
PAYMENT_TEXT_MESSAGE1	VARCHAR2	(150)
PAYMENT_TEXT_MESSAGE2	VARCHAR2	(150)
DECLARATION_OPTION	VARCHAR2	(30)
BEP_ACCOUNT_NAME	VARCHAR2	(80)
BEP_ACCOUNT_ID	NUMBER	(15)
PAYSYS_ACCT_ATTR_CAT	VARCHAR2	(150)
COMMENTS	VARCHAR2	(240)
PI_ATTR_CAT	VARCHAR2	(150)
PAYMENT_PROFILE_ID	NUMBER	(15)
SYSTEM_PROFILE_CODE	VARCHAR2	(100)	Yes
PAYMENT_PROFILE_NAME	VARCHAR2	(100)
LOGICAL_GROUPING_MODE	VARCHAR2	(50)		Specifies the grouping mode of the payment process profile
BATCH_BOOKING_FLAG	VARCHAR2	(1)		Specifies whether the bank will send statement based on payment/group
PAYMENT_PROFILE_ATTR_CAT	VARCHAR2	(150)
PAYMENT_FORMAT_CODE	VARCHAR2	(30)	Yes
PAYMENT_FORMAT_NAME	VARCHAR2	(300)	Yes
PAYMENT_FORMAT_ATTR_CAT	VARCHAR2	(150)
PAYER_INSTRUMENT_COUNT	NUMBER
PAYMENT_COUNT	NUMBER	(15)	Yes
PAYMENT_DATE	DATE
PAYMENT_CURRENCY_CODE	VARCHAR2	(10)
PAYMENT_SERVICE_REQUEST_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ORG_TYPE	VARCHAR2	(30)
ORG_TYPE_MEANING	VARCHAR2	(80)
ORG_NAME	VARCHAR2	(240)
PAYMENT_REASON_CODE	VARCHAR2	(30)
PAY_REASON_MEANING	VARCHAR2	(80)
PAY_REASON_FORMAT_VALUE	VARCHAR2	(80)
PAYMENT_REASON_COMMENTS	VARCHAR2	(240)
GROUP_BY_PAYMENT_DATE	VARCHAR2	(1)
GROUP_BY_PAYMENT_CURRENCY	VARCHAR2	(1)
GROUP_BY_PAY_SERVICE_REQUEST	VARCHAR2	(1)
GROUP_BY_LEGAL_ENTITY	VARCHAR2	(1)
GROUP_BY_ORGANIZATION	VARCHAR2	(1)
GROUP_BY_PAYMENT_REASON	VARCHAR2	(1)
LEGAL_ENTITY_ID	NUMBER	(15)
GROUP_BY_INTERNAL_BANK_ACCOUNT	VARCHAR2	(1)
GROUP_BY_PAYMENT_FUNCTION	VARCHAR2	(1)
GROUP_BY_RFC	VARCHAR2	(1)
GROUP_BY_PAYMENT_METHOD	VARCHAR2	(1)		Specifies whether payments must be grouped by payment method to form instruction
INTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
PAYMENT_FUNCTION	VARCHAR2	(30)
PAYMENT_FUNCTION_MEANING	VARCHAR2	(80)
RFC_IDENTIFIER	VARCHAR2	(30)
PAYMENT_METHOD_CODE	VARCHAR2	(50)		Code of the payment method of the payment instruction
PROCESS_TYPE	VARCHAR2	(30)	Yes
TOTAL_PMT_AMOUNT	NUMBER
MOAC_DATA_BLOCKED_FLAG	VARCHAR2	(1)
PAYMENT_DOCUMENT_NAME	VARCHAR2	(100)
PAPER_STOCK_TYPE	VARCHAR2	(30)
PAPER_STOCK_TYPE_MEANING	VARCHAR2	(80)
CARD_ISSUER_FILE_SEQ_NO	NUMBER

Query Text

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


SELECT PAYMENT_INSTRUCTION_ID
,      INSTRUCTION_CREATED_DATE
,      PAYMENT_INSTRUCTION_STATUS
,      INSTRUCTION_STATUS_MEANING
,      PROCESSING_TYPE
,      PAY_ADMIN_ASSIGNED_REF_CODE
,      BANK_ASSIGNED_REF_CODE
,      PERIODIC_SEQUENCE_NAME_1
,      LAST_USED_NUMBER_1
,      PERIODIC_SEQUENCE_NAME_2
,      LAST_USED_NUMBER_2
,      PERIODIC_SEQUENCE_NAME_3
,      LAST_USED_NUMBER_3
,      BANK_INSTRUCTION1_CODE
,      BANK_INSTRUCTION1_MEANING
,      BANK_INSTRUCTION1_FORMAT_VALUE
,      BANK_INSTRUCTION2_CODE
,      BANK_INSTRUCTION2_MEANING
,      BANK_INSTRUCTION2_FORMAT_VALUE
,      BANK_INSTRUCTION_DETAILS
,      PAYMENT_TEXT_MESSAGE1
,      PAYMENT_TEXT_MESSAGE2
,      DECLARATION_OPTION
,      BEP_ACCOUNT_NAME
,      BEP_ACCOUNT_ID
,      PAYSYS_ACCT_ATTR_CAT
,      COMMENTS
,      PI_ATTR_CAT
,      PAYMENT_PROFILE_ID
,      SYSTEM_PROFILE_CODE
,      PAYMENT_PROFILE_NAME
,      LOGICAL_GROUPING_MODE
,      BATCH_BOOKING_FLAG
,      PAYMENT_PROFILE_ATTR_CAT
,      PAYMENT_FORMAT_CODE
,      PAYMENT_FORMAT_NAME
,      PAYMENT_FORMAT_ATTR_CAT
,      PAYER_INSTRUMENT_COUNT
,      PAYMENT_COUNT
,      PAYMENT_DATE
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_SERVICE_REQUEST_ID
,      ORG_ID
,      ORG_TYPE
,      ORG_TYPE_MEANING
,      ORG_NAME
,      PAYMENT_REASON_CODE
,      PAY_REASON_MEANING
,      PAY_REASON_FORMAT_VALUE
,      PAYMENT_REASON_COMMENTS
,      GROUP_BY_PAYMENT_DATE
,      GROUP_BY_PAYMENT_CURRENCY
,      GROUP_BY_PAY_SERVICE_REQUEST
,      GROUP_BY_LEGAL_ENTITY
,      GROUP_BY_ORGANIZATION
,      GROUP_BY_PAYMENT_REASON
,      LEGAL_ENTITY_ID
,      GROUP_BY_INTERNAL_BANK_ACCOUNT
,      GROUP_BY_PAYMENT_FUNCTION
,      GROUP_BY_RFC
,      GROUP_BY_PAYMENT_METHOD
,      INTERNAL_BANK_ACCOUNT_ID
,      PAYMENT_FUNCTION
,      PAYMENT_FUNCTION_MEANING
,      RFC_IDENTIFIER
,      PAYMENT_METHOD_CODE
,      PROCESS_TYPE
,      TOTAL_PMT_AMOUNT
,      MOAC_DATA_BLOCKED_FLAG
,      PAYMENT_DOCUMENT_NAME
,      PAPER_STOCK_TYPE
,      PAPER_STOCK_TYPE_MEANING
,      CARD_ISSUER_FILE_SEQ_NO
FROM APPS.IBY_EXT_FD_INS_1_0_V;

Dependencies

[top of page]

APPS.IBY_EXT_FD_INS_1_0_V references the following:

APPS: CE_LOOKUPS; CE_PAYMENT_DOCUMENTS; CE_SECURITY_PROFILES_GT; FND_GLOBAL - show dependent code; FND_LOOKUPS; IBY_BANK_INSTRUCTIONS_VL; IBY_BEPKEYS; IBY_FD_EXTRACT_GEN_PVT - show dependent code; IBY_FD_POST_PICP_PROGS_PVT - show dependent code; IBY_FORMATS_VL; IBY_INSTR_CREATION_RULES; IBY_PAYMENT_PROFILES; IBY_PAYMENT_REASONS_VL; IBY_PAY_INSTRUCTIONS_ALL

APPS.IBY_EXT_FD_INS_1_0_V is referenced by following:

APPS: IBY_FD_EXTRACT_GEN_PVT - show dependent code; IBY_XML_FD_INS_1_0_V; IBY_XML_FD_INS_1_0_V0