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 Mandatory Comments
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)
RECONCILIATION_FUNCTION 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)
DELIMITER_TYPE 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)
FOREIGN_TRANSACTION VARCHAR2 (150)
NACHA_DESTINATION_CODE VARCHAR2 (150)
NACHA_DESTINATION_NAME VARCHAR2 (150)
NACHA_ORIGIN_CODE VARCHAR2 (150)
NACHA_ORIGIN_NAME VARCHAR2 (150)
IS_IAT_DUMMY VARCHAR2 (150)
IAT_DESTINATION_QUALIFIER VARCHAR2 (150)
IAT_DESTINATION_COUNTRY VARCHAR2 (150)
IAT_ORIGINATING_DFI_CODE VARCHAR2 (150)
IAT_ORIG_BANK_STREET_ADDR VARCHAR2 (150)
IAT_ORIG_BANK_CITY_STATE VARCHAR2 (150)
IAT_ORIG_BANK_COUNTRY VARCHAR2 (150)
REFERENCE_CODE VARCHAR2 (150)
BALANCED_NACHA_FILE VARCHAR2 (150)
OVERRIDE_COMPANY_ID 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)
RECIPIENT_BANK_NAME VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (2597)
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
,      RECONCILIATION_FUNCTION
,      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
,      DELIMITER_TYPE
,      CREDITOR_CODE
,      CREDITOR_NAME
,      SITE_CODE
,      SITE_NAME
,      GIRO_COMPANY_NAME
,      GIRO_COMPANY_CODE
,      CUSTOMER_ID
,      FOREIGN_TRANSACTION
,      NACHA_DESTINATION_CODE
,      NACHA_DESTINATION_NAME
,      NACHA_ORIGIN_CODE
,      NACHA_ORIGIN_NAME
,      IS_IAT_DUMMY
,      IAT_DESTINATION_QUALIFIER
,      IAT_DESTINATION_COUNTRY
,      IAT_ORIGINATING_DFI_CODE
,      IAT_ORIG_BANK_STREET_ADDR
,      IAT_ORIG_BANK_CITY_STATE
,      IAT_ORIG_BANK_COUNTRY
,      REFERENCE_CODE
,      BALANCED_NACHA_FILE
,      OVERRIDE_COMPANY_ID
,      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
,      RECIPIENT_BANK_NAME
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV;

Dependencies

[top of page]

APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPAY_ORG_PAYMENT_METHODS_F

APPS.PAY_ORG_PAYMENT_METHODS_F1_DFV is not referenced by any database object