VIEW: APPS.IBY_PAY_INSTRUCTIONS_SEC_V

Source

View Text - Preformatted

SELECT i.attribute14 attribute14, i.attribute15 attribute15, i.regulatory_report_created_flag regulatory_report_created_flag, i.legal_entity_id legal_entity_id, i.payment_count payment_count, i.created_by created_by, i.creation_date creation_date, i.remittance_advice_created_flag remittance_advice_created_flag, i.attribute13 attribute13, i.payment_instruction_id payment_instruction_id, i.payment_profile_id payment_profile_id, i.process_type process_type, i.payment_instruction_status payment_instruction_status, i.payments_complete_code payments_complete_code, i.generate_sep_remit_advice_flag generate_sep_remit_advice_flag, i.attribute8 attribute8, i.attribute9 attribute9, i.attribute10 attribute10, i.attribute11 attribute11, i.attribute12 attribute12, i.last_updated_by last_updated_by, i.last_update_date last_update_date, i.last_update_login last_update_login, i.object_version_number object_version_number, i.internal_bank_account_id internal_bank_account_id, i.pay_admin_assigned_ref_code pay_admin_assigned_ref_code, i.transmission_date transmission_date, i.acknowledgement_date acknowledgement_date, i.comments comments, i.bank_assigned_ref_code bank_assigned_ref_code, i.org_id org_id, i.org_type org_type, i.payment_date payment_date, i.payment_currency_code payment_currency_code, i.payment_service_request_id payment_service_request_id, i.payment_function payment_function, i.payment_reason_code payment_reason_code, i.bill_payable_flag bill_payable_flag, i.attribute_category attribute_category, i.attribute1 attribute1, i.attribute2 attribute2, i.attribute3 attribute3, i.attribute4 attribute4, i.attribute5 attribute5, i.attribute6 attribute6, i.attribute7 attribute7, i.positive_pay_file_created_flag positive_pay_file_created_flag, i.rfc_identifier rfc_identifier, i.payment_reason_comments payment_reason_comments, i.payment_document_id payment_document_id, i.print_instruction_immed_flag print_instruction_immed_flag, i.transmit_instr_immed_flag transmit_instr_immed_flag, i.printer_name printer_name, i.request_id request_id FROM IBY_PAY_INSTRUCTIONS_ALL I WHERE EXISTS ( SELECT po.org_id FROM iby_process_orgs po WHERE po.object_id = i.payment_instruction_id AND po.object_type = 'PAYMENT_INSTRUCTION' AND (po.org_id, po.org_type) IN ( SELECT uo.organization_id, uo.organization_type FROM ce_security_profiles_v uo) ) AND EXISTS ( SELECT fs.payment_function FROM iby_process_functions fs WHERE fs.object_id = i.payment_instruction_id AND fs.object_type = 'PAYMENT_INSTRUCTION' AND fs.payment_function IN ( SELECT fu.payment_function FROM iby_user_pay_funs_sec_v fu) )

View Text - HTML Formatted

SELECT I.ATTRIBUTE14 ATTRIBUTE14
, I.ATTRIBUTE15 ATTRIBUTE15
, I.REGULATORY_REPORT_CREATED_FLAG REGULATORY_REPORT_CREATED_FLAG
, I.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, I.PAYMENT_COUNT PAYMENT_COUNT
, I.CREATED_BY CREATED_BY
, I.CREATION_DATE CREATION_DATE
, I.REMITTANCE_ADVICE_CREATED_FLAG REMITTANCE_ADVICE_CREATED_FLAG
, I.ATTRIBUTE13 ATTRIBUTE13
, I.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID
, I.PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, I.PROCESS_TYPE PROCESS_TYPE
, I.PAYMENT_INSTRUCTION_STATUS PAYMENT_INSTRUCTION_STATUS
, I.PAYMENTS_COMPLETE_CODE PAYMENTS_COMPLETE_CODE
, I.GENERATE_SEP_REMIT_ADVICE_FLAG GENERATE_SEP_REMIT_ADVICE_FLAG
, I.ATTRIBUTE8 ATTRIBUTE8
, I.ATTRIBUTE9 ATTRIBUTE9
, I.ATTRIBUTE10 ATTRIBUTE10
, I.ATTRIBUTE11 ATTRIBUTE11
, I.ATTRIBUTE12 ATTRIBUTE12
, I.LAST_UPDATED_BY LAST_UPDATED_BY
, I.LAST_UPDATE_DATE LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, I.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, I.INTERNAL_BANK_ACCOUNT_ID INTERNAL_BANK_ACCOUNT_ID
, I.PAY_ADMIN_ASSIGNED_REF_CODE PAY_ADMIN_ASSIGNED_REF_CODE
, I.TRANSMISSION_DATE TRANSMISSION_DATE
, I.ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE
, I.COMMENTS COMMENTS
, I.BANK_ASSIGNED_REF_CODE BANK_ASSIGNED_REF_CODE
, I.ORG_ID ORG_ID
, I.ORG_TYPE ORG_TYPE
, I.PAYMENT_DATE PAYMENT_DATE
, I.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, I.PAYMENT_SERVICE_REQUEST_ID PAYMENT_SERVICE_REQUEST_ID
, I.PAYMENT_FUNCTION PAYMENT_FUNCTION
, I.PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, I.BILL_PAYABLE_FLAG BILL_PAYABLE_FLAG
, I.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1 ATTRIBUTE1
, I.ATTRIBUTE2 ATTRIBUTE2
, I.ATTRIBUTE3 ATTRIBUTE3
, I.ATTRIBUTE4 ATTRIBUTE4
, I.ATTRIBUTE5 ATTRIBUTE5
, I.ATTRIBUTE6 ATTRIBUTE6
, I.ATTRIBUTE7 ATTRIBUTE7
, I.POSITIVE_PAY_FILE_CREATED_FLAG POSITIVE_PAY_FILE_CREATED_FLAG
, I.RFC_IDENTIFIER RFC_IDENTIFIER
, I.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, I.PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID
, I.PRINT_INSTRUCTION_IMMED_FLAG PRINT_INSTRUCTION_IMMED_FLAG
, I.TRANSMIT_INSTR_IMMED_FLAG TRANSMIT_INSTR_IMMED_FLAG
, I.PRINTER_NAME PRINTER_NAME
, I.REQUEST_ID REQUEST_ID
FROM IBY_PAY_INSTRUCTIONS_ALL I
WHERE EXISTS ( SELECT PO.ORG_ID
FROM IBY_PROCESS_ORGS PO
WHERE PO.OBJECT_ID = I.PAYMENT_INSTRUCTION_ID
AND PO.OBJECT_TYPE = 'PAYMENT_INSTRUCTION'
AND (PO.ORG_ID
, PO.ORG_TYPE) IN ( SELECT UO.ORGANIZATION_ID
, UO.ORGANIZATION_TYPE
FROM CE_SECURITY_PROFILES_V UO) )
AND EXISTS ( SELECT FS.PAYMENT_FUNCTION
FROM IBY_PROCESS_FUNCTIONS FS
WHERE FS.OBJECT_ID = I.PAYMENT_INSTRUCTION_ID
AND FS.OBJECT_TYPE = 'PAYMENT_INSTRUCTION'
AND FS.PAYMENT_FUNCTION IN ( SELECT FU.PAYMENT_FUNCTION
FROM IBY_USER_PAY_FUNS_SEC_V FU) )