DBA Data[Home] [Help]

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on RA_INTERFACE_LINES_ALL

Line 236: from ra_interfacE_lines_all

232: --start additions for bug#7661892
233: Cursor c_get_orgn
234: is
235: select warehouse_id,interface_line_attribute6
236: from ra_interfacE_lines_all
237: where interfacE_line_context= 'ORDER ENTRY'
238: and line_type='LINE'
239: and interface_line_id=v_customer_trx_line_id;
240:

Line 245: FROM jai_pa_draft_invoices a, ra_interface_lines_all b, pa_projects_all c

241: --added for bug#9151886
242: CURSOR c_get_orgn_project
243: IS
244: SELECT a.organization_id, a.location_id
245: FROM jai_pa_draft_invoices a, ra_interface_lines_all b, pa_projects_all c
246: WHERE b.interface_line_context = 'PROJECTS INVOICES'
247: AND b.line_type = 'LINE'
248: AND b.interface_line_attribute1 = c.segment1
249: AND c.project_id = a.project_id