DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 4346: oe_transaction_types_tl ott

4342: SELECT
4343: ott.transaction_type_id
4344: FROM
4345: ra_customer_trx_all rct,
4346: oe_transaction_types_tl ott
4347: WHERE
4348: rct.customer_trx_id = pr_new.previous_customer_trx_id
4349: /* bug 4926865. Added by Lakshmi Gopalsami
4350: Removed the upper as the data getting inserted into

Line 4352: oe_transaction_types_tl

4348: rct.customer_trx_id = pr_new.previous_customer_trx_id
4349: /* bug 4926865. Added by Lakshmi Gopalsami
4350: Removed the upper as the data getting inserted into
4351: interface_header_attribute2 will be same as name in
4352: oe_transaction_types_tl
4353: */
4354: AND rct.interface_header_attribute2 = ott.name ;
4355:
4356: /*added by csahoo for bug#6407648, start*/

Line 4367: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;

4363: WHERE
4364: link_to_cust_trx_line_id = pr_new.customer_trx_line_id ;
4365: /*added by csahoo for bug#6407648, end*/
4366:
4367: ln_transaction_type_id OE_TRANSACTION_TYPES_TL.TRANSACTION_TYPE_ID%TYPE;
4368: ln_register_id JAI_OM_OE_BOND_REG_HDRS.REGISTER_ID%TYPE;
4369: lv_register_code JAI_OM_OE_BOND_REG_HDRS.REGISTER_CODE%TYPE;
4370: /*
4371: || End of bug4567935 (115 bug4404898)