Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE
- payment_order
- SET
- group_payment_sending_id=?
- WHERE
- id IN (
- SELECT
- DISTINCT paymentord1_.id
- FROM
- payment_order paymentord1_
- LEFT OUTER JOIN
- payment paymentpc2_
- ON paymentord1_.payment_id=paymentpc2_.id,
- payment paymentpc3_
- WHERE
- paymentord1_.payment_id=paymentpc3_.id
- AND (
- paymentord1_.payment_cord_order_id IS NULL
- )
- AND (
- paymentord1_.payment_state IN (
- 'INIT' , 'INIT_ONLY_USER' , 'EDIT' , 'EDIT_ONLY_USER' , 'EDIT_ERROR' , 'EDIT_ERROR_ONLY_USER' , 'PARTIAL_APPROVED'
- )
- OR paymentord1_.payment_state='APPROVED'
- AND paymentpc3_.internal_flag=1
- AND paymentord1_.trx_date>=?
- OR paymentord1_.payment_state='APPROVED'
- AND paymentpc3_.internal_flag=0
- AND paymentord1_.trx_date>=?
- )
- AND paymentpc3_.medium='e_bank'
- AND (
- (
- paymentpc2_.money_account_id IS NULL
- )
- AND (
- EXISTS (
- SELECT
- fileupload6_.id
- FROM
- file_upload_meta_data fileupload6_
- LEFT OUTER JOIN
- user_context usercontex7_
- ON fileupload6_.user_context_id=usercontex7_.id
- WHERE
- usercontex7_.authentication_object_id=?
- AND fileupload6_.id=paymentord1_.file_upload_id
- )
- )
- OR (
- EXISTS (
- SELECT
- pos_id
- FROM
- afs_obj_macc moneyaccou8_
- INNER JOIN
- afs_obj_pos moneyaccou8_1_
- ON moneyaccou8_.pos_id=moneyaccou8_1_.obj_id
- INNER JOIN
- afs_obj moneyaccou8_2_
- ON moneyaccou8_.pos_id=moneyaccou8_2_.id
- WHERE
- moneyaccou8_2_.close_date IS NULL
- AND moneyaccou8_2_.bu_id IN (
- ?, ?
- )
- AND EXISTS (
- SELECT
- NULL
- FROM
- afs_obj_access oa ,
- afs_login_access la ,
- authentication_object lo
- WHERE
- oa.access_id = la.access_id
- AND lo.id = la.login_id
- AND lo.close_date IS NULL
- AND oa.obj_id = moneyaccou8_1_.obj_id
- AND oa.bu_id IN (
- ?, ?
- )
- AND la.bu_id IN (
- ?, ?
- )
- AND oa.obj_type_intl_id = 'pos'
- AND la.login_id = ?
- )
- AND pos_id=paymentpc2_.money_account_id
- AND (
- EXISTS (
- SELECT
- obj_id
- FROM
- afs_obj_ips ipspc9_
- INNER JOIN
- afs_obj ipspc9_1_
- ON ipspc9_.obj_id=ipspc9_1_.id
- WHERE
- ipspc9_1_.close_date IS NULL
- AND ipspc9_1_.bu_id IN (
- ?, ?
- )
- AND EXISTS (
- SELECT
- NULL
- FROM
- afs_obj_access oa ,
- afs_login_access la ,
- authentication_object lo
- WHERE
- oa.access_id = la.access_id
- AND lo.id = la.login_id
- AND lo.close_date IS NULL
- AND oa.obj_id = ipspc9_.obj_id
- AND oa.bu_id IN (
- ?, ?
- )
- AND la.bu_id IN (
- ?, ?
- )
- AND oa.obj_type_intl_id = 'ips'
- AND la.login_id = ?
- )
- AND (
- ipspc9_.obj_id IN (
- SELECT
- /*+cardinality(table_array 1)*/ column_value
- FROM
- TABLE(?) table_array
- )
- )
- AND (
- moneyaccou8_1_.cont_id IN (
- SELECT
- portfolios10_.portfolio_set_id
- FROM
- ips_portfolio portfolios10_
- WHERE
- afs_obj_ips.obj_id=portfolios10_.afs_obj_ips_id
- )
- )
- )
- )
- )
- )
- AND (
- paymentpc2_.internal_flag=0
- AND paymentpc2_.salary_payment=1
- AND 1=nvl((SELECT
- loginfctla11_.val_nr
- FROM
- afs_login_fctl_access loginfctla11_,
- afs_code_access codeaccess12_
- WHERE
- loginfctla11_.access_id=codeaccess12_.id
- AND loginfctla11_.login_id=?
- AND loginfctla11_.bu_id=?
- AND codeaccess12_.intl_id=?
- AND loginfctla11_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
- loginfctla13_.val_nr
- FROM
- afs_login_fctl_access loginfctla13_,
- afs_code_access codeaccess14_
- WHERE
- loginfctla13_.access_id=codeaccess14_.id
- AND loginfctla13_.login_id=?
- AND loginfctla13_.bu_id=?
- AND codeaccess14_.intl_id=?
- AND (loginfctla13_.obj_id IS NULL)), 0))
- OR paymentpc2_.salary_payment=0
- AND paymentpc2_.internal_flag=0
- AND 1=nvl((SELECT
- loginfctla15_.val_nr
- FROM
- afs_login_fctl_access loginfctla15_,
- afs_code_access codeaccess16_
- WHERE
- loginfctla15_.access_id=codeaccess16_.id
- AND loginfctla15_.login_id=?
- AND loginfctla15_.bu_id=?
- AND codeaccess16_.intl_id=?
- AND loginfctla15_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
- loginfctla17_.val_nr
- FROM
- afs_login_fctl_access loginfctla17_,
- afs_code_access codeaccess18_
- WHERE
- loginfctla17_.access_id=codeaccess18_.id
- AND loginfctla17_.login_id=?
- AND loginfctla17_.bu_id=?
- AND codeaccess18_.intl_id=?
- AND (loginfctla17_.obj_id IS NULL)), 0))
- OR paymentpc2_.internal_flag=1
- AND 1=nvl((SELECT
- loginfctla19_.val_nr
- FROM
- afs_login_fctl_access loginfctla19_,
- afs_code_access codeaccess20_
- WHERE
- loginfctla19_.access_id=codeaccess20_.id
- AND loginfctla19_.login_id=?
- AND loginfctla19_.bu_id=?
- AND codeaccess20_.intl_id=?
- AND loginfctla19_.obj_id=paymentpc2_.money_account_id), nvl((SELECT
- loginfctla21_.val_nr
- FROM
- afs_login_fctl_access loginfctla21_,
- afs_code_access codeaccess22_
- WHERE
- loginfctla21_.access_id=codeaccess22_.id
- AND loginfctla21_.login_id=?
- AND loginfctla21_.bu_id=?
- AND codeaccess22_.intl_id=?
- AND (loginfctla21_.obj_id IS NULL)), 0))
- )
- )
- AND (
- paymentord1_.id IN (
- SELECT
- /*+cardinality(table_array 1)*/ column_value
- FROM
- TABLE(?) table_array
- )
- )
- AND paymentord1_.trx_date>=?
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement