VIEW: APPS.IBY_EXT_FD_PMT_1_0_VT

Source

View Text - Preformatted

SELECT pmt.payment_instruction_id, pmt.payment_id, pmt.internal_bank_account_id, pmt.legal_entity_id, req.calling_app_id, fndapp.application_short_name, pmt.payment_service_request_id, pmt.payment_function, payment_function_lookup.meaning, pmt.org_id, pmt.org_type, org_type_lookup.meaning, ce_sp.name, pmt.document_category_code, fnd_doc_seq.name, pmt.document_sequence_value, pmt.payment_reference_number, pmt.paper_document_number, pmt.payment_date, pmt.payment_due_date, pmt.maturity_date, pmt.payment_status, payment_status_lookup.meaning, pmt.payee_party_id, pmt.party_site_id, pmt.external_bank_account_id, pmt.payment_amount, pmt.payment_currency_code, iby_fd_extract_gen_pvt.get_payment_amount_text(pmt.payment_id), pmt.payment_method_code, payment_methods.payment_method_name, payment_methods.attribute_category, pmt.exclusive_payment_flag, pmt.settlement_priority, settlement_priority_lookup.meaning, iby_fd_extract_gen_pvt.get_payment_amount_withheld(pmt.payment_id), pmt.discount_amount_taken, pmt.bank_charge_bearer, bank_charge_bearer_lookup.meaning, pmt.bank_charge_amount, pmt.delivery_channel_code, delivery_channels.meaning, delivery_channels.format_value, pmt.bank_instruction1_code, bank_instructions1.meaning, bank_instructions1.format_value, pmt.bank_instruction2_code, bank_instructions2.meaning, bank_instructions2.format_value, pmt.bank_instruction_details, pmt.payment_text_message1, pmt.payment_text_message2, pmt.payment_text_message3, pmt.payment_details, pmt.unique_remittance_identifier, pmt.uri_check_digit, pmt.payment_reason_code, payment_reasons.meaning, payment_reasons.format_value, pmt.payment_reason_comments, pmt.remittance_message1, pmt.remittance_message2, pmt.remittance_message3, pmt.declare_payment_flag, pmt.declaration_amount, pmt.declaration_currency_code, iby_fd_extract_gen_pvt.get_allotment_code(pmt.payment_id), iby_fd_extract_gen_pvt.top_offset_eligibility_flag(pmt.payment_id), pmt.attribute_category, nvl(pmt.beneficiary_name, pmt.payee_name), iby_fd_extract_gen_pvt.get_sps_pmt_ts(pmt.payment_id), pmt.employee_payment_flag, nvl(payment_methods.format_value, pmt.payment_method_code), /*LKQ POS PAY ISSUE - PAVAN*/ pmt.positive_pay_file_created_flag, pmt.void_date, pmt.logical_group_reference, pmt.payment_profile_id,pmt.anticipated_value_date FROM iby_payments_all pmt, iby_pay_service_requests req, fnd_application fndapp, fnd_document_sequences fnd_doc_seq, iby_payment_methods_vl payment_methods, iby_delivery_channels_vl delivery_channels, iby_bank_instructions_vl bank_instructions1, iby_bank_instructions_vl bank_instructions2, iby_payment_reasons_vl payment_reasons, fnd_lookups payment_function_lookup, fnd_lookups payment_status_lookup, fnd_lookups settlement_priority_lookup, fnd_lookups bank_charge_bearer_lookup, fnd_lookups org_type_lookup, ce_security_profiles_gt ce_sp /*LKQ POS PAY ISSUE - PAVAN*/ WHERE pmt.payment_service_request_id = req.payment_service_request_id /*LKQ POS PAY ISSUE - PAVAN*/ AND req.calling_app_id = fndapp.application_id AND pmt.document_sequence_id = fnd_doc_seq.doc_sequence_id(+) AND pmt.payment_method_code = payment_methods.payment_method_code AND pmt.org_id = ce_sp.organization_id AND pmt.org_type = ce_sp.organization_type AND pmt.delivery_channel_code = delivery_channels.delivery_channel_code(+) AND pmt.bank_instruction1_code = bank_instructions1.bank_instruction_code(+) AND pmt.bank_instruction2_code = bank_instructions2.bank_instruction_code(+) AND pmt.payment_reason_code = payment_reasons.payment_reason_code(+) AND pmt.payment_function = payment_function_lookup.lookup_code AND payment_function_lookup.lookup_type = 'IBY_PAYMENT_FUNCTIONS' AND pmt.payment_status = payment_status_lookup.lookup_code AND payment_status_lookup.lookup_type = 'IBY_PAYMENT_STATUSES' AND pmt.settlement_priority = settlement_priority_lookup.lookup_code(+) AND settlement_priority_lookup.lookup_type(+) = 'IBY_SETTLEMENT_PRIORITY' AND pmt.bank_charge_bearer = bank_charge_bearer_lookup.lookup_code(+) AND bank_charge_bearer_lookup.lookup_type(+) = 'IBY_BANK_CHARGE_BEARER' AND pmt.org_type = org_type_lookup.lookup_code AND org_type_lookup.lookup_type = 'IBY_ORGANIZATION_TYPES' AND pmt.payment_status NOT IN('VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT') UNION ALL SELECT pmt.payment_instruction_id, pmt.payment_id, pmt.internal_bank_account_id, pmt.legal_entity_id, NULL, /*req.calling_app_id,*/ NULL, /*fndapp.application_short_name,*/ pmt.payment_service_request_id, pmt.payment_function, NULL, /*payment_function_lookup.meaning,*/ pmt.org_id, pmt.org_type, NULL, /*org_type_lookup.meaning,*/ NULL, /*ce_sp.name,*/ pmt.document_category_code, NULL, /*fnd_doc_seq.name,*/ pmt.document_sequence_value, pmt.payment_reference_number, pmt.paper_document_number, pmt.payment_date, pmt.payment_due_date, pmt.maturity_date, pmt.payment_status, payment_status_lookup.meaning, pmt.payee_party_id, pmt.party_site_id, pmt.external_bank_account_id, pmt.payment_amount, pmt.payment_currency_code, NULL, /*IBY_FD_EXTRACT_GEN_PVT.Get_Payment_Amount_Text(pmt.payment_id),*/ pmt.payment_method_code, NULL, /*payment_methods.payment_method_name,*/ NULL, /*payment_methods.attribute_category,*/ pmt.exclusive_payment_flag, pmt.settlement_priority, NULL, /*settlement_priority_lookup.meaning,*/ NULL, /*IBY_FD_EXTRACT_GEN_PVT.Get_Payment_Amount_Withheld(pmt.payment_id),*/ pmt.discount_amount_taken, pmt.bank_charge_bearer, NULL, /*bank_charge_bearer_lookup.meaning,*/ pmt.bank_charge_amount, pmt.delivery_channel_code, NULL, /*delivery_channels.meaning,*/ NULL, /*delivery_channels.format_value,*/ pmt.bank_instruction1_code, NULL, /*bank_instructions1.meaning,*/ NULL, /*bank_instructions1.format_value,*/ pmt.bank_instruction2_code, NULL, /*bank_instructions2.meaning,*/ NULL, /*bank_instructions2.format_value,*/ pmt.bank_instruction_details, pmt.payment_text_message1, pmt.payment_text_message2, pmt.payment_text_message3, pmt.payment_details, pmt.unique_remittance_identifier, pmt.uri_check_digit, pmt.payment_reason_code, NULL, /*payment_reasons.meaning,*/ NULL, /*payment_reasons.format_value,*/ pmt.payment_reason_comments, pmt.remittance_message1, pmt.remittance_message2, pmt.remittance_message3, pmt.declare_payment_flag, pmt.declaration_amount, pmt.declaration_currency_code, NULL, /*IBY_FD_EXTRACT_GEN_PVT.get_Allotment_Code(pmt.payment_id),*/ NULL, /*IBY_FD_EXTRACT_GEN_PVT.TOP_Offset_Eligibility_Flag(pmt.payment_id),*/ pmt.attribute_category, nvl(pmt.beneficiary_name, pmt.payee_name), NULL, /*IBY_FD_EXTRACT_GEN_PVT.get_SPS_PMT_TS(pmt.payment_id),*/ pmt.employee_payment_flag, NULL, /*nvl(payment_methods.format_value, pmt.payment_method_code)*/ /*LKQ POS PAY ISSUE - PAVAN*/ pmt.positive_pay_file_created_flag, pmt.void_date, /* SEPA */ pmt.logical_group_reference, pmt.payment_profile_id,pmt.anticipated_value_date FROM iby_payments_all pmt, /*iby_pay_service_requests req,*/ /*fnd_application fndapp,*/ /*fnd_document_sequences fnd_doc_seq, */ /*iby_payment_methods_vl payment_methods,*/ /*iby_delivery_channels_vl delivery_channels,*/ /*iby_bank_instructions_vl bank_instructions1,*/ /*iby_bank_instructions_vl bank_instructions2,*/ /*iby_payment_reasons_vl payment_reasons,*/ /*fnd_lookups payment_function_lookup,*/ fnd_lookups payment_status_lookup /*fnd_lookups settlement_priority_lookup,*/ /*fnd_lookups bank_charge_bearer_lookup,*/ /*fnd_lookups org_type_lookup,*/ /*ce_security_profiles_gt ce_sp*/ WHERE pmt.payment_status IN('VOID_BY_SETUP', 'VOID_BY_OVERFLOW', 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT') AND pmt.payment_status = payment_status_lookup.lookup_code AND payment_status_lookup.lookup_type = 'IBY_PAYMENT_STATUSES' /*LKQ POS PAY ISSUE - PAVAN*/

View Text - HTML Formatted

SELECT PMT.PAYMENT_INSTRUCTION_ID
, PMT.PAYMENT_ID
, PMT.INTERNAL_BANK_ACCOUNT_ID
, PMT.LEGAL_ENTITY_ID
, REQ.CALLING_APP_ID
, FNDAPP.APPLICATION_SHORT_NAME
, PMT.PAYMENT_SERVICE_REQUEST_ID
, PMT.PAYMENT_FUNCTION
, PAYMENT_FUNCTION_LOOKUP.MEANING
, PMT.ORG_ID
, PMT.ORG_TYPE
, ORG_TYPE_LOOKUP.MEANING
, CE_SP.NAME
, PMT.DOCUMENT_CATEGORY_CODE
, FND_DOC_SEQ.NAME
, PMT.DOCUMENT_SEQUENCE_VALUE
, PMT.PAYMENT_REFERENCE_NUMBER
, PMT.PAPER_DOCUMENT_NUMBER
, PMT.PAYMENT_DATE
, PMT.PAYMENT_DUE_DATE
, PMT.MATURITY_DATE
, PMT.PAYMENT_STATUS
, PAYMENT_STATUS_LOOKUP.MEANING
, PMT.PAYEE_PARTY_ID
, PMT.PARTY_SITE_ID
, PMT.EXTERNAL_BANK_ACCOUNT_ID
, PMT.PAYMENT_AMOUNT
, PMT.PAYMENT_CURRENCY_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_TEXT(PMT.PAYMENT_ID)
, PMT.PAYMENT_METHOD_CODE
, PAYMENT_METHODS.PAYMENT_METHOD_NAME
, PAYMENT_METHODS.ATTRIBUTE_CATEGORY
, PMT.EXCLUSIVE_PAYMENT_FLAG
, PMT.SETTLEMENT_PRIORITY
, SETTLEMENT_PRIORITY_LOOKUP.MEANING
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_WITHHELD(PMT.PAYMENT_ID)
, PMT.DISCOUNT_AMOUNT_TAKEN
, PMT.BANK_CHARGE_BEARER
, BANK_CHARGE_BEARER_LOOKUP.MEANING
, PMT.BANK_CHARGE_AMOUNT
, PMT.DELIVERY_CHANNEL_CODE
, DELIVERY_CHANNELS.MEANING
, DELIVERY_CHANNELS.FORMAT_VALUE
, PMT.BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTIONS1.MEANING
, BANK_INSTRUCTIONS1.FORMAT_VALUE
, PMT.BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTIONS2.MEANING
, BANK_INSTRUCTIONS2.FORMAT_VALUE
, PMT.BANK_INSTRUCTION_DETAILS
, PMT.PAYMENT_TEXT_MESSAGE1
, PMT.PAYMENT_TEXT_MESSAGE2
, PMT.PAYMENT_TEXT_MESSAGE3
, PMT.PAYMENT_DETAILS
, PMT.UNIQUE_REMITTANCE_IDENTIFIER
, PMT.URI_CHECK_DIGIT
, PMT.PAYMENT_REASON_CODE
, PAYMENT_REASONS.MEANING
, PAYMENT_REASONS.FORMAT_VALUE
, PMT.PAYMENT_REASON_COMMENTS
, PMT.REMITTANCE_MESSAGE1
, PMT.REMITTANCE_MESSAGE2
, PMT.REMITTANCE_MESSAGE3
, PMT.DECLARE_PAYMENT_FLAG
, PMT.DECLARATION_AMOUNT
, PMT.DECLARATION_CURRENCY_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_ALLOTMENT_CODE(PMT.PAYMENT_ID)
, IBY_FD_EXTRACT_GEN_PVT.TOP_OFFSET_ELIGIBILITY_FLAG(PMT.PAYMENT_ID)
, PMT.ATTRIBUTE_CATEGORY
, NVL(PMT.BENEFICIARY_NAME
, PMT.PAYEE_NAME)
, IBY_FD_EXTRACT_GEN_PVT.GET_SPS_PMT_TS(PMT.PAYMENT_ID)
, PMT.EMPLOYEE_PAYMENT_FLAG
, NVL(PAYMENT_METHODS.FORMAT_VALUE
, PMT.PAYMENT_METHOD_CODE)
, /*LKQ POS PAY ISSUE - PAVAN*/ PMT.POSITIVE_PAY_FILE_CREATED_FLAG
, PMT.VOID_DATE
, PMT.LOGICAL_GROUP_REFERENCE
, PMT.PAYMENT_PROFILE_ID
, PMT.ANTICIPATED_VALUE_DATE
FROM IBY_PAYMENTS_ALL PMT
, IBY_PAY_SERVICE_REQUESTS REQ
, FND_APPLICATION FNDAPP
, FND_DOCUMENT_SEQUENCES FND_DOC_SEQ
, IBY_PAYMENT_METHODS_VL PAYMENT_METHODS
, IBY_DELIVERY_CHANNELS_VL DELIVERY_CHANNELS
, IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS1
, IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS2
, IBY_PAYMENT_REASONS_VL PAYMENT_REASONS
, FND_LOOKUPS PAYMENT_FUNCTION_LOOKUP
, FND_LOOKUPS PAYMENT_STATUS_LOOKUP
, FND_LOOKUPS SETTLEMENT_PRIORITY_LOOKUP
, FND_LOOKUPS BANK_CHARGE_BEARER_LOOKUP
, FND_LOOKUPS ORG_TYPE_LOOKUP
, CE_SECURITY_PROFILES_GT CE_SP /*LKQ POS PAY ISSUE - PAVAN*/
WHERE PMT.PAYMENT_SERVICE_REQUEST_ID = REQ.PAYMENT_SERVICE_REQUEST_ID /*LKQ POS PAY ISSUE - PAVAN*/
AND REQ.CALLING_APP_ID = FNDAPP.APPLICATION_ID
AND PMT.DOCUMENT_SEQUENCE_ID = FND_DOC_SEQ.DOC_SEQUENCE_ID(+)
AND PMT.PAYMENT_METHOD_CODE = PAYMENT_METHODS.PAYMENT_METHOD_CODE
AND PMT.ORG_ID = CE_SP.ORGANIZATION_ID
AND PMT.ORG_TYPE = CE_SP.ORGANIZATION_TYPE
AND PMT.DELIVERY_CHANNEL_CODE = DELIVERY_CHANNELS.DELIVERY_CHANNEL_CODE(+)
AND PMT.BANK_INSTRUCTION1_CODE = BANK_INSTRUCTIONS1.BANK_INSTRUCTION_CODE(+)
AND PMT.BANK_INSTRUCTION2_CODE = BANK_INSTRUCTIONS2.BANK_INSTRUCTION_CODE(+)
AND PMT.PAYMENT_REASON_CODE = PAYMENT_REASONS.PAYMENT_REASON_CODE(+)
AND PMT.PAYMENT_FUNCTION = PAYMENT_FUNCTION_LOOKUP.LOOKUP_CODE
AND PAYMENT_FUNCTION_LOOKUP.LOOKUP_TYPE = 'IBY_PAYMENT_FUNCTIONS'
AND PMT.PAYMENT_STATUS = PAYMENT_STATUS_LOOKUP.LOOKUP_CODE
AND PAYMENT_STATUS_LOOKUP.LOOKUP_TYPE = 'IBY_PAYMENT_STATUSES'
AND PMT.SETTLEMENT_PRIORITY = SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_CODE(+)
AND SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_TYPE(+) = 'IBY_SETTLEMENT_PRIORITY'
AND PMT.BANK_CHARGE_BEARER = BANK_CHARGE_BEARER_LOOKUP.LOOKUP_CODE(+)
AND BANK_CHARGE_BEARER_LOOKUP.LOOKUP_TYPE(+) = 'IBY_BANK_CHARGE_BEARER'
AND PMT.ORG_TYPE = ORG_TYPE_LOOKUP.LOOKUP_CODE
AND ORG_TYPE_LOOKUP.LOOKUP_TYPE = 'IBY_ORGANIZATION_TYPES'
AND PMT.PAYMENT_STATUS NOT IN('VOID_BY_SETUP'
, 'VOID_BY_OVERFLOW'
, 'VOID_BY_SETUP_REPRINT'
, 'VOID_BY_OVERFLOW_REPRINT') UNION ALL SELECT PMT.PAYMENT_INSTRUCTION_ID
, PMT.PAYMENT_ID
, PMT.INTERNAL_BANK_ACCOUNT_ID
, PMT.LEGAL_ENTITY_ID
, NULL
, /*REQ.CALLING_APP_ID
, */ NULL
, /*FNDAPP.APPLICATION_SHORT_NAME
, */ PMT.PAYMENT_SERVICE_REQUEST_ID
, PMT.PAYMENT_FUNCTION
, NULL
, /*PAYMENT_FUNCTION_LOOKUP.MEANING
, */ PMT.ORG_ID
, PMT.ORG_TYPE
, NULL
, /*ORG_TYPE_LOOKUP.MEANING
, */ NULL
, /*CE_SP.NAME
, */ PMT.DOCUMENT_CATEGORY_CODE
, NULL
, /*FND_DOC_SEQ.NAME
, */ PMT.DOCUMENT_SEQUENCE_VALUE
, PMT.PAYMENT_REFERENCE_NUMBER
, PMT.PAPER_DOCUMENT_NUMBER
, PMT.PAYMENT_DATE
, PMT.PAYMENT_DUE_DATE
, PMT.MATURITY_DATE
, PMT.PAYMENT_STATUS
, PAYMENT_STATUS_LOOKUP.MEANING
, PMT.PAYEE_PARTY_ID
, PMT.PARTY_SITE_ID
, PMT.EXTERNAL_BANK_ACCOUNT_ID
, PMT.PAYMENT_AMOUNT
, PMT.PAYMENT_CURRENCY_CODE
, NULL
, /*IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_TEXT(PMT.PAYMENT_ID)
, */ PMT.PAYMENT_METHOD_CODE
, NULL
, /*PAYMENT_METHODS.PAYMENT_METHOD_NAME
, */ NULL
, /*PAYMENT_METHODS.ATTRIBUTE_CATEGORY
, */ PMT.EXCLUSIVE_PAYMENT_FLAG
, PMT.SETTLEMENT_PRIORITY
, NULL
, /*SETTLEMENT_PRIORITY_LOOKUP.MEANING
, */ NULL
, /*IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_WITHHELD(PMT.PAYMENT_ID)
, */ PMT.DISCOUNT_AMOUNT_TAKEN
, PMT.BANK_CHARGE_BEARER
, NULL
, /*BANK_CHARGE_BEARER_LOOKUP.MEANING
, */ PMT.BANK_CHARGE_AMOUNT
, PMT.DELIVERY_CHANNEL_CODE
, NULL
, /*DELIVERY_CHANNELS.MEANING
, */ NULL
, /*DELIVERY_CHANNELS.FORMAT_VALUE
, */ PMT.BANK_INSTRUCTION1_CODE
, NULL
, /*BANK_INSTRUCTIONS1.MEANING
, */ NULL
, /*BANK_INSTRUCTIONS1.FORMAT_VALUE
, */ PMT.BANK_INSTRUCTION2_CODE
, NULL
, /*BANK_INSTRUCTIONS2.MEANING
, */ NULL
, /*BANK_INSTRUCTIONS2.FORMAT_VALUE
, */ PMT.BANK_INSTRUCTION_DETAILS
, PMT.PAYMENT_TEXT_MESSAGE1
, PMT.PAYMENT_TEXT_MESSAGE2
, PMT.PAYMENT_TEXT_MESSAGE3
, PMT.PAYMENT_DETAILS
, PMT.UNIQUE_REMITTANCE_IDENTIFIER
, PMT.URI_CHECK_DIGIT
, PMT.PAYMENT_REASON_CODE
, NULL
, /*PAYMENT_REASONS.MEANING
, */ NULL
, /*PAYMENT_REASONS.FORMAT_VALUE
, */ PMT.PAYMENT_REASON_COMMENTS
, PMT.REMITTANCE_MESSAGE1
, PMT.REMITTANCE_MESSAGE2
, PMT.REMITTANCE_MESSAGE3
, PMT.DECLARE_PAYMENT_FLAG
, PMT.DECLARATION_AMOUNT
, PMT.DECLARATION_CURRENCY_CODE
, NULL
, /*IBY_FD_EXTRACT_GEN_PVT.GET_ALLOTMENT_CODE(PMT.PAYMENT_ID)
, */ NULL
, /*IBY_FD_EXTRACT_GEN_PVT.TOP_OFFSET_ELIGIBILITY_FLAG(PMT.PAYMENT_ID)
, */ PMT.ATTRIBUTE_CATEGORY
, NVL(PMT.BENEFICIARY_NAME
, PMT.PAYEE_NAME)
, NULL
, /*IBY_FD_EXTRACT_GEN_PVT.GET_SPS_PMT_TS(PMT.PAYMENT_ID)
, */ PMT.EMPLOYEE_PAYMENT_FLAG
, NULL
, /*NVL(PAYMENT_METHODS.FORMAT_VALUE
, PMT.PAYMENT_METHOD_CODE)*/ /*LKQ POS PAY ISSUE - PAVAN*/ PMT.POSITIVE_PAY_FILE_CREATED_FLAG
, PMT.VOID_DATE
, /* SEPA */ PMT.LOGICAL_GROUP_REFERENCE
, PMT.PAYMENT_PROFILE_ID
, PMT.ANTICIPATED_VALUE_DATE
FROM IBY_PAYMENTS_ALL PMT
, /*IBY_PAY_SERVICE_REQUESTS REQ
, */ /*FND_APPLICATION FNDAPP
, */ /*FND_DOCUMENT_SEQUENCES FND_DOC_SEQ
, */ /*IBY_PAYMENT_METHODS_VL PAYMENT_METHODS
, */ /*IBY_DELIVERY_CHANNELS_VL DELIVERY_CHANNELS
, */ /*IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS1
, */ /*IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS2
, */ /*IBY_PAYMENT_REASONS_VL PAYMENT_REASONS
, */ /*FND_LOOKUPS PAYMENT_FUNCTION_LOOKUP
, */ FND_LOOKUPS PAYMENT_STATUS_LOOKUP /*FND_LOOKUPS SETTLEMENT_PRIORITY_LOOKUP
, */ /*FND_LOOKUPS BANK_CHARGE_BEARER_LOOKUP
, */ /*FND_LOOKUPS ORG_TYPE_LOOKUP
, */ /*CE_SECURITY_PROFILES_GT CE_SP*/
WHERE PMT.PAYMENT_STATUS IN('VOID_BY_SETUP'
, 'VOID_BY_OVERFLOW'
, 'VOID_BY_SETUP_REPRINT'
, 'VOID_BY_OVERFLOW_REPRINT')
AND PMT.PAYMENT_STATUS = PAYMENT_STATUS_LOOKUP.LOOKUP_CODE
AND PAYMENT_STATUS_LOOKUP.LOOKUP_TYPE = 'IBY_PAYMENT_STATUSES' /*LKQ POS PAY ISSUE - PAVAN*/