230: 'JE.ES.ARXTWMAI.MODELO349', ra_cust.global_attribute5,
231: NULL),
232: substr(itf1.trx_business_category,(instr(itf1.trx_business_category,'MOD',1,1)+3),
233: length(itf1.trx_business_category)),
234: fnd_global.user_id,
235: sysdate,
236: fnd_global.user_id,
237: sysdate,
238: fnd_global.login_id,
232: substr(itf1.trx_business_category,(instr(itf1.trx_business_category,'MOD',1,1)+3),
233: length(itf1.trx_business_category)),
234: fnd_global.user_id,
235: sysdate,
236: fnd_global.user_id,
237: sysdate,
238: fnd_global.login_id,
239: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
240: FROM ra_customer_trx_all ra_cust,
234: fnd_global.user_id,
235: sysdate,
236: fnd_global.user_id,
237: sysdate,
238: fnd_global.login_id,
239: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
240: FROM ra_customer_trx_all ra_cust,
241: zx_rep_trx_detail_t itf1
242: WHERE itf1.trx_id = ra_cust.customer_trx_id
715: 'JE.IL.APXINWKB.INVOICE_INFO', ap_inv.GLOBAL_ATTRIBUTE4,
716: NULL ),
717: substr(itf1.trx_business_category,(instr(itf1.trx_business_category,'MOD',1,1)+3),
718: length(itf1.trx_business_category)),
719: fnd_global.user_id,
720: sysdate,
721: fnd_global.user_id,
722: sysdate,
723: fnd_global.login_id,
717: substr(itf1.trx_business_category,(instr(itf1.trx_business_category,'MOD',1,1)+3),
718: length(itf1.trx_business_category)),
719: fnd_global.user_id,
720: sysdate,
721: fnd_global.user_id,
722: sysdate,
723: fnd_global.login_id,
724: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
725: FROM ap_invoices_all ap_inv,
719: fnd_global.user_id,
720: sysdate,
721: fnd_global.user_id,
722: sysdate,
723: fnd_global.login_id,
724: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
725: FROM ap_invoices_all ap_inv,
726: zx_rep_trx_detail_t itf1
727: WHERE itf1.trx_id = ap_inv.invoice_id
1101: attribute24,
1102: request_id)
1103: SELECT zx_rep_trx_jx_ext_t_s.nextval,
1104: itf1.detail_tax_line_id,
1105: fnd_global.user_id,
1106: sysdate,
1107: fnd_global.user_id,
1108: sysdate,
1109: fnd_global.login_id,
1103: SELECT zx_rep_trx_jx_ext_t_s.nextval,
1104: itf1.detail_tax_line_id,
1105: fnd_global.user_id,
1106: sysdate,
1107: fnd_global.user_id,
1108: sysdate,
1109: fnd_global.login_id,
1110: gjl.tax_type_code,
1111: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1105: fnd_global.user_id,
1106: sysdate,
1107: fnd_global.user_id,
1108: sysdate,
1109: fnd_global.login_id,
1110: gjl.tax_type_code,
1111: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1112: FROM gl_je_lines gjl ,
1113: zx_rep_trx_detail_t itf1