419: ,r_invoice_hdr.attribute7
420: ,r_invoice_hdr.attribute8
421: ,r_invoice_hdr.attribute9
422: ,r_invoice_hdr.attribute_category
423: ,fnd_global.user_id
424: ,sysdate
425: ,null
426: ,r_invoice_hdr.doc_category_code
427: ,r_invoice_hdr.gl_date
433: ,r_invoice_hdr.invoice_date
434: ,r_invoice_hdr.invoice_id
435: ,r_invoice_hdr.vendor_invoice_number
436: ,r_invoice_hdr.invoice_num
437: ,fnd_global.user_id
438: ,sysdate
439: ,fnd_global.login_id
440: ,r_invoice_hdr.org_id
441: ,r_invoice_hdr.payment_method
435: ,r_invoice_hdr.vendor_invoice_number
436: ,r_invoice_hdr.invoice_num
437: ,fnd_global.user_id
438: ,sysdate
439: ,fnd_global.login_id
440: ,r_invoice_hdr.org_id
441: ,r_invoice_hdr.payment_method
442: --start: 01-May-2007 cklee Fixed the following for R12 Disbursement project |
443: ,r_invoice_hdr.payment_method
441: ,r_invoice_hdr.payment_method
442: --start: 01-May-2007 cklee Fixed the following for R12 Disbursement project |
443: ,r_invoice_hdr.payment_method
444: --end: 01-May-2007 cklee Fixed the following for R12 Disbursement project |
445: ,fnd_global.conc_request_id
446: ,'OKL'
447: ,r_invoice_hdr.terms_id
448: ,r_invoice_hdr.vendor_id
449: ,r_invoice_hdr.vendor_site_id
450: ,r_invoice_hdr.workflow_flag
451: ,r_invoice_hdr.pay_group_lookup_code
452: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
453: ,r_invoice_hdr.legal_entity_id
454: ,fnd_global.prog_appl_id
455: ,'OKL_CNSLD_AP_INVS_ALL'
456: ,r_invoice_hdr.cnsld_ap_inv_id
457: ,l_self_bill_invnum
458: ,'Y'
696: ,r_invoice_lines.attribute7
697: ,r_invoice_lines.attribute8
698: ,r_invoice_lines.attribute9
699: ,r_invoice_lines.attribute_category
700: ,fnd_global.user_id
701: ,sysdate
702: --start:| 15-Oct-2007 cklee -- Fixed bug:6502786 |
703: -- ,NVL(r_invoice_lines.dist_code_combination_id, -1) --change for SLA impact
704: ,r_invoice_lines.dist_code_combination_id
704: ,r_invoice_lines.dist_code_combination_id
705: --end:| 15-Oct-2007 cklee -- Fixed bug:6502786 |
706: ,r_invoice_hdr.invoice_id
707: ,r_invoice_lines.invoice_line_id
708: ,fnd_global.user_id
709: ,sysdate
710: ,fnd_global.login_id
711: ,r_invoice_lines.line_number
712: ,r_invoice_lines.line_type
706: ,r_invoice_hdr.invoice_id
707: ,r_invoice_lines.invoice_line_id
708: ,fnd_global.user_id
709: ,sysdate
710: ,fnd_global.login_id
711: ,r_invoice_lines.line_number
712: ,r_invoice_lines.line_type
713: ,r_invoice_lines.org_id
714: ,r_invoice_lines.tax_code
711: ,r_invoice_lines.line_number
712: ,r_invoice_lines.line_type
713: ,r_invoice_lines.org_id
714: ,r_invoice_lines.tax_code
715: ,fnd_global.prog_appl_id
716: ,'OKL_TXL_AP_INV_LNS_ALL_B'
717: ,r_invoice_lines.tpl_id
718: ,l_inventory_org_id --21-Oct-2011 sechawla Bug 12888543 : added inv org id
719: ,trim(substr(trim(substr(l_contract_number,1,100)) || '/' || trim(substr(l_asset_number,1,100)) || '/' || trim(substr(l_stream_type_purpose,1,38)), 1,240))