APPS.JL_ZZ_AUTO_INVOICE dependencies on OE_ORDER_LINES

Line 574: FROM oe_order_lines a, ra_interface_lines_gt b

570:
571: BEGIN
572: SELECT return_context
573: INTO x_return_context
574: FROM oe_order_lines a, ra_interface_lines_gt b
575: WHERE a.line_id = b.interface_line_attribute6
576: AND b.interface_line_id = p_interface_line_id;
577:
578: EXCEPTION WHEN OTHERS THEN

Line 1292: FROM oe_order_lines ol,

1288: l_so_org_id := to_number(oe_profile.value('SO_ORGANIZATION_ID'));
1289: BEGIN
1290: SELECT fnd_date.canonical_to_date(ol.global_attribute16) --service_execution_date
1291: INTO l_service_exec_date
1292: FROM oe_order_lines ol,
1293: mtl_system_items msi
1294: WHERE line_id = trx_line_record.interface_line_attribute6
1295: AND msi.inventory_item_id(+) = trx_line_record.inventory_item_id
1296: AND msi.organization_id = l_so_org_id;