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.PAY_ORG_PAYMENT_METHODS_F1_DFV

Object Details

Object Name:	PAY_ORG_PAYMENT_METHODS_F1_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
EMPLOYER_CODE	VARCHAR2	(150)
BANK_CODE	VARCHAR2	(150)
HEADER_FORMULA	VARCHAR2	(150)
BODY_FORMULA	VARCHAR2	(150)
FOOTER_FORMULA	VARCHAR2	(150)
PAYMENT_CODE	VARCHAR2	(150)
PAYMENT_DESCRIPTION	VARCHAR2	(150)
BACS_USER_NUMBER	VARCHAR2	(150)
BACS_LIMIT	NUMBER
BUREAU_NUMBER	VARCHAR2	(150)
BUREAU_NAME	VARCHAR2	(150)
SOURCE_BANK_CONTACT	VARCHAR2	(150)
SOURCE_CONTACT_TELEPHONE	VARCHAR2	(150)
TRANSACTION_LIMIT	NUMBER
CONTRA_NARRATIVE	VARCHAR2	(150)
DIRECT_DEPOSIT_NUMBER	VARCHAR2	(150)
NARRATIVE	VARCHAR2	(150)
FINANCIAL_INSTITUTION	VARCHAR2	(150)
ORIGINATOR_ID	VARCHAR2	(150)
ORIGINATOR_NAME	VARCHAR2	(150)
ORIGINATOR_SHORT_NAME	VARCHAR2	(150)
RETURN_INSTITUTION_ID	VARCHAR2	(150)
RETURN_ACCOUNT_NUMBER	VARCHAR2	(150)
CPA_CODE	VARCHAR2	(150)
DES_DATA_CENTRE_DUMMY	VARCHAR2	(150)
DESTINATION_DATA_CENTRE_CODE	VARCHAR2	(150)
CASH_ANALYSIS	VARCHAR2	(150)
THIRD_PARTY_PAY_TYPE	VARCHAR2	(150)
COMPANY_ID	VARCHAR2	(150)
DE_BANK_CODE	VARCHAR2	(150)
DE_USER_NUMBER	VARCHAR2	(150)
DE_USER_NAME	VARCHAR2	(150)
DE_FILE_DESCRIPTION	VARCHAR2	(150)
DE_DEBIT_ITEM_AUTHORITY	VARCHAR2	(150)
DE_INCLUDE_LEADING_ZEROES	VARCHAR2	(150)
DE_INDICATOR	VARCHAR2	(150)
DE_TRANSACTION_CODE	VARCHAR2	(150)
DE_EFT_FILE_SUMMARY	VARCHAR2	(150)
ACCOUNT_TYPE	VARCHAR2	(150)
COMPANY_CODE	VARCHAR2	(150)
COMPANY_NAME	VARCHAR2	(150)
OVERRIDING_ZENGIN_FORMATTER	VARCHAR2	(150)
CREDITOR_CODE	VARCHAR2	(150)
CREDITOR_NAME	VARCHAR2	(150)
SITE_CODE	VARCHAR2	(150)
SITE_NAME	VARCHAR2	(150)
GIRO_COMPANY_NAME	VARCHAR2	(150)
GIRO_COMPANY_CODE	VARCHAR2	(150)
CUSTOMER_ID	VARCHAR2	(150)
NACHA_DESTINATION_CODE	VARCHAR2	(150)
NACHA_DESTINATION_NAME	VARCHAR2	(150)
NACHA_ORIGIN_CODE	VARCHAR2	(150)
NACHA_ORIGIN_NAME	VARCHAR2	(150)
REFERENCE_CODE	VARCHAR2	(150)
BALANCED_NACHA_FILE	VARCHAR2	(150)
HEADER_LINE_1	VARCHAR2	(150)
HEADER_LINE_2	VARCHAR2	(150)
SENDER_ID	VARCHAR2	(150)
BATCH_DESCRIPTION	VARCHAR2	(150)
INSTRUCTING_PARTY_NAME	VARCHAR2	(150)
PAYMENT_FILE_MEDIUM	VARCHAR2	(150)
SUPRESS_PAYEE_ADDRESS	VARCHAR2	(150)
IDENTIFY_POST_BANK_NUMBERS	VARCHAR2	(150)
NAW_CODE	VARCHAR2	(150)
ENTERPRISE_NUMBER	NUMBER
DIVISION	VARCHAR2	(150)
AH_SEQUENCE_NUMBER	NUMBER
SEQUENCE_CONTROL	NUMBER
INVOICE_NUMBER	VARCHAR2	(150)
KID_NUMBER	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1389)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      EMPLOYER_CODE
,      BANK_CODE
,      HEADER_FORMULA
,      BODY_FORMULA
,      FOOTER_FORMULA
,      PAYMENT_CODE
,      PAYMENT_DESCRIPTION
,      BACS_USER_NUMBER
,      BACS_LIMIT
,      BUREAU_NUMBER
,      BUREAU_NAME
,      SOURCE_BANK_CONTACT
,      SOURCE_CONTACT_TELEPHONE
,      TRANSACTION_LIMIT
,      CONTRA_NARRATIVE
,      DIRECT_DEPOSIT_NUMBER
,      NARRATIVE
,      FINANCIAL_INSTITUTION
,      ORIGINATOR_ID
,      ORIGINATOR_NAME
,      ORIGINATOR_SHORT_NAME
,      RETURN_INSTITUTION_ID
,      RETURN_ACCOUNT_NUMBER
,      CPA_CODE
,      DES_DATA_CENTRE_DUMMY
,      DESTINATION_DATA_CENTRE_CODE
,      CASH_ANALYSIS
,      THIRD_PARTY_PAY_TYPE
,      COMPANY_ID
,      DE_BANK_CODE
,      DE_USER_NUMBER
,      DE_USER_NAME
,      DE_FILE_DESCRIPTION
,      DE_DEBIT_ITEM_AUTHORITY
,      DE_INCLUDE_LEADING_ZEROES
,      DE_INDICATOR
,      DE_TRANSACTION_CODE
,      DE_EFT_FILE_SUMMARY
,      ACCOUNT_TYPE
,      COMPANY_CODE
,      COMPANY_NAME
,      OVERRIDING_ZENGIN_FORMATTER
,      CREDITOR_CODE
,      CREDITOR_NAME
,      SITE_CODE
,      SITE_NAME
,      GIRO_COMPANY_NAME
,      GIRO_COMPANY_CODE
,      CUSTOMER_ID
,      NACHA_DESTINATION_CODE
,      NACHA_DESTINATION_NAME
,      NACHA_ORIGIN_CODE
,      NACHA_ORIGIN_NAME
,      REFERENCE_CODE
,      BALANCED_NACHA_FILE
,      HEADER_LINE_1
,      HEADER_LINE_2
,      SENDER_ID
,      BATCH_DESCRIPTION
,      INSTRUCTING_PARTY_NAME
,      PAYMENT_FILE_MEDIUM
,      SUPRESS_PAYEE_ADDRESS
,      IDENTIFY_POST_BANK_NUMBERS
,      NAW_CODE
,      ENTERPRISE_NUMBER
,      DIVISION
,      AH_SEQUENCE_NUMBER
,      SEQUENCE_CONTROL
,      INVOICE_NUMBER
,      KID_NUMBER
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV;

Dependencies

[top of page]

APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV references the following:

APPS: FND_NUMBER - show dependent code; PAY_ORG_PAYMENT_METHODS_F

APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV is referenced by following:

PUBLIC: PAY_ORG_PAYMENT_METHODS_F1_DFV